| 1 |
include/group_replication.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
[connection server1] |
| 6 |
|
| 7 |
############################################################ |
| 8 |
# 1. Bootstrap group on server1. |
| 9 |
[connection server1] |
| 10 |
include/start_and_bootstrap_group_replication.inc |
| 11 |
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY); |
| 12 |
CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY); |
| 13 |
USE test; |
| 14 |
CREATE PROCEDURE procedure1() |
| 15 |
BEGIN |
| 16 |
end$$ |
| 17 |
CREATE FUNCTION function1() RETURNS INT RETURN (SELECT COUNT(*) FROM t1); |
| 18 |
CREATE EVENT event1 |
| 19 |
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND |
| 20 |
ON COMPLETION PRESERVE |
| 21 |
DISABLE |
| 22 |
DO |
| 23 |
BEGIN |
| 24 |
END$$ |
| 25 |
CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW |
| 26 |
BEGIN |
| 27 |
INSERT INTO t2 VALUES (NEW.c1); |
| 28 |
END| |
| 29 |
|
| 30 |
############################################################ |
| 31 |
# 2. Validate that a given SHOW statement goes through the |
| 32 |
# `trans_begin` hook on Group Replication on server1. |
| 33 |
|
| 34 |
# Instrument GR to hold the statement on |
| 35 |
# `trans_begin` hook on server1. |
| 36 |
[connection server_1] |
| 37 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 38 |
|
| 39 |
# Execute the statement on server1. |
| 40 |
[connection server1] |
| 41 |
SHOW DATABASES; |
| 42 |
|
| 43 |
# Validate that the statement went on |
| 44 |
# `trans_begin` hook on server1. |
| 45 |
[connection server_1] |
| 46 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 47 |
|
| 48 |
# Release the statement from |
| 49 |
# `trans_begin` hook on server1. |
| 50 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 51 |
|
| 52 |
# Reap the statement on server1. |
| 53 |
[connection server1] |
| 54 |
|
| 55 |
# Remove GR instrumentaion to hold the statement on |
| 56 |
# `trans_begin` hook on server1. |
| 57 |
[connection server_1] |
| 58 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 59 |
|
| 60 |
# Instrument GR to hold the statement on |
| 61 |
# `trans_begin` hook on server1. |
| 62 |
[connection server_1] |
| 63 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 64 |
|
| 65 |
# Execute the statement on server1. |
| 66 |
[connection server1] |
| 67 |
SHOW TABLES; |
| 68 |
|
| 69 |
# Validate that the statement went on |
| 70 |
# `trans_begin` hook on server1. |
| 71 |
[connection server_1] |
| 72 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 73 |
|
| 74 |
# Release the statement from |
| 75 |
# `trans_begin` hook on server1. |
| 76 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 77 |
|
| 78 |
# Reap the statement on server1. |
| 79 |
[connection server1] |
| 80 |
|
| 81 |
# Remove GR instrumentaion to hold the statement on |
| 82 |
# `trans_begin` hook on server1. |
| 83 |
[connection server_1] |
| 84 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 85 |
|
| 86 |
# Instrument GR to hold the statement on |
| 87 |
# `trans_begin` hook on server1. |
| 88 |
[connection server_1] |
| 89 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 90 |
|
| 91 |
# Execute the statement on server1. |
| 92 |
[connection server1] |
| 93 |
SHOW INDEX FROM t1; |
| 94 |
|
| 95 |
# Validate that the statement went on |
| 96 |
# `trans_begin` hook on server1. |
| 97 |
[connection server_1] |
| 98 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 99 |
|
| 100 |
# Release the statement from |
| 101 |
# `trans_begin` hook on server1. |
| 102 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 103 |
|
| 104 |
# Reap the statement on server1. |
| 105 |
[connection server1] |
| 106 |
|
| 107 |
# Remove GR instrumentaion to hold the statement on |
| 108 |
# `trans_begin` hook on server1. |
| 109 |
[connection server_1] |
| 110 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 111 |
|
| 112 |
# Instrument GR to hold the statement on |
| 113 |
# `trans_begin` hook on server1. |
| 114 |
[connection server_1] |
| 115 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 116 |
|
| 117 |
# Execute the statement on server1. |
| 118 |
[connection server1] |
| 119 |
SHOW KEYS FROM t1; |
| 120 |
|
| 121 |
# Validate that the statement went on |
| 122 |
# `trans_begin` hook on server1. |
| 123 |
[connection server_1] |
| 124 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 125 |
|
| 126 |
# Release the statement from |
| 127 |
# `trans_begin` hook on server1. |
| 128 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 129 |
|
| 130 |
# Reap the statement on server1. |
| 131 |
[connection server1] |
| 132 |
|
| 133 |
# Remove GR instrumentaion to hold the statement on |
| 134 |
# `trans_begin` hook on server1. |
| 135 |
[connection server_1] |
| 136 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 137 |
|
| 138 |
# Instrument GR to hold the statement on |
| 139 |
# `trans_begin` hook on server1. |
| 140 |
[connection server_1] |
| 141 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 142 |
|
| 143 |
# Execute the statement on server1. |
| 144 |
[connection server1] |
| 145 |
SHOW GRANTS FOR CURRENT_USER(); |
| 146 |
|
| 147 |
# Validate that the statement went on |
| 148 |
# `trans_begin` hook on server1. |
| 149 |
[connection server_1] |
| 150 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 151 |
|
| 152 |
# Release the statement from |
| 153 |
# `trans_begin` hook on server1. |
| 154 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 155 |
|
| 156 |
# Reap the statement on server1. |
| 157 |
[connection server1] |
| 158 |
|
| 159 |
# Remove GR instrumentaion to hold the statement on |
| 160 |
# `trans_begin` hook on server1. |
| 161 |
[connection server_1] |
| 162 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 163 |
|
| 164 |
# Instrument GR to hold the statement on |
| 165 |
# `trans_begin` hook on server1. |
| 166 |
[connection server_1] |
| 167 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 168 |
|
| 169 |
# Execute the statement on server1. |
| 170 |
[connection server1] |
| 171 |
SHOW CREATE DATABASE test; |
| 172 |
|
| 173 |
# Validate that the statement went on |
| 174 |
# `trans_begin` hook on server1. |
| 175 |
[connection server_1] |
| 176 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 177 |
|
| 178 |
# Release the statement from |
| 179 |
# `trans_begin` hook on server1. |
| 180 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 181 |
|
| 182 |
# Reap the statement on server1. |
| 183 |
[connection server1] |
| 184 |
|
| 185 |
# Remove GR instrumentaion to hold the statement on |
| 186 |
# `trans_begin` hook on server1. |
| 187 |
[connection server_1] |
| 188 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 189 |
|
| 190 |
# Instrument GR to hold the statement on |
| 191 |
# `trans_begin` hook on server1. |
| 192 |
[connection server_1] |
| 193 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 194 |
|
| 195 |
# Execute the statement on server1. |
| 196 |
[connection server1] |
| 197 |
SHOW TABLE STATUS FROM test; |
| 198 |
|
| 199 |
# Validate that the statement went on |
| 200 |
# `trans_begin` hook on server1. |
| 201 |
[connection server_1] |
| 202 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 203 |
|
| 204 |
# Release the statement from |
| 205 |
# `trans_begin` hook on server1. |
| 206 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 207 |
|
| 208 |
# Reap the statement on server1. |
| 209 |
[connection server1] |
| 210 |
|
| 211 |
# Remove GR instrumentaion to hold the statement on |
| 212 |
# `trans_begin` hook on server1. |
| 213 |
[connection server_1] |
| 214 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 215 |
|
| 216 |
# Instrument GR to hold the statement on |
| 217 |
# `trans_begin` hook on server1. |
| 218 |
[connection server_1] |
| 219 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 220 |
|
| 221 |
# Execute the statement on server1. |
| 222 |
[connection server1] |
| 223 |
SHOW TRIGGERS FROM test; |
| 224 |
|
| 225 |
# Validate that the statement went on |
| 226 |
# `trans_begin` hook on server1. |
| 227 |
[connection server_1] |
| 228 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 229 |
|
| 230 |
# Release the statement from |
| 231 |
# `trans_begin` hook on server1. |
| 232 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 233 |
|
| 234 |
# Reap the statement on server1. |
| 235 |
[connection server1] |
| 236 |
|
| 237 |
# Remove GR instrumentaion to hold the statement on |
| 238 |
# `trans_begin` hook on server1. |
| 239 |
[connection server_1] |
| 240 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 241 |
|
| 242 |
# Instrument GR to hold the statement on |
| 243 |
# `trans_begin` hook on server1. |
| 244 |
[connection server_1] |
| 245 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 246 |
|
| 247 |
# Execute the statement on server1. |
| 248 |
[connection server1] |
| 249 |
SHOW CREATE PROCEDURE test.procedure1; |
| 250 |
|
| 251 |
# Validate that the statement went on |
| 252 |
# `trans_begin` hook on server1. |
| 253 |
[connection server_1] |
| 254 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 255 |
|
| 256 |
# Release the statement from |
| 257 |
# `trans_begin` hook on server1. |
| 258 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 259 |
|
| 260 |
# Reap the statement on server1. |
| 261 |
[connection server1] |
| 262 |
|
| 263 |
# Remove GR instrumentaion to hold the statement on |
| 264 |
# `trans_begin` hook on server1. |
| 265 |
[connection server_1] |
| 266 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 267 |
|
| 268 |
# Instrument GR to hold the statement on |
| 269 |
# `trans_begin` hook on server1. |
| 270 |
[connection server_1] |
| 271 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 272 |
|
| 273 |
# Execute the statement on server1. |
| 274 |
[connection server1] |
| 275 |
SHOW CREATE FUNCTION test.function1; |
| 276 |
|
| 277 |
# Validate that the statement went on |
| 278 |
# `trans_begin` hook on server1. |
| 279 |
[connection server_1] |
| 280 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 281 |
|
| 282 |
# Release the statement from |
| 283 |
# `trans_begin` hook on server1. |
| 284 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 285 |
|
| 286 |
# Reap the statement on server1. |
| 287 |
[connection server1] |
| 288 |
|
| 289 |
# Remove GR instrumentaion to hold the statement on |
| 290 |
# `trans_begin` hook on server1. |
| 291 |
[connection server_1] |
| 292 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 293 |
|
| 294 |
# Instrument GR to hold the statement on |
| 295 |
# `trans_begin` hook on server1. |
| 296 |
[connection server_1] |
| 297 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 298 |
|
| 299 |
# Execute the statement on server1. |
| 300 |
[connection server1] |
| 301 |
SHOW PROCEDURE CODE test.procedure1; |
| 302 |
|
| 303 |
# Validate that the statement went on |
| 304 |
# `trans_begin` hook on server1. |
| 305 |
[connection server_1] |
| 306 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 307 |
|
| 308 |
# Release the statement from |
| 309 |
# `trans_begin` hook on server1. |
| 310 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 311 |
|
| 312 |
# Reap the statement on server1. |
| 313 |
[connection server1] |
| 314 |
|
| 315 |
# Remove GR instrumentaion to hold the statement on |
| 316 |
# `trans_begin` hook on server1. |
| 317 |
[connection server_1] |
| 318 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 319 |
|
| 320 |
# Instrument GR to hold the statement on |
| 321 |
# `trans_begin` hook on server1. |
| 322 |
[connection server_1] |
| 323 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 324 |
|
| 325 |
# Execute the statement on server1. |
| 326 |
[connection server1] |
| 327 |
SHOW FUNCTION CODE test.function1; |
| 328 |
|
| 329 |
# Validate that the statement went on |
| 330 |
# `trans_begin` hook on server1. |
| 331 |
[connection server_1] |
| 332 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 333 |
|
| 334 |
# Release the statement from |
| 335 |
# `trans_begin` hook on server1. |
| 336 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 337 |
|
| 338 |
# Reap the statement on server1. |
| 339 |
[connection server1] |
| 340 |
|
| 341 |
# Remove GR instrumentaion to hold the statement on |
| 342 |
# `trans_begin` hook on server1. |
| 343 |
[connection server_1] |
| 344 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 345 |
|
| 346 |
# Instrument GR to hold the statement on |
| 347 |
# `trans_begin` hook on server1. |
| 348 |
[connection server_1] |
| 349 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 350 |
|
| 351 |
# Execute the statement on server1. |
| 352 |
[connection server1] |
| 353 |
SHOW CREATE EVENT test.event1; |
| 354 |
|
| 355 |
# Validate that the statement went on |
| 356 |
# `trans_begin` hook on server1. |
| 357 |
[connection server_1] |
| 358 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 359 |
|
| 360 |
# Release the statement from |
| 361 |
# `trans_begin` hook on server1. |
| 362 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 363 |
|
| 364 |
# Reap the statement on server1. |
| 365 |
[connection server1] |
| 366 |
|
| 367 |
# Remove GR instrumentaion to hold the statement on |
| 368 |
# `trans_begin` hook on server1. |
| 369 |
[connection server_1] |
| 370 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 371 |
|
| 372 |
# Instrument GR to hold the statement on |
| 373 |
# `trans_begin` hook on server1. |
| 374 |
[connection server_1] |
| 375 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 376 |
|
| 377 |
# Execute the statement on server1. |
| 378 |
[connection server1] |
| 379 |
SHOW CREATE TRIGGER test.trigger1; |
| 380 |
|
| 381 |
# Validate that the statement went on |
| 382 |
# `trans_begin` hook on server1. |
| 383 |
[connection server_1] |
| 384 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 385 |
|
| 386 |
# Release the statement from |
| 387 |
# `trans_begin` hook on server1. |
| 388 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 389 |
|
| 390 |
# Reap the statement on server1. |
| 391 |
[connection server1] |
| 392 |
|
| 393 |
# Remove GR instrumentaion to hold the statement on |
| 394 |
# `trans_begin` hook on server1. |
| 395 |
[connection server_1] |
| 396 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 397 |
|
| 398 |
# Instrument GR to hold the statement on |
| 399 |
# `trans_begin` hook on server1. |
| 400 |
[connection server_1] |
| 401 |
# Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug |
| 402 |
|
| 403 |
# Execute the statement on server1. |
| 404 |
[connection server1] |
| 405 |
SHOW CREATE USER CURRENT_USER(); |
| 406 |
|
| 407 |
# Validate that the statement went on |
| 408 |
# `trans_begin` hook on server1. |
| 409 |
[connection server_1] |
| 410 |
SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting"; |
| 411 |
|
| 412 |
# Release the statement from |
| 413 |
# `trans_begin` hook on server1. |
| 414 |
SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue'; |
| 415 |
|
| 416 |
# Reap the statement on server1. |
| 417 |
[connection server1] |
| 418 |
|
| 419 |
# Remove GR instrumentaion to hold the statement on |
| 420 |
# `trans_begin` hook on server1. |
| 421 |
[connection server_1] |
| 422 |
# Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug |
| 423 |
|
| 424 |
############################################################ |
| 425 |
# 3. Clean up. |
| 426 |
[connection server1] |
| 427 |
DROP PROCEDURE procedure1; |
| 428 |
DROP FUNCTION function1; |
| 429 |
DROP EVENT event1; |
| 430 |
DROP TRIGGER trigger1; |
| 431 |
DROP TABLE t2; |
| 432 |
DROP TABLE t1; |
| 433 |
include/group_replication_end.inc |