Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save criccomini/71bd7e0a80b2be987d38d841ae3d5634 to your computer and use it in GitHub Desktop.
Save criccomini/71bd7e0a80b2be987d38d841ae3d5634 to your computer and use it in GitHub Desktop.
MySQL replication, GTIDs, and MySQL HA
From MySQL's docs:
* [Switching Masters During Failover](https://dev.mysql.com/doc/refman/5.5/en/replication-solutions-switch.html)
* [mysqlfailover — Automatic replication health monitoring and failover](https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlfailover.html)
* [Replication with Global Transaction Identifiers](https://dev.mysql.com/doc/refman/5.6/en/replication-gtids.html)
* [MySQL Multi-Source Replication](https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html)
* [Improving Replication Performance](https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html)
* [Using Replication for Backups](https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups.html)
From Facebook:
* [Semi-Synchronous Replication at Facebook](http://yoshinorimatsunobu.blogspot.com/2014/04/semi-synchronous-replication-at-facebook.html)
* [Lessons from Deploying MySQL GTID at Scale (Facebook)](https://www.facebook.com/notes/mysql-at-facebook/lessons-from-deploying-mysql-gtid-at-scale/10152252699590933/)
From Percona:
* [How does MySQL Replication really work?](https://www.percona.com/blog/2013/01/09/how-does-mysql-replication-really-work/)
* [Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1](https://www.percona.com/blog/2013/05/21/replication-in-mysql-5-6-gtids-benefits-and-limitations-part-1/)
* [Replication in MySQL 5.6: GTIDs benefits and limitations – Part 2](https://www.percona.com/blog/2013/05/30/replication-in-mysql-5-6-gtids-benefits-and-limitations-part-2/)
* [How Does Semisynchronous MySQL Replication Work?](https://www.percona.com/blog/2012/01/19/how-does-semisynchronous-mysql-replication-work/)
From Debezium:
* [Support initial MySQL snapshots](https://issues.jboss.org/browse/DBZ-31)
* [Recover from MySQL failure by pointing connector to new MySQL server instance (without GTIDs)](https://issues.jboss.org/browse/DBZ-67)
* [Support HA MySQL server topologies](https://issues.jboss.org/browse/DBZ-37)
Misc:
* [Architecture of MHA](https://code.google.com/p/mysql-master-ha/wiki/Architecture)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment