1
Test case 1 - SSL mysqlrplshow OLD Master before demote
2
# master on localhost: ... connected.
3
# Finding slaves for master: localhost:PORT1
5
# Replication Topology Graph
6
localhost:PORT1 (MASTER)
8
+--- localhost:PORT2 - (SLAVE)
10
+--- localhost:PORT3 - (SLAVE)
12
+--- localhost:PORT4 - (SLAVE)
14
Test case 2 - SSL switchover demote-master
15
# Discovering slaves for master at localhost:PORT1
16
# Discovering slave at localhost:PORT2
17
# Found slave: localhost:PORT2
18
# Discovering slave at localhost:PORT3
19
# Found slave: localhost:PORT3
20
# Discovering slave at localhost:PORT4
21
# Found slave: localhost:PORT4
22
# Checking privileges.
23
# Performing switchover from master at localhost:PORT1 to slave at localhost:PORT2.
24
# Checking candidate slave prerequisites.
25
# Checking slaves configuration to master.
26
# Waiting for slaves to catch up to old master.
28
# Performing STOP on all slaves.
29
# Demoting old master to be a slave to the new master.
30
# Switching slaves to new master.
31
# Starting all slaves.
32
# Performing START on all slaves.
33
# Checking slaves for errors.
34
# Switchover complete.
36
# Replication Topology Health:
37
+------------+-------+---------+--------+------------+---------+
38
| host | port | role | state | gtid_mode | health |
39
+------------+-------+---------+--------+------------+---------+
40
| localhost | PORT2 | MASTER | UP | ON | OK |
41
| localhost | PORT1 | SLAVE | UP | ON | OK |
42
| localhost | PORT3 | SLAVE | UP | ON | OK |
43
| localhost | PORT4 | SLAVE | UP | ON | OK |
44
+------------+-------+---------+--------+------------+---------+
47
Test case 3 - SSL mysqlrplshow NEW Master after demote
48
# master on localhost: ... connected.
49
# Finding slaves for master: localhost:PORT2
51
# Replication Topology Graph
52
localhost:PORT2 (MASTER)
54
+--- localhost:PORT1 - (SLAVE)
56
+--- localhost:PORT3 - (SLAVE)
58
+--- localhost:PORT4 - (SLAVE)
60
Test case 4 - SSL mysqlrplcheck NEW Master after demote
61
# master on localhost: ... connected.
62
# slave on localhost: ... connected.
63
Test Description Status
64
---------------------------------------------------------------------------
65
Checking for binary logging on master [pass]
66
Are there binlog exceptions? [pass]
67
Replication user exists? [pass]
68
Checking server_id values [pass]
69
Checking server_uuid values [pass]
70
Is slave connected to master? [pass]
71
Check master information file [pass]
72
Checking InnoDB compatibility [pass]
73
Checking storage engines compatibility [pass]
74
Checking lower_case_table_names settings [pass]
75
Checking slave delay (seconds behind master) [pass]
80
Slave_IO_State : Waiting for master to send event
81
Master_Host : localhost
86
Master_SSL_Allowed : Yes
87
Master_SSL_CA_File : XXXXX
89
Master_SSL_Cert : XXXX
96
Test case 5 - SSL mysqlrplcheck NEW Master after demote
97
# master on localhost: ... connected.
98
# slave on localhost: ... connected.
99
Test Description Status
100
---------------------------------------------------------------------------
101
Checking for binary logging on master [pass]
102
Are there binlog exceptions? [pass]
103
Replication user exists? [pass]
104
Checking server_id values [pass]
105
Checking server_uuid values [pass]
106
Is slave connected to master? [pass]
107
Check master information file [pass]
108
Checking InnoDB compatibility [pass]
109
Checking storage engines compatibility [pass]
110
Checking lower_case_table_names settings [pass]
111
Checking slave delay (seconds behind master) [pass]
116
Slave_IO_State : Waiting for master to send event
117
Master_Host : localhost
118
Master_User : rpluser
122
Master_SSL_Allowed : Yes
123
Master_SSL_CA_File : XXXXX
125
Master_SSL_Cert : XXXX
127
Master_SSL_Key : XXXX
128
Master_SSL_Crl : XXXX
132
Test case 6 - SSL mysqlrplcheck NEW Master after demote
133
# master on localhost: ... connected.
134
# slave on localhost: ... connected.
135
Test Description Status
136
---------------------------------------------------------------------------
137
Checking for binary logging on master [pass]
138
Are there binlog exceptions? [pass]
139
Replication user exists? [pass]
140
Checking server_id values [pass]
141
Checking server_uuid values [pass]
142
Is slave connected to master? [pass]
143
Check master information file [pass]
144
Checking InnoDB compatibility [pass]
145
Checking storage engines compatibility [pass]
146
Checking lower_case_table_names settings [pass]
147
Checking slave delay (seconds behind master) [pass]
152
Slave_IO_State : Waiting for master to send event
153
Master_Host : localhost
154
Master_User : rpluser
158
Master_SSL_Allowed : Yes
159
Master_SSL_CA_File : XXXXX
161
Master_SSL_Cert : XXXX
163
Master_SSL_Key : XXXX
164
Master_SSL_Crl : XXXX
168
Test case 7 - SSL failover
169
# Checking privileges.
170
# Performing failover.
171
# Candidate slave localhost:PORT3 will become the new master.
172
# Checking slaves status (before failover).
173
# Preparing candidate for failover.
174
# Creating replication user if it does not exist.
176
# Performing STOP on all slaves.
177
# Switching slaves to new master.
178
# Disconnecting new master as slave.
180
# Performing START on all slaves.
181
# Checking slaves for errors.
184
# Replication Topology Health:
185
+------------+-------+---------+--------+------------+---------+
186
| host | port | role | state | gtid_mode | health |
187
+------------+-------+---------+--------+------------+---------+
188
| localhost | PORT3 | MASTER | UP | ON | OK |
189
| localhost | PORT1 | SLAVE | UP | ON | OK |
190
| localhost | PORT4 | SLAVE | UP | ON | OK |
191
+------------+-------+---------+--------+------------+---------+
194
Test case 8 - SSL mysqlrplshow NEW Master after failover
195
# master on localhost: ... connected.
196
# Finding slaves for master: localhost:PORT3
198
# Replication Topology Graph
199
localhost:PORT3 (MASTER)
201
+--- localhost:PORT1 - (SLAVE)
203
+--- localhost:PORT4 - (SLAVE)
205
Test case 9 - SSL mysqlrplcheck NEW Master after demote
206
# master on localhost: ... connected.
207
# slave on localhost: ... connected.
208
Test Description Status
209
---------------------------------------------------------------------------
210
Checking for binary logging on master [pass]
211
Are there binlog exceptions? [pass]
212
Replication user exists? [pass]
213
Checking server_id values [pass]
214
Checking server_uuid values [pass]
215
Is slave connected to master? [pass]
216
Check master information file [pass]
217
Checking InnoDB compatibility [pass]
218
Checking storage engines compatibility [pass]
219
Checking lower_case_table_names settings [pass]
220
Checking slave delay (seconds behind master) [pass]
225
Slave_IO_State : Waiting for master to send event
226
Master_Host : localhost
227
Master_User : rpluser
231
Master_SSL_Allowed : Yes
232
Master_SSL_CA_File : XXXXX
234
Master_SSL_Cert : XXXX
236
Master_SSL_Key : XXXX
237
Master_SSL_Crl : XXXX
241
Test case 10 - SSL mysqlrplcheck NEW Master after demote
242
# master on localhost: ... connected.
243
# slave on localhost: ... connected.
244
Test Description Status
245
---------------------------------------------------------------------------
246
Checking for binary logging on master [pass]
247
Are there binlog exceptions? [pass]
248
Replication user exists? [pass]
249
Checking server_id values [pass]
250
Checking server_uuid values [pass]
251
Is slave connected to master? [pass]
252
Check master information file [pass]
253
Checking InnoDB compatibility [pass]
254
Checking storage engines compatibility [pass]
255
Checking lower_case_table_names settings [pass]
256
Checking slave delay (seconds behind master) [pass]
261
Slave_IO_State : Waiting for master to send event
262
Master_Host : localhost
263
Master_User : rpluser
267
Master_SSL_Allowed : Yes
268
Master_SSL_CA_File : XXXXX
270
Master_SSL_Cert : XXXX
272
Master_SSL_Key : XXXX
273
Master_SSL_Crl : XXXX