ProxySQL Use Case Scenarios
summary
Protocol-aware MySQL proxy that actually implements connection pooling/multiplexing, on-the-fly read/write split, query rewrite rules, per-query caching and mirroring for cache warming, and integration with MHA/Orchestrator for seamless failover; used in production (Tumblr data-center migration, Live360 reduced connection storms). Admin console stores live metrics, supports runtime config and query-throttling/sniper timeouts, and can terminate long queries. Default worker threads are configurable (default 4). Practical claim: cuts new-connection and cross-DC SSL latency and cushions schema or master promotions without app changes.
AI-written summary · about
chapters (8)
- 0:00Introduction to ProxySQL
- 1:38ProxySQL highlights
- 8:06Scalability and pooling
- 8:56High availability and HA
- 23:19Query support and caching
- 24:03Query mirroring and security
- 37:33Management and administration
- 44:49Q&A session
related talks
50m#ProxySQL Use Case Scenarios
41mProxySQL 2021 Dev Submit
27mThe State of ProxySQL, 2020 Edition
37mScale MySQL beyond limits with ProxySQL
08mMySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out
54mProxySQL at Scale
06mRoad to Percona Live 2022 - Oleksandr Kuzminskyi - ProxySQL Talk
58mDecentralized Cluster Nodes