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
Last activity: May 21, 2014, 02:50 AM