MySQL - What issues should I be aware of when se
More DBA job interview questions and answers at
MySQL - What issues should I be aware of when setting up two-way replication?
MySQL replication currently does not support any locking protocol between master and slave to guarantee the atomicity of
a distributed (cross-server) update. In in other words, it is possible for client A to make an update to co-master 1, and in
the meantime, before it propagates to co-master 2, client B could make an update to co-master 2 that will make the update of
client A work differently than it did on co-master 1. Thus when the update of client A will make it to co-master 2, it will
produce tables that will be different than what you have on co-master 1, even after all the updates from co-master 2 have
also propagated. So you should not co-chain two servers in a two-way replication relationship, unless you are sure that you
updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code.
Other Job Interview Questions