Starting on DB01 cat /etc/my.cnf [mysqld] log-bin=mysql-bin server-id=1 replicate-wild-do-table=replicateddb.% replicate-ignore-db=test [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Restart the service to apply the changes service mysqld restart Login to MySQL mysql –u root –p Create replication user account with the host set to the Slave Server’s IP. Make sure the password is 32 characters or less! mysql> CREATE USER… Continue reading Setup Database Master/Master Replication on MySQL Server