rpl_sporadic_master.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- # test to see if replication can continue when master sporadically fails on
- # COM_BINLOG_DUMP and additionally limits the number of events per dump
- source include/master-slave.inc;
- create table t2(n int);
- create table t1(n int not null auto_increment primary key);
- insert into t1 values (NULL),(NULL);
- truncate table t1;
- # We have to use 4 in the following to make this test work with all table types
- insert into t1 values (4),(NULL);
- sync_slave_with_master;
- stop slave;
- start slave;
- connection master;
- insert into t1 values (NULL),(NULL);
- flush logs;
- truncate table t1;
- insert into t1 values (10),(NULL),(NULL),(NULL),(NULL),(NULL);
- sync_slave_with_master;
- select * from t1;
- connection master;
- drop table t1,t2;
- sync_slave_with_master;
- # End of 4.1 tests