MySQL Replication: Simplifying Scaling and HA with GTIDs

Join the MySQL replication developers for a deep dive into the design and implementation of Global Transaction Identifiers (GTIDs) and how they enable users to simplify MySQL scaling and HA. GTIDs are one of the most significant new replication capabilities in MySQL 5.6, making it simple to track and compare replication progress between the master and slave servers.

This enables:

• Self-healing recovery within a replication cluster
• Greater flexibility in the provisioning and on-going management of diverse replication topologies, e.g. master/slave, multi-tier or ring (circular), etc.

The webinar will cover:

• Concepts: What is a GTID? How does the server generate GTIDs? What is the life cycle of GTIDs? How are GTIDs used to connect to a master?
• Handling conflicts
• How to skip transactions using GTIDs
• What happens when binary logs are purged
• How to provision a new slave or restore from a backup
• MySQL utilities for failover and switchover

WER:

WO: