Debian Codegraph @

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