sysvars_wsrep.result

select * from information_schema.system_variables
where variable_name like 'wsrep%'
  order by variable_name;
VARIABLE_NAME	WSREP_AUTO_INCREMENT_CONTROL
SESSION_VALUE	NULL
GLOBAL_VALUE	ON
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To automatically control the assignment of autoincrement variables
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CAUSAL_READS
SESSION_VALUE	OFF
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Setting this variable is equivalent to setting wsrep_sync_wait READ flag
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CERTIFICATION_RULES
SESSION_VALUE	NULL
GLOBAL_VALUE	strict
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	strict
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Certification rules to use in the cluster. Possible values are: "strict": stricter rules that could result in more certification failures. "optimized": relaxed rules that allow more concurrency and cause less certification failures.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	strict,optimized
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CERTIFY_NONPK
SESSION_VALUE	NULL
GLOBAL_VALUE	ON
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Certify tables with no primary key
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CLUSTER_ADDRESS
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Address to initially connect to cluster
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CLUSTER_NAME
SESSION_VALUE	NULL
GLOBAL_VALUE	my_wsrep_cluster
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	my_wsrep_cluster
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Name for the cluster
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_CONVERT_LOCK_TO_TRX
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To convert locking sessions into transactions
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DATA_HOME_DIR
SESSION_VALUE	NULL
GLOBAL_VALUE	DATADIR
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	DATADIR
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	home directory for wsrep provider
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DBUG_OPTION
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	DBUG options to provider library
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DEBUG
SESSION_VALUE	NULL
GLOBAL_VALUE	NONE
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	NONE
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	WSREP debug level logging
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NONE,SERVER,TRANSACTION,STREAMING,CLIENT
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DESYNC
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To desynchronize the node from the cluster
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DIRTY_READS
SESSION_VALUE	OFF
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Allow reads even when the node is not in the primary component.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_DRUPAL_282555_WORKAROUND
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_FORCED_BINLOG_FORMAT
SESSION_VALUE	NULL
GLOBAL_VALUE	NONE
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	NONE
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	binlog format to take effect over user's choice
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	MIXED,STATEMENT,ROW,NONE
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_GTID_DOMAIN_ID
SESSION_VALUE	NULL
GLOBAL_VALUE	0
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	When wsrep_gtid_mode is set, this value is used as gtid_domain_id for galera transactions and also copied to the joiner nodes during state transfer. It is ignored, otherwise.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_GTID_MODE
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Automatically update the (joiner) node's wsrep_gtid_domain_id value with that of donor's (received during state transfer) and use it in place of gtid_domain_id for all galera transactions. When OFF (default), wsrep_gtid_domain_id is simply ignored (backward compatibility).
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_GTID_SEQ_NO
SESSION_VALUE	0
GLOBAL_VALUE	NULL
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	SESSION ONLY
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Internal server usage, manually set WSREP GTID seqno.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	NULL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_IGNORE_APPLY_ERRORS
SESSION_VALUE	NULL
GLOBAL_VALUE	7
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	7
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Ignore replication errors
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	7
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_LOAD_DATA_SPLITTING
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To commit LOAD DATA transaction after every 10K rows inserted (deprecated)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_LOG_CONFLICTS
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To log multi-master conflicts
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_MAX_WS_ROWS
SESSION_VALUE	NULL
GLOBAL_VALUE	0
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Max number of rows in write set
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	1048576
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_MAX_WS_SIZE
SESSION_VALUE	NULL
GLOBAL_VALUE	2147483647
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	2147483647
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Max write set size (bytes)
NUMERIC_MIN_VALUE	1024
NUMERIC_MAX_VALUE	2147483647
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_MODE
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	SET
VARIABLE_COMMENT	Set of WSREP features that are enabled.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID,BF_ABORT_MARIABACKUP
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_MYSQL_REPLICATION_BUNDLE
SESSION_VALUE	NULL
GLOBAL_VALUE	0
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	mysql replication group commit 
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	1000
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_NODE_ADDRESS
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Specifies the node's network address, in the format ip address[:port]. Used in situations where autoguessing is not reliable. As of MariaDB 10.1.8, supports IPv6.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_NODE_INCOMING_ADDRESS
SESSION_VALUE	NULL
GLOBAL_VALUE	AUTO
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	AUTO
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Client connection address
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_NODE_NAME
SESSION_VALUE	NULL
GLOBAL_VALUE	HOSTNAME
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	HOSTNAME
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Name of this node. This name can be used in wsrep_sst_donor as a preferred donor. Note that multiple nodes in a cluster can have the same name.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_NOTIFY_CMD
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_ON
SESSION_VALUE	OFF
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	To enable wsrep replication 
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_OSU_METHOD
SESSION_VALUE	TOI
GLOBAL_VALUE	TOI
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	TOI
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Method for Online Schema Upgrade
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	TOI,RSU
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_PATCH_VERSION
SESSION_VALUE	NULL
GLOBAL_VALUE	wsrep_MAJVER.MINVER
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	NULL
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Wsrep patch version, for example wsrep_MAJVER.MINVER.
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	NULL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_PROVIDER
SESSION_VALUE	NULL
GLOBAL_VALUE	none
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	none
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Path to replication provider library
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_PROVIDER_OPTIONS
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Semicolon (;) separated list of wsrep options (see wsrep_provider_options documentation).
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_RECOVER
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Recover database state after crash and exit
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_REJECT_QUERIES
SESSION_VALUE	NULL
GLOBAL_VALUE	NONE
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	NONE
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Variable to set to reject queries
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NONE,ALL,ALL_KILL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_RESTART_SLAVE
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Should MariaDB slave be restarted automatically, when node joins back to cluster
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_RETRY_AUTOCOMMIT
SESSION_VALUE	1
GLOBAL_VALUE	1
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	1
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Max number of times to retry a failed autocommit statement
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	10000
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SLAVE_FK_CHECKS
SESSION_VALUE	NULL
GLOBAL_VALUE	ON
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Should slave thread do foreign key constraint checks
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SLAVE_THREADS
SESSION_VALUE	NULL
GLOBAL_VALUE	1
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of slave appliers to launch
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	512
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SLAVE_UK_CHECKS
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Should slave thread do secondary index uniqueness checks
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SR_STORE
SESSION_VALUE	NULL
GLOBAL_VALUE	table
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	table
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Storage for streaming replication fragments
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	none,table
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SST_AUTH
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Authentication for SST connection
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SST_DONOR
SESSION_VALUE	NULL
GLOBAL_VALUE	
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	preferred donor node for the SST
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SST_DONOR_REJECTS_QUERIES
SESSION_VALUE	NULL
GLOBAL_VALUE	OFF
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Reject client queries when donating state snapshot transfer
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SST_METHOD
SESSION_VALUE	NULL
GLOBAL_VALUE	rsync
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	rsync
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	State snapshot transfer method
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SST_RECEIVE_ADDRESS
SESSION_VALUE	NULL
GLOBAL_VALUE	AUTO
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	AUTO
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	Address where node is waiting for SST contact
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_START_POSITION
SESSION_VALUE	NULL
GLOBAL_VALUE	00000000-0000-0000-0000-000000000000:-1
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	00000000-0000-0000-0000-000000000000:-1
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	VARCHAR
VARIABLE_COMMENT	global transaction position to start from 
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_SYNC_WAIT
SESSION_VALUE	0
GLOBAL_VALUE	0
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	INT UNSIGNED
VARIABLE_COMMENT	Ensure "synchronous" read view before executing an operation of the type specified by bitmask: 1 - READ(includes SELECT, SHOW and BEGIN/START TRANSACTION); 2 - UPDATE and DELETE; 4 - INSERT and REPLACE
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	15
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_TRX_FRAGMENT_SIZE
SESSION_VALUE	0
GLOBAL_VALUE	0
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	0
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Size of transaction fragments for streaming replication (measured in units of 'wsrep_trx_fragment_unit')
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	2147483647
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL
VARIABLE_NAME	WSREP_TRX_FRAGMENT_UNIT
SESSION_VALUE	bytes
GLOBAL_VALUE	bytes
GLOBAL_VALUE_ORIGIN	COMPILE-TIME
DEFAULT_VALUE	bytes
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Unit for streaming replication transaction fragments' size: bytes, rows, statements
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	bytes,rows,statements
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
GLOBAL_VALUE_PATH	NULL