diff options
Diffstat (limited to 'mysql-test/r/rpl000016.result')
| -rw-r--r-- | mysql-test/r/rpl000016.result | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000016.result b/mysql-test/r/rpl000016.result index 65f260bd575..96e22d99aac 100644 --- a/mysql-test/r/rpl000016.result +++ b/mysql-test/r/rpl000016.result @@ -1,30 +1,71 @@ +slave start; +slave start; + change master to master_host='127.0.0.1',master_port=9306, +master_user='root'; +reset slave; + change master to master_host='127.0.0.1',master_port=9306, +master_user='root'; +reset master; +slave start; +drop table if exists t1; +create table t1 (s text); +insert into t1 values('Could not break slave'),('Tried hard'); +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 60 master-bin.001 234 Yes 0 0 3 +select * from t1; s Could not break slave Tried hard +flush logs; +drop table if exists t2; +create table t2(m int not null primary key); +insert into t2 values (34),(67),(123); +flush logs; +show master logs; Log_name master-bin.001 master-bin.002 master-bin.003 +insert into t2 values(1234); +insert into t2 values(1234); +slave stop; +set sql_slave_skip_counter=1; +slave start; +purge master logs to 'master-bin.003'; +show master logs; Log_name master-bin.003 +insert into t2 values (65); +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 60 master-bin.003 202 Yes 0 0 3 +select * from t2; m 34 65 67 123 1234 +drop table if exists t3; +create table t3 (n int); +show master logs; Log_name master-bin.003 master-bin.004 master-bin.005 master-bin.006 +show master status; File Position Binlog_do_db Binlog_ignore_db master-bin.006 720 +slave stop; +slave start; +show slave status; Master_Host Master_User Master_Port Connect_retry Log_File Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Last_log_seq 127.0.0.1 root 9999 60 master-bin.006 720 Yes 0 0 11 +lock tables t3 read; +select count(*) from t3 where n >= 4; count(*) 100 +unlock tables; +drop table if exists t1,t2,t3; |