Mysql master-master Replication HOWTO - What about conflicts?

Discussion in 'HOWTO-Related Questions' started by tim594, Jun 1, 2007.

  1. tim594

    tim594 New Member

    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?
     
  2. falko

    falko Super Moderator ISPConfig Developer

Share This Page