in set (0.00 sec)
查询结果显示Slave_IO_Running: Yes,Slave_SQL_Running: Yes,表示当前主从复制状态正常。
2. 在master新建数据库,在slave查询,测试主从复制效果。
Master建库建表。
mysql> create database cubix character set utf8;
Query OK, 1 row affected (0.00 sec)
mysql> use cubix
Database changed
mysql> create table T1 (id int);
Query OK, 0 rows affected (0.02 sec)
mysql> insert into T1 VALUES ('1');
Query OK, 1 row affected (0.00 sec)
?
mysql> insert into T1 VALUES ('2');
Query OK, 1 row affected (0.00 sec)
mysql> insert into T1 VALUES ('3');
Query OK, 1 row affected (0.01 sec)
?
?
Slave查询新建的库。
mysql> show databases;
+-------------------+
| Database ? ? ? |
+-------------------+
| information_schema|
| cubix ? ? ? ? |
| mysql ? ? ? ? |
| performance_schema|
+-------------------+
6 rows in set (0.00 sec)
?
mysql> use cubix
Database changed
mysql> show tables;
+----------------+
| Tables_in_cubix|
+----------------+
| T1 ? ? ? ? |
+----------------+
1 row in set (0.00 sec)
?
mysql> select * from T1;
+------+
| id ?|
+------+
| ? 1 |
| ? 2 |
| ? 3 |
+------+
3 rows in set (0.00 sec)
检查发现在主库上新增的数据,在从库上也有了,也可以证明主从同步正常。