18
18
==== Replicate one event at a time on slave ====
20
start slave until master_log_file='master-bin.000001', master_log_pos=323;
31
Master_Port MASTER_PORT
33
Master_Log_File master-bin.000001
37
Relay_Master_Log_File master-bin.000001
43
Replicate_Ignore_Table #
44
Replicate_Wild_Do_Table
45
Replicate_Wild_Ignore_Table
51
Until_Condition Master
52
Until_Log_File master-bin.000001
60
Seconds_Behind_Master #
61
Master_SSL_Verify_Server_Cert No
66
start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291;
77
Master_Port MASTER_PORT
79
Master_Log_File master-bin.000001
83
Relay_Master_Log_File master-bin.000001
89
Replicate_Ignore_Table #
90
Replicate_Wild_Do_Table
91
Replicate_Wild_Ignore_Table
97
Until_Condition Master
98
Until_Log_File master-no-such-bin.000001
100
Master_SSL_Allowed No
106
Seconds_Behind_Master #
107
Master_SSL_Verify_Server_Cert No
112
start slave until relay_log_file='slave-relay-bin.000004', relay_log_pos=746;
20
start slave until master_log_file='MASTER_LOG_FILE', master_log_pos=MASTER_LOG_POS;
27
start slave until master_log_file='master-no-such-bin.000001', master_log_pos=MASTER_LOG_POS;
34
start slave until relay_log_file='slave-relay-bin.000004', relay_log_pos=RELAY_LOG_POS;
119
Master_Host 127.0.0.1
121
Master_Port MASTER_PORT
123
Master_Log_File master-bin.000001
124
Read_Master_Log_Pos #
127
Relay_Master_Log_File master-bin.000001
133
Replicate_Ignore_Table #
134
Replicate_Wild_Do_Table
135
Replicate_Wild_Ignore_Table
139
Exec_Master_Log_Pos #
141
Until_Condition Relay
142
Until_Log_File slave-relay-bin.000004
144
Master_SSL_Allowed No
150
Seconds_Behind_Master #
151
Master_SSL_Verify_Server_Cert No
159
42
include/stop_slave.inc
160
start slave until master_log_file='master-bin.000001', master_log_pos=776;
163
Master_Host 127.0.0.1
165
Master_Port MASTER_PORT
167
Master_Log_File master-bin.000001
168
Read_Master_Log_Pos #
171
Relay_Master_Log_File master-bin.000001
177
Replicate_Ignore_Table #
178
Replicate_Wild_Do_Table
179
Replicate_Wild_Ignore_Table
183
Exec_Master_Log_Pos #
185
Until_Condition Master
186
Until_Log_File master-bin.000001
188
Master_SSL_Allowed No
194
Seconds_Behind_Master #
195
Master_SSL_Verify_Server_Cert No
43
start slave until master_log_file='MASTER_LOG_FILE', master_log_pos=MASTER_LOG_POS;
200
44
==== Test various error conditions ====
201
start slave until master_log_file='master-bin', master_log_pos=561;
45
start slave until master_log_file='master-bin', master_log_pos=MASTER_LOG_POS;
202
46
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
203
start slave until master_log_file='master-bin.000001', master_log_pos=561, relay_log_pos=12;
47
start slave until master_log_file='master-bin.000001', master_log_pos=MASTER_LOG_POS, relay_log_pos=RELAY_LOG_POS;
204
48
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
205
49
start slave until master_log_file='master-bin.000001';
206
50
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
207
51
start slave until relay_log_file='slave-relay-bin.000002';
208
52
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
209
start slave until relay_log_file='slave-relay-bin.000002', master_log_pos=561;
53
start slave until relay_log_file='slave-relay-bin.000002', master_log_pos=MASTER_LOG_POS;
210
54
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
211
55
start slave sql_thread;
212
start slave until master_log_file='master-bin.000001', master_log_pos=776;
56
start slave until master_log_file='master-bin.000001', master_log_pos=MASTER_LOG_POS;
214
58
Note 1254 Slave is already running
215
59
include/stop_slave.inc