MySQL Forums
Forum List  »  Replication

Re: Multi Master and Slave MySQL servers
Posted by: Rick James
Date: March 20, 2010 04:12PM

A server can be both a Master and a Slave. Put two of those together, each slaving off the other, and you have "circular replication" or "dual master". Be sure to have log_slave_updates on and distinct server_ids.

True, a Slave reads the replication stream at its own pace. But in a well tuned setup, that is 'effectively' instantaneous.

A Master replicates only statements that cause changes. It does not send an existing database. That is, it will not automatically copy a table over to get things started. You must dump and load such. And watch out for changes that come in while you are doing it.

There are many threads about dual-master in this forum; recommend you read them, perhaps starting with
http://forums.mysql.com/read.php?144,279339 (What is Best solution for DR and 24*7 using two identical systems, cluster is not available here(hw))
http://forums.mysql.com/read.php?24,263289 (Performance maintaining a live database)
http://forums.mysql.com/read.php?26,257989 (Replicating server has died)
http://forums.mysql.com/read.php?26,256563 (MySQL & SAN)
http://forums.mysql.com/read.php?20,253348 (MySQL settings for multiple server setup)
http://forums.mysql.com/read.php?144,235807 (MySQL Master/Master Replication)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Multi Master and Slave MySQL servers
1290
March 20, 2010 04:12PM


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.