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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
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]
[connection slave]
RESET REPLICA ALL;
CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1";
include/assert.inc ["Assert that the host was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0;
include/assert.inc ["Assert that auto position set correctly"]
CHANGE REPLICATION SOURCE TO GET_SOURCE_PUBLIC_KEY=1;
include/assert.inc ["Assert that the 'get public key' was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_BIND="eth4n";
include/assert.inc ["Assert that the bind was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS="zstd";
include/assert.inc ["Assert that the connect retry was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=10000;
include/assert.inc ["Assert that the connect retry was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_DELAY=101010;
include/assert.inc ["Assert that the delay was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=2;
include/assert.inc ["Assert that the heartbeat period was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE="binlog.000001";
Warnings:
Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
include/assert.inc ["Assert that the log file was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_LOG_POS=200;
include/assert.inc ["Assert that the log position was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD="secret";
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.
include/assert.inc ["Assert that the password was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_PORT=3306;
include/assert.inc ["Assert that the port was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_PUBLIC_KEY_PATH="/path/to/source/key";
include/assert.inc ["Assert that the source public key path was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT=101;
include/assert.inc ["Assert that the retry count was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL=1;
include/assert.inc ["Assert that the SSL was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CA="ca";
include/assert.inc ["Assert that the SSL CA file was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CAPATH="/path/to/ca";
include/assert.inc ["Assert that the SSL CA path was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CIPHER="cipher_foo";
include/assert.inc ["Assert that the SSL cipher was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CERT="cert";
include/assert.inc ["Assert that the SSL cert was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRL="crl_list";
include/assert.inc ["Assert that the SSL CRL was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRLPATH="/path/to/crl";
include/assert.inc ["Assert that the SSL CRL path was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_KEY="key";
include/assert.inc ["Assert that the SSL key was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT=1;
include/assert.inc ["Assert that the SSL verify server cert was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_TLS_CIPHERSUITES="foo";
include/assert.inc ["Assert that the TLS Ciphersuites was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_TLS_VERSION="TLSv1.2";
include/assert.inc ["Assert that the TLS version was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_USER="luis";
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.
include/assert.inc ["Assert that the user was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL=14;
include/assert.inc ["Assert that the ZSTD compression level was set correctly"]
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=1;
include/assert.inc ["Assert that auto position set correctly"]
RESET REPLICA ALL;
CHANGE MASTER TO MASTER_HOST="127.0.0.1", MASTER_USER="luis";
Warnings:
Warning 1287 'CHANGE MASTER' is deprecated and will be removed in a future release. Please use CHANGE REPLICATION SOURCE instead
Warning 1287 'MASTER_HOST' is deprecated and will be removed in a future release. Please use SOURCE_HOST instead
Warning 1287 'MASTER_USER' is deprecated and will be removed in a future release. Please use SOURCE_USER instead
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.
CHANGE REPLICATION SOURCE TO MASTER_HOST="127.0.0.1";
Warnings:
Warning 1287 'MASTER_HOST' is deprecated and will be removed in a future release. Please use SOURCE_HOST instead
CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=0;
Warnings:
Warning 1287 'MASTER_AUTO_POSITION' is deprecated and will be removed in a future release. Please use SOURCE_AUTO_POSITION instead
CHANGE REPLICATION SOURCE TO GET_MASTER_PUBLIC_KEY=1;
Warnings:
Warning 1287 'GET_MASTER_PUBLIC_KEY' is deprecated and will be removed in a future release. Please use GET_SOURCE_PUBLIC_KEY instead
CHANGE REPLICATION SOURCE TO MASTER_BIND="eth4n";
Warnings:
Warning 1287 'MASTER_BIND' is deprecated and will be removed in a future release. Please use SOURCE_BIND instead
CHANGE REPLICATION SOURCE TO MASTER_COMPRESSION_ALGORITHMS="zstd";
Warnings:
Warning 1287 'MASTER_COMPRESSION_ALGORITHM' is deprecated and will be removed in a future release. Please use SOURCE_COMPRESSION_ALGORITHM instead
CHANGE REPLICATION SOURCE TO MASTER_CONNECT_RETRY=10000;
Warnings:
Warning 1287 'MASTER_CONNECT_RETRY' is deprecated and will be removed in a future release. Please use SOURCE_CONNECT_RETRY instead
CHANGE REPLICATION SOURCE TO MASTER_DELAY=101010;
Warnings:
Warning 1287 'MASTER_DELAY' is deprecated and will be removed in a future release. Please use SOURCE_DELAY instead
CHANGE REPLICATION SOURCE TO MASTER_HEARTBEAT_PERIOD=2;
Warnings:
Warning 1287 'MASTER_HEARTBEAT_PERIOD' is deprecated and will be removed in a future release. Please use SOURCE_HEARTBEAT_PERIOD instead
CHANGE REPLICATION SOURCE TO MASTER_LOG_FILE="binlog.000001";
Warnings:
Warning 1287 'MASTER_LOG_FILE' is deprecated and will be removed in a future release. Please use SOURCE_LOG_FILE instead
Warning 3023 CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
CHANGE REPLICATION SOURCE TO MASTER_LOG_POS=200;
Warnings:
Warning 1287 'MASTER_LOG_POS' is deprecated and will be removed in a future release. Please use SOURCE_LOG_POS instead
CHANGE REPLICATION SOURCE TO MASTER_PASSWORD="secret";
Warnings:
Warning 1287 'MASTER_PASSWORD' is deprecated and will be removed in a future release. Please use SOURCE_PASSWORD instead
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.
CHANGE REPLICATION SOURCE TO MASTER_PORT=3306;
Warnings:
Warning 1287 'MASTER_PORT' is deprecated and will be removed in a future release. Please use SOURCE_PORT instead
CHANGE REPLICATION SOURCE TO MASTER_PUBLIC_KEY_PATH="/path/to/source/key";
Warnings:
Warning 1287 'MASTER_PUBLIC_KEY_PATH' is deprecated and will be removed in a future release. Please use SOURCE_PUBLIC_KEY_PATH instead
CHANGE REPLICATION SOURCE TO MASTER_RETRY_COUNT=101;
Warnings:
Warning 1287 'MASTER_RETRY_COUNT' is deprecated and will be removed in a future release. Please use SOURCE_RETRY_COUNT instead
CHANGE REPLICATION SOURCE TO MASTER_SSL=1;
Warnings:
Warning 1287 'MASTER_SSL' is deprecated and will be removed in a future release. Please use SOURCE_SSL instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CA="ca";
Warnings:
Warning 1287 'MASTER_SSL_CA' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CA instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CAPATH="/path/to/ca";
Warnings:
Warning 1287 'MASTER_SSL_CAPATH' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CAPATH instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CIPHER="cipher_foo";
Warnings:
Warning 1287 'MASTER_SSL_CIPHER' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CIPHER instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CERT="cert";
Warnings:
Warning 1287 'MASTER_SSL_CERT' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CERT instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CRL="crl_list";
Warnings:
Warning 1287 'MASTER_SSL_CRL' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CRL instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_CRLPATH="/path/to/crl";
Warnings:
Warning 1287 'MASTER_SSL_CRLPATH' is deprecated and will be removed in a future release. Please use SOURCE_SSL_CRLPATH instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_KEY="key";
Warnings:
Warning 1287 'MASTER_SSL_KEY' is deprecated and will be removed in a future release. Please use SOURCE_SSL_KEY instead
CHANGE REPLICATION SOURCE TO MASTER_SSL_VERIFY_SERVER_CERT=1;
Warnings:
Warning 1287 'MASTER_SSL_VERIFY_SERVER_CERT' is deprecated and will be removed in a future release. Please use SOURCE_SSL_VERIFY_SERVER_CERT instead
CHANGE REPLICATION SOURCE TO MASTER_TLS_CIPHERSUITES="foo";
Warnings:
Warning 1287 'MASTER_TLS_CIPHERSUITES' is deprecated and will be removed in a future release. Please use SOURCE_TLS_CIPHERSUITES instead
CHANGE REPLICATION SOURCE TO MASTER_TLS_VERSION="TLSv1.2";
Warnings:
Warning 1287 'MASTER_TLS_VERSION' is deprecated and will be removed in a future release. Please use SOURCE_TLS_VERSION instead
CHANGE REPLICATION SOURCE TO MASTER_USER="luis";
Warnings:
Warning 1287 'MASTER_USER' is deprecated and will be removed in a future release. Please use SOURCE_USER instead
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.
CHANGE REPLICATION SOURCE TO MASTER_ZSTD_COMPRESSION_LEVEL=14;
Warnings:
Warning 1287 'MASTER_ZSTD_COMPRESSION_LEVEL' is deprecated and will be removed in a future release. Please use SOURCE_ZSTD_COMPRESSION_LEVEL instead
CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=1;
Warnings:
Warning 1287 'MASTER_AUTO_POSITION' is deprecated and will be removed in a future release. Please use SOURCE_AUTO_POSITION instead
RESET REPLICA ALL;
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT,SOURCE_USER='root';
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.
include/start_slave.inc
[connection master]
include/rpl_end.inc
|
