MySQL replication setup, benefits, limitations
summary
Covers concrete MySQL replication mechanics and tradeoffs: enable log_bin and unique server_id, create a replication user, run SHOW MASTER STATUS, use CHANGE MASTER TO and START SLAVE to attach replicas, demonstrated a PHP app that sends writes to master and reads to slaves. Describes formats GTID (5.6.5+), semi-synchronous (5.7+), statement vs row replication, common uses (read scaling, slave backups, analytics, geo distribution), limits (not full HA, no automatic failover) and diagnostics (IO vs SQL thread lag, SHOW SLAVE STATUS).
AI-written summary · about
chapters (8)
- 0:00MySQL replication intro
- 10:13What replication is
- 20:55MySQL replication types
- 24:10Replication lag explained
- 31:02Fixing replication issues
- 37:15Setting up replication
- 51:46Read/write load split
- 52:06Q&A
related talks
49mMySQL Replication — Advanced Features
43mHow MySQL Replication Works
22mMySQL Replication: Latest Developments
51mReplication latest features: the community sceptic roundup
49mMySQL GTID Implementation, Maintenance, and Best Practices - The Short Version
14mThe State of the Art of MySQL Replication
23mMySQL Group Replication
29mEverything You Ever Wanted to Know About MariaDB Replication but Were Afraid to Ask