stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; show variables like 'rpl_recovery_rank'; Variable_name Value rpl_recovery_rank 1 show status like 'Rpl_status'; Variable_name Value Rpl_status AUTH_MASTER create table t1(n int); drop table t1; show variables like 'rpl_recovery_rank'; Variable_name Value rpl_recovery_rank 2 show status like 'Rpl_status'; Variable_name Value Rpl_status ACTIVE_SLAVE start slave; show variables like 'rpl_recovery_rank'; Variable_name Value rpl_recovery_rank 3 show status like 'Rpl_status'; Variable_name Value Rpl_status ACTIVE_SLAVE start slave; show variables like 'rpl_recovery_rank'; Variable_name Value rpl_recovery_rank 4 show status like 'Rpl_status'; Variable_name Value Rpl_status ACTIVE_SLAVE