MySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out
summary
Demonstrates using ProxySQL as an abstraction layer between application and MySQL to route and throttle traffic so scaling and HA don’t require app changes; shows real-world setups for master/slave topologies, automated promotion and failover, and how ProxySQL enforces routing rules to protect from abusive queries. Covers query rewriting and result caching inside the proxy, gives concrete config examples and operational behavior, and reports that traffic steering and failover work in production.
AI-written summary · about
chapters (4)
related talks
50m#ProxySQL Use Case Scenarios
37mScale MySQL beyond limits with ProxySQL
55mProxySQL Use Case Scenarios
05mMySQL failover with orchestrator and ProxySQL
55mProduction with ProxySQL and Orchestrator
48mMySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up look
06mRoad to Percona Live 2022 - Oleksandr Kuzminskyi - ProxySQL Talk
27mIntroduction to Configuring and Using MariaDB MaxScale: Database Proxy Made Simple