mysql 5.5 双机_MySQL 5.5双机热备份 master-master

五，创建授权用户

masterA:

MySQL>grant replication slave on *.* to rpuser1@192.168.1.29 identified by ‘123456’;

Mysql> flush privileges;

masterB:

Mysql>grant replication slave on *.* to rpuser2@192.168.1.28 identified by ‘123456’;

Mysql> flush privileges;

六，准备复制

Master A：

mysql> flush tables with read lock\G

Query OK, 0 rows affected (0.00 sec)

mysql> show master status\G

*************************** 1. row ***************************

File: mysql-bin.000003

Position: 107

Binlog_Do_DB: test

Binlog_Ignore_DB: mysql

1 row in set (0.00 sec)

Mysql> unlock tables;

master B：

mysql> flush tables with read lock;

Query OK, 0 rows affected (0.00 sec)

mysql> show master status\G

*************************** 1. row ***************************

File: mysql-bin.000004

Position: 107

Binlog_Do_DB: test

Binlog_Ignore_DB: mysql

1 row in set (0.00 sec)

Mysql> unlock tables;

在各自机器上执行CHANGE MASTER TO命令。

Master A：

mysql> change master to

-> master_host='192.168.1.28',

-> master_user='rpuser2',

-> master_password='123456',

-> master_log_file='mysql-bin.000004',

-> master_log_pos=107;

Query OK, 0 rows affected (0.01 sec)

mysql> start slave;

Query OK, 0 rows affected (0.00 sec)

master B：

mysql> change master to

-> master_host='192.168.1.29',

-> master_user='rpuser1',

-> master_password='123456',

-> master_log_file='mysql-bin.000003',

-> master_log_pos=107;

Query OK, 0 rows affected (0.01 sec)

mysql> start slave;

Query OK, 0 rows affected (0.00 sec)

七，查看与验证

Master A:

Mysql>show slave status \G

Slave_IO_Running: Yes 这两个为yes表示正常

Slave_SQL_Running: Yes

Master B:

Mysql>show slave status \G

Slave_IO_Running: Yes 这两个为yes表示正常

 Slave_SQL_Running: Yes