diff options
| author | Brandon Nesterenko <brandon.nesterenko@mariadb.com> | 2022-05-23 14:14:00 -0600 |
|---|---|---|
| committer | Brandon Nesterenko <brandon.nesterenko@mariadb.com> | 2022-07-26 13:31:27 -0600 |
| commit | 5ab5ff08b008417f32dd4bb15820a1a53ea3821c (patch) | |
| tree | 065fb608faf7067e7efb40e5d2ef1f74d9d7a17e /mysql-test/suite/rpl/include/rpl_start_stop_slave.test | |
| parent | 8c2faad576d6a77314e92755a389de2c41e21242 (diff) | |
| download | mariadb-git-5ab5ff08b008417f32dd4bb15820a1a53ea3821c.tar.gz | |
MDEV-19801: Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it
This commit makes replicas crash-safe by default by changing the
Using_Gtid value to be Slave_Pos on a fresh slave start and after
RESET SLAVE is issued. If the primary server does not support GTIDs
(i.e., version < 10), the replica will fall back to Using_Gtid=No on
slave start and after RESET SLAVE.
The following additional informational messages/warnings are added:
1. When Using_Gtid is automatically changed. That is, if RESET
SLAVE reverts Using_Gtid back to Slave_Pos, or Using_Gtid is
inferred to No from a CHANGE MASTER TO given with log coordinates
without MASTER_USE_GTID.
2. If options are ignored in CHANGE MASTER TO. If CHANGE MASTER TO
is given with log coordinates, yet also specifies
MASTER_USE_GTID=Slave_Pos, a warning message is given that the log
coordinate options are ignored.
Additionally, an MTR macro has been added for RESET SLAVE,
reset_slave.inc, which provides modes/options for resetting a slave
in log coordinate or gtid modes. When in log coordinates mode, the
macro will execute CHANGE MASTER TO MASTER_USE_GTID=No after the
RESET SLAVE command. When in GTID mode, an extra parameter,
reset_slave_keep_gtid_state, can be set to reset or preserve the
value of gtid_slave_pos.
Reviewed By:
===========
Andrei Elkin <andrei.elkin@mariadb.com>
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_start_stop_slave.test')
| -rw-r--r-- | mysql-test/suite/rpl/include/rpl_start_stop_slave.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/rpl/include/rpl_start_stop_slave.test b/mysql-test/suite/rpl/include/rpl_start_stop_slave.test index 32f33b2a31d..ae5f83613fe 100644 --- a/mysql-test/suite/rpl/include/rpl_start_stop_slave.test +++ b/mysql-test/suite/rpl/include/rpl_start_stop_slave.test @@ -195,7 +195,7 @@ let $master_pos= `SELECT $master_pos + 1`; --connection slave --source include/stop_slave.inc --replace_regex /[0-9]+/MASTER_POS/ -eval CHANGE MASTER TO master_log_pos=$master_pos; +eval CHANGE MASTER TO master_log_pos=$master_pos, master_use_gtid=no; START SLAVE; # ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 |