Scaling Global User Management in MySQL with ProxySQL
summary
Replaces slow Ansible-based user deploys with a Python tool + CLI and FastAPI runner that integrates with GitHub CI, ProxySQL, MySQL, Orchestrator and Console Template, cutting deploys from over an hour to ~14 seconds and removing thousands of stale fast‑routing rules. Implements per-file deploys, dry‑run SQL generation, concurrent background deploy threads, a tested cutover using lock tables and replication markers for schema migration, and 2 TB data moves via exportable tablespaces and a mirrored gradual migration strategy.
AI-written summary · about
chapters (10)
- 0:00User management challenges
- 2:14Ansible user provisioning issues
- 5:24ProxySQL and Python deployment
- 7:50Secret management modernization
- 9:55CI pipeline integration
- 11:19ProxySQL multi-tenancy
- 12:43Noisy neighbor schema migration
- 15:30Zero-downtime schema cutover
- 17:38Templated users and API integration
- 18:41Open-source goals and Q&A
related talks
37mScale MySQL beyond limits with ProxySQL
26mScaling MySQL with Python
55mProduction with ProxySQL and Orchestrator
50m#ProxySQL Use Case Scenarios
06mRoad to Percona Live 2022 - Oleksandr Kuzminskyi - ProxySQL Talk
05mMySQL failover with orchestrator and ProxySQL
54mProxySQL at Scale
55mProxySQL Use Case Scenarios