rpl_until.result
来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· RESULT 代码 · 共 197 行
RESULT
197 行
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;stop slave;create table t1(n int not null auto_increment primary key);insert into t1 values (1),(2),(3),(4);drop table t1;create table t2(n int not null auto_increment primary key);insert into t2 values (1),(2);insert into t2 values (3),(4);drop table t2;show binlog events;Log_name Pos Event_type Server_id End_log_pos Infomaster-bin.000001 4 Format_desc 1 98 Server ver: VERSION, Binlog ver: 4master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key)master-bin.000001 219 Query 1 319 use `test`; insert into t1 values (1),(2),(3),(4)master-bin.000001 319 Query 1 395 use `test`; drop table t1master-bin.000001 395 Query 1 516 use `test`; create table t2(n int not null auto_increment primary key)master-bin.000001 516 Query 1 608 use `test`; insert into t2 values (1),(2)master-bin.000001 608 Query 1 700 use `test`; insert into t2 values (3),(4)master-bin.000001 700 Query 1 776 use `test`; drop table t2start slave until master_log_file='master-bin.000001', master_log_pos=319;select * from t1;n1234SHOW SLAVE STATUS;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_MYPORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 776Relay_Log_File slave-relay-bin.000004Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running #Slave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 319Relay_Log_Space #Until_Condition MasterUntil_Log_File master-bin.000001Until_Log_Pos 319Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291;select * from t1;n1234SHOW SLAVE STATUS;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_MYPORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 776Relay_Log_File slave-relay-bin.000004Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running #Slave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 319Relay_Log_Space #Until_Condition MasterUntil_Log_File master-no-such-bin.000001Until_Log_Pos 291Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #start slave until relay_log_file='slave-relay-bin.000004', relay_log_pos=746;select * from t2;n12SHOW SLAVE STATUS;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_MYPORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 776Relay_Log_File slave-relay-bin.000004Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running #Slave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 608Relay_Log_Space #Until_Condition RelayUntil_Log_File slave-relay-bin.000004Until_Log_Pos 746Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #start slave;stop slave;start slave until master_log_file='master-bin.000001', master_log_pos=776;SHOW SLAVE STATUS;Slave_IO_State #Master_Host 127.0.0.1Master_User rootMaster_Port MASTER_MYPORTConnect_Retry 1Master_Log_File master-bin.000001Read_Master_Log_Pos 776Relay_Log_File slave-relay-bin.000004Relay_Log_Pos #Relay_Master_Log_File master-bin.000001Slave_IO_Running YesSlave_SQL_Running NoReplicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0Last_Error Skip_Counter 0Exec_Master_Log_Pos 776Relay_Log_Space #Until_Condition MasterUntil_Log_File master-bin.000001Until_Log_Pos 776Master_SSL_Allowed NoMaster_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master #start slave until master_log_file='master-bin', master_log_pos=561;ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTILstart slave until master_log_file='master-bin.000001', master_log_pos=561, relay_log_pos=12;ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTILstart slave until master_log_file='master-bin.000001';ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTILstart slave until relay_log_file='slave-relay-bin.000002';ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTILstart slave until relay_log_file='slave-relay-bin.000002', master_log_pos=561;ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTILstart slave sql_thread;start slave until master_log_file='master-bin.000001', master_log_pos=776;Warnings:Note 1254 Slave is already running
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?