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
Last activity: Jun 5, 2025, 01:43 PM