?
不停机xtrabackup创建slave节点(三)
_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.03 sec)
master：
(system@localhost) [(none)]> use test;
Database changed
(system@localhost) [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| j1 |
| j2 |
| t1 |
+----------------+
3 rows in set (0.00 sec)
(system@localhost) [test]> select * from t1;
+------+
| name |
+------+
| dcw |
| jjf |
+------+
2 rows in set (0.11 sec)
slave：
(system@localhost) [(none)]> use test;
Database changed
(system@localhost) [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| j1 |
| j2 |
| t1 |
+----------------+
3 rows in set (0.03 sec)
(system@localhost) [test]> select * from t1;
+------+
| name |
+------+
| dcw |
| jjf |
+------+
2 rows in set (0.05 sec)
?
master插入数据：
(system@localhost) [test]> insert into t1 values('jone');
Query OK, 1 row affected (0.05 sec)
?
?
slave中查询：同步过来了
(system@localhost) [test]> select * from t1; +------+ | name | +------+ | dcw | | jjf | | jone | +------+ 3 rows in set (0.00 sec)
?
?