Sample Header Ad - 728x90

Syncing updates to master in master/slave setup [semi-sync replication]

2 votes
1 answer
443 views
Background info --------------- I have two MySQL 5.5 servers set up in a Master/Slave configuration with **Semi-synchronous** replication. The database is being used for a high-profile WordPress site. Problem ------- It seems to work great except for one thing: When the master is down and changes are made to the slave, they are not written back to the master when it comes back up. What I've done so far ------------------ I tried the answer [[here]][1] , but it broke my replication completely. Questions --------- - Is there a more standard way of setting this up or is it generally not supported? - Should I just disallow writes on the slave? - Is there a simple way to notify the master of changes, and sync them upstream?
Asked by Vasili Syrakis (125 rep)
May 21, 2014, 12:10 AM
Last activity: May 21, 2014, 02:50 AM