mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
95de5248c7
This commit changes backup execution (namely the block ddl phase), so that node is not paused from cluster. Instead, the following backup execution is declared as vulnerable for possible cluster level conflicts, especially with DDL statement applying. With this, the mariabackup execution may be aborted, if DDL statements happen during backup execution. This abortable backup execution is optional feature and may be enabled/disabled by wsrep_mode: BF_ABORT_MARIABACKUP. Note that old style node desync and pause, despite of WSREP_MODE_BF_MARIABACKUP is needed if node is operating as SST donor. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
65 lines
1.6 KiB
Text
65 lines
1.6 KiB
Text
--source include/galera_cluster.inc
|
|
|
|
# default
|
|
SELECT @@wsrep_mode;
|
|
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SELECT @@wsrep_mode;
|
|
|
|
--error ER_GLOBAL_VARIABLE
|
|
SET SESSION wsrep_mode=DEFAULT;
|
|
SELECT @@global.wsrep_mode;
|
|
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
|
|
SELECT @@session.wsrep_mode;
|
|
|
|
#
|
|
# Incorrect input
|
|
#
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_mode=A;
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_mode='A';
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_mode=NULL;
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_mode=128;
|
|
--error ER_PARSE_ERROR
|
|
SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM;
|
|
#
|
|
# Correct input
|
|
#
|
|
SET GLOBAL wsrep_mode=1;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=32;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode='';
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=STRICT_REPLICATION;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=BINLOG_ROW_FORMAT_ONLY;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode=DISALLOW_LOCAL_GTID;
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY';
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode='BINLOG_ROW_FORMAT_ONLY,STRICT_REPLICATION';
|
|
SELECT @@wsrep_mode;
|
|
SET GLOBAL wsrep_mode='STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID';
|
|
SELECT @@wsrep_mode;
|
|
|
|
# reset
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
|
|
|
|
|
|
|
|
|
|
|