mysql master-user_MYSQL 的 MASTER到MASTER的主主循环同步

7、查看各自机器上的IO进程和SLAVE进程是否都开启。A：mysql> show processlist\G*************************** 1. row ***************************

Id: 2

User: repl

Host: 192.168.0.232:54475

db: NULL

Command: Binlog Dump

Time: 1590State: Has sent all binlog to slave; waiting for binlogto be updatedInfo: NULL

*************************** 2. row ***************************

Id: 3

User: system user

Host:

db: NULL

Command: Connect

Time: 1350State: Waiting for master to send eventInfo: NULL

*************************** 3. row ***************************

Id: 4

User: system user

Host:

db: NULL

Command: Connect

Time: 1149State: Has read all relay log; waiting for the slaveI/O thread to update itInfo: NULL

*************************** 4. row ***************************

Id: 5

User: root

Host: localhost

db: test

Command: Query

Time: 0

State: NULL

Info: show processlist

4 rows in set (0.00 sec)

B：mysql> show processlist\G*************************** 1. row ***************************

Id: 1

User: system user

Host:

db: NULL

Command: Connect

Time: 2130State: Waiting for master to send eventInfo: NULL

*************************** 2. row ***************************

Id: 2

User: system user

Host:

db: NULL

Command: Connect

Time: 1223State: Has read all relay log; waiting for the slaveI/O thread to update itInfo: NULL

*************************** 3. row ***************************

Id: 4

User: root

Host: localhost

db: test

Command: Query

Time: 0

State: NULL

Info: show processlist

*************************** 4. row ***************************

Id: 5

User: repl2

Host: 192.168.0.231:50718

db: NULL

Command: Binlog Dump

Time: 1398State: Has sent all binlog to slave; waiting forbinlog to be updatedInfo: NULL

4 rows in set (0.00 sec)如果红色部分没有出现，检查DATA目录下的错误文件。8、释放掉各自的锁，然后进行插数据测试。mysql> unlock tables;Query OK, 0 rows affected (0.00 sec)插入之前两个机器表的对比：A：mysql> show tables;+----------------+

| Tables_in_test |

+----------------+

| t11_innodb     |

| t22            |

+----------------+

B：mysql> show tables;+----------------+

| Tables_in_test |

+----------------+

| t11_innodb     |

| t22            |

+----------------+从A机器上进行插入A：mysql> create table t11_replicas-> (id int not nullauto_increment primary key,-> str varchar(255) not null)engine myisam;Query OK, 0 rows affected (0.01 sec)mysql> insert into t11_replicas(str) values-> ('This is a master to mastertest table');Query OK, 1 row affected (0.01 sec)mysql> show tables;+----------------+

| Tables_in_test |

+----------------+

| t11_innodb     |

| t11_replicas   |

| t22            |

+----------------+

3 rows in set (0.00 sec)mysql> select * from t11_replicas;+----+---------------------------------------+

| id |str                                  |

+----+---------------------------------------+

|  1 | This is a master to master test table |

+----+---------------------------------------+

1 row in set (0.00 sec)现在来看B机器：mysql> show tables;+----------------+

| Tables_in_test |

+----------------+

| t11_innodb     |

| t11_replicas   |

| t22            |

+----------------+

3 rows in set (0.00 sec)mysql> select * from t11_replicas;+----+---------------------------------------+

| id |str                                  |

+----+---------------------------------------+

|  1 | This is a master to master test table |

+----+---------------------------------------+

1 row in set (0.00 sec)现在反过来从B机器上插入数据：B：mysql> insert into t11_replicas(str) values('Thisis a test 2');Query OK, 1 row affected (0.00 sec)mysql> select * from t11_replicas;+----+---------------------------------------+

| id | str                                  |

+----+---------------------------------------+

|  1 | This is a master to master test table |

|  2 | This is a test2                     |

+----+---------------------------------------+

2 rows in set (0.00 sec)我们来看AA：mysql> select * from t11_replicas;+----+---------------------------------------+

| id |str                                  |

+----+---------------------------------------+

|  1 | This is a master to master test table |

|  2 | This is a test2                     |

+----+---------------------------------------+

2 rows in set (0.00 sec)好了。现在两个表互相为MASTER。