The Library

MariaDB Options

These are MariaDB Server and Enterprise options. If you click on a particular variable in this table, your web browser will scroll down to the entry for it with more details and an explanation.

MariaDB Server Options


Option
Default Value
Global
Dynamic		 Initial
Version		 Version
Deprecated
wsrep_mode=REPLICATE_ARIA OFF Yes   1.0  
wsrep_mode=REPLICATE_MYISAM OFF Yes   1.0  

wsrep_mode=REPLICATE_ARIA

Note

This is an experimental feature. This is documentation for currently unreleased software, that is, MariaDB 10.6.

Together with wsrep_mode=REPLICATE_MYISAM, this parameter enables Galera to replicate both DDL and DML for ARIA and/or MyISAM using TOI.

For example:

SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";

Replicates both Aria and MyISAM DML, but requires a primary key for replicated table.

Command-line Format --wsrep_mode_replicate_aria
System Variable wsrep_mode_replicate_aria
Variable Scope Global
Dynamic Variable  
Permitted Values Boolean
Default Value OFF
Initial Version Version 1.0
MariaDB Version Version 10.6

You can execute the following SHOW VARIABLES statement to see how its set:

SHOW VARIABLES LIKE 'wsrep_mode_replicate_aria';

 +------------------------------+-------+
 | Variable_name                | Value |
 +------------------------------+-------+
 | wsrep_mode_replicate_aria    | ON    |
 +------------------------------+-------+

wsrep_mode=REPLICATE_MYISAM

Note

This is an experimental feature. This is documentation for currently unreleased software, that is, MariaDB 10.6.

Together with wsrep_mode=REPLICATE_ARIA, this parameter enables Galera to replicate both DDL and DML for MyISAM and/or Aria using TOI.

For example:

SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";

Replicates both MyISAM and Aria DML, but requires a primary key for replicated table.

Command-line Format --wsrep_mode_replicate_myisam
System Variable wsrep_mode_replicate_myisam
Variable Scope Global
Dynamic Variable  
Permitted Values Boolean
Default Value OFF
Initial Version Version 1.0
MariaDB Version Version 10.6

You can execute the following SHOW VARIABLES statement to see how its set:

SHOW VARIABLES LIKE 'wsrep_mode_replicate_myisam';

 +------------------------------+-------+
 | Variable_name                | Value |
 +------------------------------+-------+
 | wsrep_mode_replicate_myisam  | ON    |
 +------------------------------+-------+

MariaDB Enterprise Options


Option
Default Value
Global
Dynamic		 Initial
Version		 Version
Deprecated
wsrep-OSU-mode OFF Yes   1.0  
wsrep_strict_ddl TOI Global and Session Yes 1.0  

wsrep-osu-mode

This parameter defines the mode for Online Schema Upgrade that the node uses to replicate DDL statements. The following methods are available:

DDL statements are non-transactional and as such don’t replicate through write-sets. There are two methods available that determine how the node handles replicating these statements:

  • TOI In the Total Order Isolation method, the cluster runs the DDL statement on all nodes in the same total order sequence, blocking other transactions from committing while the DDL is in progress.
  • RSU In the Rolling Schema Upgrade method, the node runs the DDL statements locally, thus blocking only the one node where the statement was made. While processing the DDL statement, the node is not replicating and may be unable to process replication events due to a table lock. Once the DDL operation is complete, the node catches up and syncs with the cluster to become fully operational again. The DDL statement or its effects are not replicated; the user is responsible for manually executing this statement on each node in the cluster.
  • NBO When the Non Blocking Option is used, DDL statements are processed in three phases:
    1. MDL lock requests for the operation are replicated first
    2. DDL statements are executed, with MDL protection
    3. Finally, the MDL lock release requests are replicated

For more information on DDL statements and OSU methods, see Schema Upgrades.

Command-line Format --wsrep-osu-mode
System Variable wsrep-osu-mode
Variable Scope Global and Session
Dynamic Variable Yes
Permitted Values (TOI | RSU | NBO)
Default Value TOI
Initial Version Version 1.0
MariaDB Version Version 10.5

You can execute the following SHOW VARIABLES statement to see how its set:

SHOW VARIABLES LIKE 'Parameters; wsrep-osu-mode';

 +------------------------------+-------+
 | Variable_name                | Value |
 +------------------------------+-------+
 | Parameters; wsrep-osu-mode   | TOI   |
 +------------------------------+-------+

wsrep_strict_ddl

If set, rejects DDL on affected tables not supporting Galera replication.

Command-line Format --wsrep_strict_ddl
System Variable wsrep_strict_ddl
Variable Scope Global
Dynamic Variable Yes
Permitted Values Boolean (OFF, ON)
Default Value OFF
Initial Version Version 1.0
MariaDB Version Version 10.5

You can execute the following SHOW VARIABLES statement to see how its set:

SHOW VARIABLES LIKE 'Parameters; wsrep_strict_ddl';

 +------------------------------+-------+
 | Variable_name                | Value |
 +------------------------------+-------+
 | Parameters; wsrep_strict_ddl | OFF   |
 +------------------------------+-------+