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.
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], but it broke my replication completely.
- 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?