I have multi source mysql replication setup configured, so I have this big server which act as a slave to other smaller server. The setup looks similar to below.
Everything is working fine— until one of the master server is down, my webapp which hosted on that master server would failover to the big server, this changes also make the replicated db on slave being used instead.
When the master goes up again, I have to manually dump the replicated database on slave and restore it to master server to keep up/synchronize with the changes. The process alone took 10 minutes, this defeat the purpose of having this high-availability setup.
What I want to ask, is there any efficient method of restoring ONLY changes commited on slave to the master— without having to dump entire database all over again ?
Also is there any gui management tool to manage all of this ? I have take a look on orchestrator but it seems it does not support multi source replication.