Distributed systems are hard – I just want to echo that. In MySQL, we have quite a number of options to run highly available systems. However, real fault tolerant systems are difficult to achieve. Take for example a common use case of multi-DC replication where Orchestrator is responsible for managing the topology, while ProxySQL takes [&]

https://www.percona.com/blog/2019/04/02/simple-stonith-proxysql-orchestrator/