Scaling MySQL with Python

on YouTube ↗26m

" summary

Shows concrete tools and results: MySQL ships pure‑Python drivers and a suite called mysql‑utilities that perform diffs, audits and disk‑usage on multi‑GB tables, and a fabric orchestrator that configures replication groups, elects masters and performs automatic failover via a single command. Claims include creating resilient topologies in minutes and cloning groups to add servers. A custom Docker provisioning provider is implemented so fabric can spawn containers. Demonstrations use MySQL 5.6/5.7 features like GTID and report successful automatic promotions.

AI-written summary · about

" chapters (14)

1. 0:00Start
2. 2:30Manage & Use a database
3. 3:14MySQL Utilities
4. 6:14Connectors
5. 6:34Log-based Replication: Master
6. 7:39Benefits of replication
7. 10:24Initialize new slaves
8. 10:34Failover Basics
9. 11:32Fabric Orchestrator
10. 11:48Fabric - HLA
11. 16:14Connecting programmatically
12. 16:44Provisioning a new slave
13. 17:35Docker Provisioning
14. 19:47That's all folks!

" related talks

• 55mHow to setup web scalable architecture with MySQL FabricRicky Setyawan · FOSSASIA 2015
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 14mPython and the New MySQL ShellDave Stokes · Conf42 Python 2021
• 20mScaling Global User Management in MySQL with ProxySQLJakob Lorberblatt · Percona Live 2026 Bay Area
• 01h 31mMySQL operations in DockerGiuseppe Maxia · FOSSASIA Summit 2017
• 27mDistributed MySQL Architectures: Past, Present and FuturePeter Zaitsev · Distributed SQL Summit 2019
• 26mOperationalizing 19 years of infrastructure via MySQL-as-a-ServiceNathan Northcutt · Percona Live Open Source Database Conference 2017
• 43mOptimizing MySQL without SQL or touching my.cnfPeter Boros, Maxim Bublis · Percona Live Open Source Database Conference 2017