Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 # Setup a new group
8 #
9 server1
10 include/start_and_bootstrap_group_replication.inc
11 # Add some data for recovery
12 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
13 BEGIN;
14 INSERT INTO t1 VALUES (1);
15 INSERT INTO t1 VALUES (2);
16 COMMIT;
17 INSERT INTO t1 VALUES (3);
18 #
19 # 1) Create a 3 member group and verify that it is functional
20 #
21 #Add 2 more members
22 server2
23 include/start_group_replication.inc
24 server3
25 include/start_group_replication.inc
26 #After recovery all members must see 3 other members
27 include/rpl_gr_wait_for_number_of_members.inc
28 include/rpl_gr_wait_for_number_of_members.inc
29 include/rpl_gr_wait_for_number_of_members.inc
30 #After recovery all members must have the data present in the donor.
31 include/assert.inc [On all members, the table should exist and have 3 elements]
32 include/assert.inc [On all members, the table should exist and have 3 elements]
33 include/assert.inc [On all members, the table should exist and have 3 elements]
34 #
35 # 2) Shut down all members until 0. Add some data in the process.
36 #
37 #Stop the member 3
38 server3
39 include/stop_group_replication.inc
40 #Add some data to future recoveries and ensure that every member has it
41 server2
42 INSERT INTO t1 VALUES (4);
43 INSERT INTO t1 VALUES (5);
44 include/rpl_sync.inc
45 #Stop the member 2
46 include/stop_group_replication.inc
47 #Add some data to future recoveries
48 server1
49 INSERT INTO t1 VALUES (6);
50 INSERT INTO t1 VALUES (7);
51 #Stop the member 1
52 include/stop_group_replication.inc
53 #
54 # 3) Bring up the group back to life. At the end, all data must be in
55 # all three members.
56 #
57 server1
58 include/start_and_bootstrap_group_replication.inc
59 server2
60 include/start_group_replication.inc
61 server3
62 include/start_group_replication.inc
63 #After recovery all members must see 3 other members
64 include/rpl_gr_wait_for_number_of_members.inc
65 include/rpl_gr_wait_for_number_of_members.inc
66 include/rpl_gr_wait_for_number_of_members.inc
67 #After recovery all members must have the data present in the donor.
68 include/assert.inc [On all members, the table should exist and have 7 elements]
69 include/assert.inc [On all members, the table should exist and have 7 elements]
70 include/assert.inc [On all members, the table should exist and have 7 elements]
71 #
72 # Cleaning up
73 #
74 DROP TABLE t1;
75 include/group_replication_end.inc