MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

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.

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


Subject
Views
Written By
Posted
Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
2550
Juan Perez Estrada
December 25, 2009 10:42AM
Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
1478
Rick James
December 26, 2009 12:48PM
Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
1468
Juan Perez Estrada
December 26, 2009 04:54PM


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.