mysql master-slave setup with synchronous replication
- by imaginative
I have a very trivial mysql master-slave setup going on between two servers. The problem is, replication is asynchronous, and this can cause issues (even on a low latency link), if the master server was to crash after a COMMIT before the replication thread from the slave was able to fetch the last bin log.
Is there anyway to force mysql to do synchronous commits so that data consistency is guaranteed in a mysql-slave relationship?