Debian Codegraph @

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

raw
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. Install clone plugin on server1.
9 # Commit some data and then purge all binary logs.
10 # Bootstrap a group on server1.
11 [connection server1]
12 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
13 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (1);
15 INSERT INTO t1 VALUES (2);
16 SET sql_log_bin = 0;
17 include/gtid_utils.inc
18 SET sql_log_bin = 1;
19 FLUSH BINARY LOGS;
20 PURGE BINARY LOGS TO 'CURRENT_BINLOG_FILE';
21 include/assert.inc [GTID_PURGED must be equal to GTID_EXECUTED]
22 include/start_and_bootstrap_group_replication.inc
23
24 #####################################################################
25 # 2. Install clone plugin on server2.
26 # Restart server with a monitoring process (mysqld_safe) if needed
27 [connection server2]
28 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
29 include/spawn_monitoring_process.inc
30
31 #####################################################################
32 # 3. Start GR, clone must be executed since recovery
33 # from binary logs is not possible.
34 # As a test variation, do not start on boot after cloning
35 START GROUP_REPLICATION;
36 include/rpl_reconnect.inc
37 include/start_group_replication.inc
38 include/assert.inc [Clone status must be completed]
39 include/diff_tables.inc [server1:test.t1, server2:test.t1]
40
41 ############################################################
42 # 4. Cleanup.
43 [connection server2]
44 RESET PERSIST IF EXISTS group_replication_group_name;
45 RESET PERSIST IF EXISTS group_replication_local_address;
46 RESET PERSIST IF EXISTS group_replication_group_seeds;
47 RESET PERSIST IF EXISTS group_replication_communication_stack;
48 DROP TABLE t1;
49 include/gtid_utils_end.inc
50 include/rpl_sync.inc
51 set session sql_log_bin=0;
52 call mtr.add_suppression("This member will start distributed recovery using clone. It is due to no ONLINE member has the missing data for recovering in its binary logs.");
53 call mtr.add_suppression("Clone removing all user data for provisioning: Started");
54 call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
55 set session sql_log_bin=1;
56 include/clean_monitoring_process.inc
57 include/group_replication_end.inc