I have been talking about this for a while, now at last I have
found the time to get started! Below is a picture from my 2008
MySQL User Conference presentation. It illustrates how engine
level replication works, and also shows how this can be ramped up
to provide a multi-master HA setup.
What I now have running is the first phase: asynchronous replication, in a master/slave configuration. The way it works is simple. For every slave in the configuration the master PBXT engine starts a thread which reads the transaction log, and transfers modifications …