Web-N00b

If you need master-master replication for your MySQL server. This example is for Centos 6 x64 but on other Linux OS the process is similar.

For example we have two following servers with IPs:
1.1.1.1 SERVER_A
2.2.2.2 SERVER_B

1. Install MySQL server on both servers.yum -y install mysql-server
2. By default, MySQL works only with localhost (127.0.0.1), so we need to edit MySQL config file /etc/my.cnf and add followingon SERVER_A:
   server-id = 1
bind-address = 1.1.1.1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = database_for_replication
#replicate-do-table = database_for_replication.table_for_replication (You can replicate only some table(s)) More »