MySQL Replication: Latest Developments
summary
Overview of concrete MySQL 5.7 replication changes: realtime configuration of online GTID reconfiguration and online replication filters without downtime, a practical procedure to set GTID state (including setting GTID_PURGED on a running server), multi‑source replication with per‑channel sender/receiver threads and independent apply settings, a new ack receiver and semi‑sync enhancements including lossless semi‑sync and wait‑for‑multiple‑acks, and locking‑based parallelism that lets slave apply throughput approach master speed while exposing per‑channel stats in performance_schema.
AI-written summary · about
chapters (10)
- 0:00Introduction to MySQL Replication
- 1:57Global Transaction Identifiers explained
- 3:18Online reconfiguration of GTID
- 5:48Crash-safe slaves and GTID
- 6:53Multi-threaded slave improvements
- 9:20Multi-source replication
- 11:47Replication formats and monitoring
- 13:10GTID purging and backup compatibility
- 15:41Future MySQL replication plans
- 18:19Q&A on replication challenges
related talks
51mReplication latest features: the community sceptic roundup
49mMySQL Replication — Advanced Features
53mMySQL replication setup, benefits, limitations
49mMySQL GTID Implementation, Maintenance, and Best Practices - The Short Version
43mHow MySQL Replication Works
48mDemystifying MySQL Replication Crash Safety
41mAsynchronous Replication Without Censorship
41mAsynchronous Replication Without Censorship