I configured a while ago 2 MySQL servers to run in multi-master replication mode which means both are master and slave of each other
so that each transaction that is run on one server is immediately ran on the other one as well.
it happens that I need to replace one of these servers which means that I need to re-configure the replication process and I was wondering
how should I go about doing that? I thought of doing:
- stopping the replication process entirely
- dumping the database of the active master servers and importing it to the new server as well as the other slave server
- re-starting replication again
Thank you!