在mysql-2上查看从库状态,确认以下两项的参数都为Yes( show slave status\G; )
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
2021-3-20 11:33
######
主从测试
mysql-1:
use data1;
create table class11 (id int,name varchar(6));
use data2;
create table class22 (id int,name varchar(6));
insert into class22 values (168,'Hello');
mysql-2: