Mysql 环形复制

来源：互联网发布：mac怎么查看群相册编辑：程序博客网时间：2024/05/21 00:48

三台主机: 192.168.0.205, 192.168.0.206,192.168.0.207

配置192.168.0.205

1.edit /etc/mysql/my.cnf
[mysqld]

log-bin=mysql-bin
server-id=5
binlog-do-db=test
binlog-ignore-db=information_schema,performance_schema,mysql
replicate-do-db=test
replicate-ignore-db=information_schema,performance_schema,mysql
log-slave-updates
slave-skip-errors=all
sync_binlog=1
auto_increment_increment=3
auto_increment_offset=1

     2.sudo service mysql restart
     3.create user 'repl'@'%' identified by 'slavepass'; grant replication slave on *.* to 'repl'@'%';
4.show master status\G;
            File: mysql-bin.000003
Position: 4049

配置192.168.0.206

1.edit /etc/mysql/my.cnf
[mysqld]

log-bin=mysql-bin
server-id=5
binlog-do-db=test
binlog-ignore-db=information_schema,performance_schema,mysql
replicate-do-db=test
replicate-ignore-db=information_schema,performance_schema,mysql
log-slave-updates
slave-skip-errors=all
sync_binlog=1
auto_increment_increment=3
auto_increment_offset=2

2.sudo service mysql restart
3.create user 'repl'@'%' identified by 'slavepass'; grant replication slave on *.* to 'repl'@'%';

4. execute mysql scripts:

1) stop slave;

2) change master to master_host='192.168.0.205', master_user='repl', master_password='slavepass', master_log_file='mysql-bin.000003', master_log_pos=4049;

3) start slave;

5.show master status\G;
File: mysql-bin.000001
Position: 1142

配置192.168.0.207

1.edit /etc/mysql/my.cnf
[mysqld]

log-bin=mysql-bin
server-id=5
binlog-do-db=test
binlog-ignore-db=information_schema,performance_schema,mysql
replicate-do-db=test
replicate-ignore-db=information_schema,performance_schema,mysql
log-slave-updates
slave-skip-errors=all
sync_binlog=1
auto_increment_increment=3
auto_increment_offset=3

2.sudo service mysql restart
3.create user 'repl'@'%' identified by 'slavepass'; grant replication slave on *.* to 'repl'@'%';

4. execute mysql scripts:

1) stop slave;

2) change master to master_host='192.168.0.206', master_user='repl', master_password='slavepass', master_log_file='mysql-bin.000001', master_log_pos=1142;

3) start slave;

5.show master status\G;
File: mysql-bin.000002
Position: 1234

配置192.168.0.205

1. execute mysql scripts:

1) stop slave;

2) change master to master_host='192.168.0.207', master_user='repl', master_password='slavepass', master_log_file='mysql-bin.000002', master_log_pos=1234;

3) start slave;

0 0