| 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. Make the channel use GTID_ONLY=1 |
| 8 |
# Create a table on the source and replicate it. |
| 9 |
# Add some data making the binlog and relay rotate so the info on the repos is stale |
| 10 |
[connection slave] |
| 11 |
include/gtid_utils.inc |
| 12 |
CHANGE REPLICATION SOURCE TO GTID_ONLY = 1, REQUIRE_ROW_FORMAT=1; |
| 13 |
include/start_slave.inc |
| 14 |
[connection master] |
| 15 |
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY); |
| 16 |
include/sync_slave_sql_with_master.inc |
| 17 |
[connection master] |
| 18 |
INSERT INTO t1 VALUES (3); |
| 19 |
FLUSH LOGS; |
| 20 |
include/sync_slave_sql_with_master.inc |
| 21 |
include/stop_slave.inc |
| 22 |
include/start_slave.inc |
| 23 |
[connection master] |
| 24 |
INSERT INTO t1 VALUES (2); |
| 25 |
FLUSH LOGS; |
| 26 |
include/sync_slave_sql_with_master.inc |
| 27 |
include/stop_slave.inc |
| 28 |
include/start_slave.inc |
| 29 |
[connection master] |
| 30 |
INSERT INTO t1 VALUES (1); |
| 31 |
FLUSH LOGS; |
| 32 |
include/sync_slave_sql_with_master.inc |
| 33 |
include/stop_slave.inc |
| 34 |
include/start_slave.inc |
| 35 |
# |
| 36 |
# 2. Restart the replica with relay log recovery |
| 37 |
# Check that the replica wont replicate old transactions even if position are outdated |
| 38 |
include/rpl_restart_server.inc [server_number=2 parameters: --skip_replica_start=FALSE --relay_log_recovery=1] |
| 39 |
[connection master] |
| 40 |
INSERT INTO t1 VALUES(4); |
| 41 |
include/sync_slave_sql_with_master.inc |
| 42 |
include/assert.inc [Exactly 1 GTIDs should have been retrieved since last invocation] |
| 43 |
include/assert_grep.inc [The relay log recovery message does not mention positions] |
| 44 |
# |
| 45 |
# 3. Cleanup |
| 46 |
include/stop_slave.inc |
| 47 |
CHANGE REPLICATION SOURCE TO GTID_ONLY = 0, REQUIRE_ROW_FORMAT=0; |
| 48 |
include/start_slave.inc |
| 49 |
include/gtid_utils_end.inc |
| 50 |
include/suppress_messages.inc |
| 51 |
# Connection 1 suppresses message <Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the GTID protocol will be used to replicate unapplied transactions.>. |
| 52 |
# Connection 2 suppresses message <Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the GTID protocol will be used to replicate unapplied transactions.>. |
| 53 |
[connection master] |
| 54 |
DROP TABLE t1; |
| 55 |
include/rpl_end.inc |