rpl000015.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- connect (master,localhost,root,,test,$MASTER_MYPORT,master.sock);
- connect (slave,localhost,root,,test,$SLAVE_MYPORT,slave.sock);
- connection master;
- reset master;
- show master status;
- save_master_pos;
- connection slave;
- reset slave;
- --replace_result $MASTER_MYPORT MASTER_PORT
- --replace_column 1 # 33 #
- show slave status;
- change master to master_host='127.0.0.1';
- # The following needs to be cleaned up when change master is fixed
- --replace_result $MASTER_MYPORT MASTER_PORT $MYSQL_TCP_PORT MASTER_PORT
- --replace_column 1 # 33 #
- show slave status;
- --replace_result $MASTER_MYPORT MASTER_PORT
- eval change master to master_host='127.0.0.1',master_user='root',
- master_password='',master_port=$MASTER_MYPORT;
- --replace_result $MASTER_MYPORT MASTER_PORT
- --replace_column 1 # 33 #
- show slave status;
- start slave;
- sync_with_master;
- --replace_result $MASTER_MYPORT MASTER_PORT
- --replace_column 1 # 33 #
- show slave status;
- connection master;
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- create table t1 (n int);
- insert into t1 values (10),(45),(90);
- sync_slave_with_master;
- select * from t1;
- connection master;
- drop table t1;
- sync_slave_with_master;
- # End of 4.1 tests