Ref: http://www.howtoforge.com/mysql_master_master_replication a) Create user name and password for replication on both servers by using this command GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO noslave@’host-name’ IDENTIFIED BY ’some-pass’; b) Configuration for Server 1 To make it primary Server for Server2 vi /etc/my.cnf log-bin=mysql-bin binlog-do-db=fosiul # which Database to replicate binlog-do-db=hesk # Which Database to [...]