SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:26 AM
| ||||
| ||||
 Can I replicate database "foo" to database "bar" Let's say that I have two servers, server M with database "foo" and server S with database "bar", with full control over them. Can I set up replication so that "foo" is replicated into "bar". (the issue is that I have many masters with the same database name foo, and I want to have one slave server with databases like foo-1, foo-2 etc, replicated from all those masters) i      |
|
02-28-2008, 10:26 AM
| |||
| |||
| Re: Can I replicate database "foo" to database "bar" On 14 Aug, 22:55, Ignoramus32732 <ignoramus32...@NOSPAM.32732.invalid> wrote: > Let's say that I have two servers, server M with database "foo" and > server S with database "bar", with full control over them. Can I set > up replication so that "foo" is replicated into "bar". > > (the issue is that I have many masters with the same database name foo, > and I want to have one slave server with databases like foo-1, foo-2 > etc, replicated from all those masters) > > i If you serach in mySQL handbook there is a artikel how to do it,, with mySQL 5 and above 15.4. How to Set Up Replication http://dev.mysql.com/doc/refman/5.0/...ion-howto.html // Anders |
|
02-28-2008, 10:26 AM
| ||||
| ||||
| Re: Can I replicate database "foo" to database "bar" Ignoramus32732 <ignoramus32732@NOSPAM.32732.invalid> wrote: > Let's say that I have two servers, server M with database "foo" and > server S with database "bar", with full control over them. Can I set > up replication so that "foo" is replicated into "bar". There is limited support for that by using the --replicate-rewrite-db option on the slave. For details, see: http://dev.mysql.com/doc/refman/5.0/...n-options.html > (the issue is that I have many masters with the same database name foo, > and I want to have one slave server with databases like foo-1, foo-2 > etc, replicated from all those masters) This is impossible. A replication slave can listen to one single master only. XL -- Axel Schwenke, Support Engineer, MySQL AB Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/ MySQL User Forums: http://forums.mysql.com/ |
 |
« counting rows, help with query
|
ANN: MicroOLAP Database Designer for MySQL 1.9.5 has been released »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:37 AM.
