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 + -
显示快捷键?