rpl000015.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- connect (master,localhost,root,,test,0,mysql-master.sock);
- connect (slave,localhost,root,,test,0, mysql-slave.sock);
- source include/have_default_master.inc;
- connection master;
- reset master;
- show master status;
- save_master_pos;
- connection slave;
- reset slave;
- show slave status;
- change master to master_host='127.0.0.1';
- show slave status;
- change master to master_host='127.0.0.1',master_user='root',
- master_password='',master_port=9306;
- show slave status;
- slave start;
- sync_with_master;
- show slave status;
- connection master;
- drop table if exists foo;
- create table foo (n int);
- insert into foo values (10),(45),(90);
- save_master_pos;
- connection slave;
- sync_with_master;
- select * from foo;
- connection master;
- drop table foo;
- save_master_pos;
- connection slave;
- sync_with_master;