Setting up replication

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
leart
Forum Newbie
Posts: 2
Joined: Tue Apr 07, 2009 7:28 am

Setting up replication

Post by leart »

Hi everyone

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
Just wondering how to do that exactly in terms of technical steps...


Thank you!
Post Reply