MySQL Forums
Forum List  »  Replication

Re: question on master / master setup
Posted by: KimSeong Loh
Date: April 26, 2005 06:35PM

Depends what do you mean with read/write one at a time.

If you mean the same 1 will alwasy be used for read / write, then there is no problem, but you will not need to replicate from the 1 which never had any read/write, become redundant.

If you mean, the 1 used for read/write could be swaped at any time, you have to make sure all of the bin log had been executed by the slave before changing the server which you are going to read/write. In other words, the 2 servers have to be in sync when you change the read/write server from 1 to the other.

Options: ReplyQuote


Subject
Views
Written By
Posted
3465
April 25, 2005 12:27PM
2108
April 26, 2005 06:55AM
Re: question on master / master setup
2174
April 26, 2005 06:35PM


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.