MySQL Master Master Repliction
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one. Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication. Notions: we will call system 1 as master1 and slave2 and system2 as master2 and slave 1. Step 1: Install mysql on master 1 and slave 1. configure network services on both system, like Master 1/Slave 2 ip: 10.11.218.251 Master 2/Slave 1 ip : 10.11.218.252 Step 2: Setup Master 1 On Master 1, make changes in my.cnf: #vim /etc/my.cnf log-bin=mysql-bin server-id=1 binlog-ignore-db=”mysql” * Restart MySQL Master Service # killall m