With the addition of the new tables to implement crash-safe
replication we also get access to replication information
through the SQL interface. This might not seem like a big
advantage, but it should not be taken lightly. To demonstrate the
power of using this approach, I will show how to implement a
multi-source round-robin replication described at other places (including our
book). However, compared to the other implementations—where
the implementation requires a client to parse the output of
SHOW SLAVE STATUS—the twist is that the
implementation is entirely done in the server, using pure SQL.
If you're familiar with replication, you know that a slave can just …
[Read more]