| 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 |