tim594
1st June 2007, 22:27
Sorry, this is a repost from the comments on http://www.howtoforge.com/mysql_master_master_replication
this is a smart way of doing it.. master-master. BUT, lets say, master 1 goes down. now users are inserting rows in master 2 for lets say 24 hours, before master 1 is back up.
Then MASTER 1, comes back online, now Master 1 is 24 hours behind on logs. If your loadbalancer now notices that master 1 is online, it will now send queries over there, but 24 hours worth of logs will take a while to catch up. so if clients make inserts into MASTER1, there will be conflictions?
So how do you deal with this? Do you need to have a smarter loadbalancer that does manual switch back?
this is a smart way of doing it.. master-master. BUT, lets say, master 1 goes down. now users are inserting rows in master 2 for lets say 24 hours, before master 1 is back up.
Then MASTER 1, comes back online, now Master 1 is 24 hours behind on logs. If your loadbalancer now notices that master 1 is online, it will now send queries over there, but 24 hours worth of logs will take a while to catch up. so if clients make inserts into MASTER1, there will be conflictions?
So how do you deal with this? Do you need to have a smarter loadbalancer that does manual switch back?