mysql主主复制管理器

-- 服务器1配置
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = mydatabase
auto_increment_offset = 1
auto_increment_increment = 2

-- 服务器2配置
server-id = 2
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = mydatabase
auto_increment_offset = 2
auto_increment_increment = 2

-- 在服务器1上
GRANT REPLICATION SLAVE ON *.* TO 'replication_user'@'服务器2_ip' IDENTIFIED BY 'password';

-- 在服务器2上
GRANT REPLICATION SLAVE ON *.* TO 'replication_user'@'服务器1_ip' IDENTIFIED BY 'password';

-- 在服务器1上
CHANGE MASTER TO
MASTER_HOST='服务器2_ip',
MASTER_USER='replication_user',
MASTER_PASSWORD='password',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=107;

-- 在服务器2上
CHANGE MASTER TO
MASTER_HOST='服务器1_ip',
MASTER_USER='replication_user',
MASTER_PASSWORD='password',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=107;