1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t1(a INT PRIMARY KEY);
DROP TABLE t1;
[connection slave]
START REPLICA UNTIL MASTER_LOG_FILE='source_file',MASTER_LOG_POS=source_pos;
Warnings:
Warning 1287 'MASTER_LOG_FILE' is deprecated and will be removed in a future release. Please use SOURCE_LOG_FILE instead
Warning 1287 'MASTER_LOG_POS' is deprecated and will be removed in a future release. Please use SOURCE_LOG_POS instead
include/assert.inc [Until condition is 'source' on replica]
include/wait_for_slave_sql_to_stop.inc
include/start_slave.inc
[connection master]
SHOW SLAVE HOSTS;
SHOW WARNINGS;
Level Code Message
Warning 1287 'SHOW SLAVE HOSTS' is deprecated and will be removed in a future release. Please use SHOW REPLICAS instead
SHOW REPLICAS;
SHOW WARNINGS;
Level Code Message
[connection slave]
SHOW SLAVE STATUS;
SHOW WARNINGS;
Level Code Message
Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
SHOW REPLICA STATUS;
SHOW WARNINGS;
Level Code Message
include/stop_slave.inc
RESET SLAVE;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
RESET REPLICA;
START SLAVE;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/wait_for_slave_to_start.inc
STOP SLAVE;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
include/wait_for_slave_to_stop.inc
START REPLICA;
include/wait_for_slave_to_start.inc
STOP REPLICA;
include/wait_for_slave_to_stop.inc
RESET SLAVE ALL;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
RESET REPLICA ALL;
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1',SOURCE_PORT=MASTER_PORT,SOURCE_USER='root' for CHANNEL '';
Warnings:
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
CREATE TABLE t1 (c1 INT);
INSERT INTO t1 VALUES (1);
[connection slave]
START REPLICA UNTIL SOURCE_LOG_FILE='LOG_FILE', SOURCE_LOG_POS=LOG_POS;
include/wait_for_slave_sql_to_stop.inc
include/stop_slave.inc
include/diff_tables.inc [master:t1,slave:t1]
DROP TABLE t1;
RESET REPLICA;
RESET MASTER;
START REPLICA UNTIL MASTER_LOG_FILE='LOG_FILE', MASTER_LOG_POS=LOG_POS;
Warnings:
Warning 1287 'MASTER_LOG_FILE' is deprecated and will be removed in a future release. Please use SOURCE_LOG_FILE instead
Warning 1287 'MASTER_LOG_POS' is deprecated and will be removed in a future release. Please use SOURCE_LOG_POS instead
include/wait_for_slave_sql_to_stop.inc
include/stop_slave.inc
include/diff_tables.inc [master:t1,slave:t1]
[connection master]
DROP TABLE t1;
RESET MASTER;
[connection slave]
DROP TABLE t1;
RESET REPLICA;
RESET MASTER;
include/start_slave.inc
[connection master]
include/rpl_end.inc
|
