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
|
include/group_replication.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 server1]
#
# 1. Test local recovery
# Start group_replication on the first node after setting the debug
# point to block recovery. Check whether transactions can be executed.
#
SET @debug_save= @@GLOBAL.DEBUG;
# Set the debug flag to block recovery at different stages.
SET @@GLOBAL.DEBUG='+d,recovery_thread_start_wait';
include/start_group_replication.inc
CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY);
ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
SET DEBUG_SYNC= "now SIGNAL signal.recovery_continue";
# Now wait for the node to be online
include/gr_wait_for_member_state.inc
# Table creation should pass as the single member is now recovered.
CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY);
SET @@GLOBAL.DEBUG= @debug_save;
#
# 2. Test for a joining member
# Start group_replication on the second member and block state transfer
# Query execution should not be allowed
#
SET @@GLOBAL.DEBUG='+d,block_applier_updates';
include/start_group_replication.inc
CREATE TABLE t2 (i INT NOT NULL PRIMARY KEY);
ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
SET @@GLOBAL.DEBUG='-d,block_applier_updates';
SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
include/gr_wait_for_member_state.inc
# Table creation should pass as this node has now recovered.
CREATE TABLE t2 (i INT NOT NULL PRIMARY KEY);
#
# Cleanup
#
DROP TABLE t1;
DROP TABLE t2;
SET DEBUG_SYNC= 'RESET';
include/group_replication_end.inc
|
