Debian Codegraph @

mysql-test/suite/group_replication/r/gr_recovery_updates.result

raw
1 include/group_replication.inc [rpl_server_count=4]
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 # Start group replication on the three servers
8 # Add some data in to the members
9 #
10 server1
11 include/start_and_bootstrap_group_replication.inc
12 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (1);
14 server2
15 include/start_group_replication.inc
16 server3
17 include/start_group_replication.inc
18 #
19 # Phase 1: Change the group when the Joiner did not yet choose a Donor.
20 #
21 # Start group replication on server 4
22 # Wait right after recovery is declared as running.
23 #
24 server4
25 SET @debug_save= @@GLOBAL.DEBUG;
26 # Set the debug flag to block recovery
27 SET @@GLOBAL.DEBUG='d,recovery_thread_start_wait';
28 include/start_group_replication.inc
29 #
30 # Stop group replication in one of the other servers
31 # The recovery process should not be affected.
32 #
33 server2
34 include/stop_group_replication.inc
35 server4
36 #
37 # Resume the recovery process.
38 # The data should be there when declared online
39 #
40 SET @@GLOBAL.DEBUG= 'd,recovery_thread_wait_before_finish';
41 SET DEBUG_SYNC= "now SIGNAL signal.recovery_continue";
42 #
43 # Phase 2: Change the group after the state exchange in the Joiner ended.
44 #
45 # Restart group replication on the stopped member
46 #
47 server2
48 include/start_group_replication.inc
49 #
50 # Stop 2 servers while recovery is not yet stopped.
51 #
52 server2
53 include/stop_group_replication.inc
54 server3
55 include/stop_group_replication.inc
56 #
57 # Resume recovery: All should be OK
58 #
59 server4
60 SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
61 SET @@GLOBAL.DEBUG= @debug_save;
62 include/gr_wait_for_member_state.inc
63 #
64 # Test if the servers are working properly
65 #
66 server1
67 INSERT INTO t1 VALUES (2);
68 include/rpl_sync.inc
69 server4
70 include/assert.inc [On the recovered member, the table should exist and have 1 elements;]
71 #
72 # Clean up
73 #
74 server2
75 include/start_group_replication.inc
76 server3
77 include/start_group_replication.inc
78 DROP TABLE t1;
79 include/group_replication_end.inc