MySQL Forums
Forum List  »  Replication

Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
Posted by: Rick James
Date: December 26, 2009 12:48PM

The servers must have different values for server_id.

Use different settings for binlog_do_db to explicitly saying which databases to replicate. (This may not be required, but read about it anyway.)

Execute CHANGE MASTER once on each 'slave' to tell it where its 'master' is.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
1409
December 26, 2009 12:48PM


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.