mysql master<->master replication

server 1 :

/etc/my.cnf
[mysqld]
# номер сервера, у всех реплицируемых серверов они должны быть уникальными
server-id = 1
log-bin = mysql-bin
# конфигурация серера, как мастера
log-bin = /var/lib/mysql/mysql-bin

# конфигурация сервера, как слейва
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
replicate-do-db = test_db

server 2 :
/etc/my.cnf
[mysqld]
# номер сервера, у всех реплицируемых серверов они должны быть уникальными
server-id = 1
log-bin = mysql-bin
# конфигурация серера, как мастера
log-bin = /var/lib/mysql/mysql-bin

# конфигурация сервера, как слейва
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
replicate-do-db = test_db
==============================================================

mysql @server_1 :

mysql> CHANGE MASTER TO MASTER_HOST='server_2', MASTER_PORT=N, MASTER_USER='NAME', MASTER_PASSWORD='PASSWORD';

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'NAME'@'%' IDENTIFIED BY 'PASSWORD';


mysql @server_2 :

mysql> CHANGE MASTER TO MASTER_HOST='server_1',
MASTER_PORT=N,
MASTER_USER='NAME',
MASTER_PASSWORD='PASSWORD';

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'NAME'@'%' IDENTIFIED BY 'PASSWORD';

==================================================================

in case of :

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log) ... :

1. read mysql err file.
2. mysql>STOP SLAVE;
3. mysql>RESET SLAVE;
4. mysql>START SLAVE;

==================================================================

thats all.