Pseudo GTID and easy replication management

This session introduces a technique called “Pseudo GTID” which allows easy refactoring of replication topologies, and makes balanced, deeply nested topologies achievable, safe and productive.

Managing large replication topologies introduces difficult questions: do you place all your slaves directly under the master? Do you setup intermediate masters thus creating deep replication trees? How do you synchronize sibling slaves when their master dies? How do you recover replication of a slave if its intermediate master is gone?

MySQL’s Global Transaction ID (GTID) comes to solve the above. However GTID comes with its own limitations and not always or not easily applicable.

Pseudo GTID is a non intrusive solution that utilizes standard replication, and turns your existing replication topology into a GTID-like topology, allowing you to repoint slaves however you like.

We will quickly discuss the problems incurred by standard binary log file & position setup, and the limitations of GTID, Pseudo-GTID injection. We will present the algorithm and implementation for utilizing Pseudo GTID to freely repoint slaves.