Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_only_start_replica_after_clone.result

raw
1 include/master-slave.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 master]
6 [connection slave]
7 CHANGE REPLICATION SOURCE TO GTID_ONLY = 1, REQUIRE_ROW_FORMAT=1;
8 include/start_slave.inc
9 [connection master]
10 #
11 # 1. Create connections to server3
12 #
13 # 2. Create a table for testing
14 [connection server_1]
15 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
16 include/sync_slave_sql_with_master.inc
17 #
18 # 3. Install clone on server 2
19 # Configure server 3 to invoke clone
20 [connection server_2]
21 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
22 [connection server_3]
23 include/spawn_monitoring_process.inc
24 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
25 SET GLOBAL clone_valid_donor_list = 'localhost:SERVER2_PORT';
26 CLONE INSTANCE FROM root@localhost:SERVER2_PORT IDENTIFIED BY '';
27 include/rpl_reconnect.inc
28 #
29 # 4. Execute a transaction on server 1, check 3 received it
30 [connection server_1]
31 INSERT INTO t1 VALUES (1);
32 include/sync_slave_sql_with_master.inc
33 [connection server_3]
34 include/assert.inc [All info from server 1 is present]
35 #
36 # 4.1 Check that the replica only retrieves the missing transaction
37 USE test;
38 include/gtid_utils.inc
39 include/assert.inc [Exactly 1 GTIDs should have been retrieved since last invocation]
40 include/gtid_utils_end.inc
41 #
42 # 5. Cleanup
43 [connection server_1]
44 DROP TABLE test.t1;
45 include/rpl_sync.inc
46 [connection server_2]
47 UNINSTALL PLUGIN clone;
48 [connection server_3]
49 STOP SLAVE;
50 Warnings:
51 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
52 RESET SLAVE ALL;
53 Warnings:
54 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
55 UNINSTALL PLUGIN clone;
56 include/rpl_clear_priv_checks_user_configuration.inc
57 include/clean_monitoring_process.inc
58 SET SESSION sql_log_bin=0;
59 call mtr.add_suppression("Clone removing all user data for provisioning: Started");
60 call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
61 call mtr.add_suppression("Recovery from source pos [0-9]+ and file [a-zA-Z-]*\.*[0-9]* for channel ''*");
62 call mtr.add_suppression("Relay log recovery on channel with GTID_ONLY=1*");
63 call mtr.add_suppression("Applier metadata information for channel '' was found after a clone operation. Relay log recovery");
64 SET SESSION sql_log_bin=1;
65 [connection slave]
66 include/stop_slave.inc
67 CHANGE REPLICATION SOURCE TO GTID_ONLY = 0, REQUIRE_ROW_FORMAT=0;
68 include/start_slave.inc
69 include/rpl_end.inc