Percona MySQL (i.e. Galera), ProxySQL, keepalived, the flavour of orchestration that is most compatible with your production environment and team. Make sure yo

Percona MySQL (i.e. Galera), ProxySQL, keepalived, the flavour of orchestration that is most compatible with your production environment and team. Make sure you up ulimit and systemd LimitNOFILE in the MySQL service config. Read docs closely, preferably bring on someone who's spent some time making mistakes in this area to help out, test diligently before putting into production, including load tests.