MySQL failover with orchestrator and ProxySQL

on YouTube ↗05m

" summary

Shows a concrete build: a MySQL fleet using asynchronous replication, orchestrator hook updates ProxySQL to change routing automatically, and scripted failover exercised end to end so the routing and replication roles actually switch. Describes patch workflow of updating a replica then failing over, claims no manual intervention, and surfaces operational details and pitfalls for achieving fast automated failover and keeping clients routed correctly without prolonged outages.

AI-written summary · about

" related talks

• 55mProduction with ProxySQL and OrchestratorAlawi Assaggaf · Percona Community Live 2022
• 08mMySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale OutRené Cannaò · Percona Live Open Source Database Conference Europe 2017
• 41mAutopsy of a MySQL Automation DisasterJean-François Gagné · SREcon19 Europe/Middle East/Africa
• 55mProxySQL Use Case ScenariosAlkin Tezuysal · HighLoad++ 2017
• 50m#ProxySQL Use Case ScenariosRené Cannaò · Percona Live Open Source Database Conference 2017
• 46mDatabase Reliability Engineering for MySQLMatthias Crauwels · Percona Community Live 2022
• 37mScale MySQL beyond limits with ProxySQLRatnadeep Debnath · Rootconf 2019
• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014