Sample Header Ad - 728x90

Mysql ubuntu solution (failover, failback)

0 votes
1 answer
34 views
I am a newbie SQL DBA and I am working on a mysql server based on ubuntu operating system. I need to solve the following problems. Is there a way to solve all the following problems with a single program, tool, etc.? And how are organizations addressing the following issues? 1. **Automate** master-to-slave replication 2. **Automate** master-to-slave failover (when the master goes down, the slave automatically becomes the new master) 3. **Automate** slave to master failback (when the master goes up, the old master is automatically replaced) 4. Master and slave **automate** data consistency (After all, master and slaves all data equally) I am searching on the internet and asking chatgpt and they suggest the following programs, but they are not all in one solutions: 1. Orchestrator 2. InnoDB 3. Group Replication 4. Galera Cluster Thanks for your answers.
Asked by Mavis May (3 rep)
Jun 5, 2025, 08:03 AM
Last activity: Jun 5, 2025, 01:43 PM