MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Adding a second database to replication... How?
Posted by: Kathy Mazur Worden
Date: September 07, 2007 03:07PM

If the new db is on the same server as the old db and you did not specify "replicate-do-db" or "replicate-do-table" to narrow down what dbs and/or tables are replicated then the new db will be replicated automatically.

If the new db is on a different server you cannot have the slave use 2 masters.

http://dev.mysql.com/doc/refman/5.0/en/replication-options.html has info about the replication options.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Adding a second database to replication... How?
18162
David Strang
September 06, 2007 09:40PM
Re: Adding a second database to replication... How?
12294
Kathy Mazur Worden
September 07, 2007 03:07PM
Re: Adding a second database to replication... How?
11172
David Strang
September 07, 2007 09:47PM
Re: Adding a second database to replication... How?
9894
KimSeong Loh
September 10, 2007 03:05PM
Re: Adding Multiple Databases to replication... This is How...
89746
Brian Miller
April 18, 2008 01:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.