diff options
Diffstat (limited to 'mysql-test/suite/wsrep')
21 files changed, 1556 insertions, 11 deletions
diff --git a/mysql-test/suite/wsrep/my.cnf b/mysql-test/suite/wsrep/my.cnf index e35f73f4..668d09b5 100644 --- a/mysql-test/suite/wsrep/my.cnf +++ b/mysql-test/suite/wsrep/my.cnf @@ -1,5 +1,5 @@ # Use default setting for mysqld processes -!include include/default_mysqld.cnf +!include include/default_my.cnf [mysqld.1] wsrep-on=ON diff --git a/mysql-test/suite/wsrep/r/variables.result b/mysql-test/suite/wsrep/r/variables.result index 2d5d5a66..7f8c6a43 100644 --- a/mysql-test/suite/wsrep/r/variables.result +++ b/mysql-test/suite/wsrep/r/variables.result @@ -41,7 +41,6 @@ wsrep_commit_window # wsrep_local_state # wsrep_local_state_comment # wsrep_cert_index_size # -wsrep_causal_reads # wsrep_cert_interval # wsrep_open_transactions # wsrep_open_connections # @@ -90,7 +89,6 @@ SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NA VARIABLE_NAME WSREP_ALLOWLIST WSREP_AUTO_INCREMENT_CONTROL -WSREP_CAUSAL_READS WSREP_CERTIFICATION_RULES WSREP_CERTIFY_NONPK WSREP_CLUSTER_ADDRESS diff --git a/mysql-test/suite/wsrep/r/variables_debug.result b/mysql-test/suite/wsrep/r/variables_debug.result index 2ce69827..d088c4f1 100644 --- a/mysql-test/suite/wsrep/r/variables_debug.result +++ b/mysql-test/suite/wsrep/r/variables_debug.result @@ -41,7 +41,6 @@ wsrep_commit_window # wsrep_local_state # wsrep_local_state_comment # wsrep_cert_index_size # -wsrep_causal_reads # wsrep_cert_interval # wsrep_open_transactions # wsrep_open_connections # @@ -91,7 +90,6 @@ SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NA VARIABLE_NAME WSREP_ALLOWLIST WSREP_AUTO_INCREMENT_CONTROL -WSREP_CAUSAL_READS WSREP_CERTIFICATION_RULES WSREP_CERTIFY_NONPK WSREP_CLUSTER_ADDRESS diff --git a/mysql-test/suite/wsrep/r/wsrep-recover-v25,binlogon.rdiff b/mysql-test/suite/wsrep/r/wsrep-recover-v25,binlogon.rdiff index 596abf9c..5fc091c7 100644 --- a/mysql-test/suite/wsrep/r/wsrep-recover-v25,binlogon.rdiff +++ b/mysql-test/suite/wsrep/r/wsrep-recover-v25,binlogon.rdiff @@ -1,5 +1,5 @@ ---- r/wsrep-recover-v25.result 2019-02-28 09:20:56.153775856 +0200 -+++ r/wsrep-recover-v25.reject 2019-02-28 09:22:16.578113115 +0200 +--- r/wsrep-recover-v25.result ++++ r/wsrep-recover-v25.reject @@ -12,4 +12,16 @@ SELECT VARIABLE_VALUE `expect 6` FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'; expect 6 diff --git a/mysql-test/suite/wsrep/r/wsrep_provider_plugin.result b/mysql-test/suite/wsrep/r/wsrep_provider_plugin.result new file mode 100644 index 00000000..abcc15b5 --- /dev/null +++ b/mysql-test/suite/wsrep/r/wsrep_provider_plugin.result @@ -0,0 +1,24 @@ +# Correct Galera library found +CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB; +SET GLOBAL wsrep_provider_repl_max_ws_size=1; +SHOW VARIABLES LIKE 'wsrep_provider_repl_max_ws_size'; +Variable_name Value +wsrep_provider_repl_max_ws_size 1 +INSERT INTO t1 VALUES (1); +ERROR HY000: Maximum writeset size exceeded +SET GLOBAL wsrep_provider_repl_max_ws_size=DEFAULT; +SHOW VARIABLES LIKE 'wsrep_provider_repl_max_ws_size'; +Variable_name Value +wsrep_provider_repl_max_ws_size 2147483647 +INSERT INTO t1 VALUES (1); +SET GLOBAL wsrep_provider_options='repl.max_ws_size=1'; +ERROR HY000: Variable 'wsrep_provider_options' is a read only variable +INSERT INTO t1 VALUES (2); +SET GLOBAL wsrep_provider='none'; +ERROR HY000: Variable 'wsrep_provider' is a read only variable +DROP TABLE t1; +CALL mtr.add_suppression("transaction size limit"); +CALL mtr.add_suppression("rbr write fail"); +SELECT VARIABLE_NAME,READ_ONLY FROM information_schema.system_variables where VARIABLE_NAME like '%wsrep_provider_options%'; +VARIABLE_NAME READ_ONLY +WSREP_PROVIDER_OPTIONS YES diff --git a/mysql-test/suite/wsrep/r/wsrep_provider_plugin_basic.result b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_basic.result new file mode 100644 index 00000000..23c4d45f --- /dev/null +++ b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_basic.result @@ -0,0 +1,66 @@ +# Correct Galera library found +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_socket_recv_buf_size'; +variable_type global_value +VARCHAR auto +set global wsrep_provider_socket_recv_buf_size = 'foo'; +ERROR 42000: Variable 'socket_recv_buf_size' can't be set to the value of 'foo' +set global wsrep_provider_socket_recv_buf_size = '1M'; +show global variables like 'wsrep_provider_socket_recv_buf_size'; +Variable_name Value +wsrep_provider_socket_recv_buf_size 1M +set global wsrep_provider_socket_recv_buf_size = default; +show global variables like 'wsrep_provider_socket_recv_buf_size'; +Variable_name Value +wsrep_provider_socket_recv_buf_size auto +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_evs_send_window'; +variable_type global_value +BIGINT 4 +set global wsrep_provider_evs_send_window = -10; +ERROR 42000: Variable 'evs_send_window' can't be set to the value of '-10' +set global wsrep_provider_evs_send_window = 10; +show global variables like 'wsrep_provider_evs_send_window'; +Variable_name Value +wsrep_provider_evs_send_window 10 +set global wsrep_provider_evs_send_window = default; +show global variables like 'wsrep_provider_evs_send_window'; +Variable_name Value +wsrep_provider_evs_send_window 4 +select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_gcs_max_throttle'; +variable_type +DOUBLE +set global wsrep_provider_gcs_max_throttle = 1.1; +ERROR 42000: Variable 'gcs_max_throttle' can't be set to the value of '1.100000' +set global wsrep_provider_gcs_max_throttle = 0.5; +show global variables like 'wsrep_provider_gcs_max_throttle'; +Variable_name Value +wsrep_provider_gcs_max_throttle 0.500000 +set global wsrep_provider_gcs_max_throttle = default; +show global variables like 'wsrep_provider_gcs_max_throttle'; +Variable_name Value +wsrep_provider_gcs_max_throttle 0.250000 +select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_cert_log_conflicts'; +variable_type +BOOLEAN +set global wsrep_provider_cert_log_conflicts = on; +show global variables like 'wsrep_provider_cert_log_conflicts'; +Variable_name Value +wsrep_provider_cert_log_conflicts ON +set global wsrep_provider_cert_log_conflicts = off; +show global variables like 'wsrep_provider_cert_log_conflicts'; +Variable_name Value +wsrep_provider_cert_log_conflicts OFF +set global wsrep_provider_cert_log_conflicts = default; +show global variables like 'wsrep_provider_cert_log_conflicts'; +Variable_name Value +wsrep_provider_cert_log_conflicts OFF +select read_only from information_schema.system_variables where variable_name = 'wsrep_provider_evs_auto_evict'; +read_only +YES +set global wsrep_provider_evs_auto_evict = on; +ERROR HY000: Variable 'wsrep_provider_evs_auto_evict' is a read only variable +set global wsrep_provider_gcs_fc_master_slave = default; +Warnings: +Warning 1287 '@@wsrep_provider_gcs_fc_master_slave' is deprecated and will be removed in a future release +call mtr.add_suppression("error setting param"); +call mtr.add_suppression("Unknown parameter"); +call mtr.add_suppression("Setting parameter"); diff --git a/mysql-test/suite/wsrep/r/wsrep_provider_plugin_defaults.result b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_defaults.result new file mode 100644 index 00000000..cefeb85d --- /dev/null +++ b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_defaults.result @@ -0,0 +1,1259 @@ +# Correct Galera library found +SELECT COUNT(*) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_provider%' AND VARIABLE_NAME NOT IN ( +'wsrep_provider', +'wsrep_provider_options', +'wsrep_provider_base_dir', +'wsrep_provider_base_port', +'wsrep_provider_gcache_dir', +'wsrep_provider_dbug', +'wsrep_provider_gcache_debug', +'wsrep_provider_signal', +'wsrep_provider_protonet_backend', +'wsrep_provider_repl_proto_max', +'wsrep_provider_gmcast_listen_addr'); +COUNT(*) +82 +SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES +WHERE VARIABLE_NAME LIKE 'wsrep_provider_%' AND VARIABLE_NAME NOT IN ( +'wsrep_provider', +'wsrep_provider_options', +'wsrep_provider_base_dir', +'wsrep_provider_base_port', +'wsrep_provider_gcache_dir', +'wsrep_provider_dbug', +'wsrep_provider_gcache_debug', +'wsrep_provider_signal', +'wsrep_provider_protonet_backend', +'wsrep_provider_repl_proto_max', +'wsrep_provider_gmcast_listen_addr') +ORDER BY VARIABLE_NAME; +VARIABLE_NAME WSREP_PROVIDER_BASE_HOST +SESSION_VALUE NULL +GLOBAL_VALUE 127.0.0.1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 127.0.0.1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_CERT_LOG_CONFLICTS +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_CERT_OPTIMISTIC_PA +SESSION_VALUE NULL +GLOBAL_VALUE ON +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE ON +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_DEBUG +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_AUTO_EVICT +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_CAUSAL_KEEPALIVE_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 1.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_DEBUG_LOG_MASK +SESSION_VALUE NULL +GLOBAL_VALUE 0x1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0x1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_EVS_DELAYED_KEEP_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 30.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 30.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_DELAY_MARGIN +SESSION_VALUE NULL +GLOBAL_VALUE 1.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_EVICT +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_EVS_INACTIVE_CHECK_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 0.500000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0.500000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_INACTIVE_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 15.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 15.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_INFO_LOG_MASK +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_EVS_INSTALL_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 7.500000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 7.500000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_JOIN_RETRANS_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 1.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_KEEPALIVE_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 1.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_MAX_INSTALL_TIMEOUTS +SESSION_VALUE NULL +GLOBAL_VALUE 3 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 3 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_SEND_WINDOW +SESSION_VALUE NULL +GLOBAL_VALUE 4 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 4 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_STATS_REPORT_PERIOD +SESSION_VALUE NULL +GLOBAL_VALUE 60.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 60.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_SUSPECT_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 5.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 5.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_USER_SEND_WINDOW +SESSION_VALUE NULL +GLOBAL_VALUE 2 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 2 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_USE_AGGREGATE +SESSION_VALUE NULL +GLOBAL_VALUE ON +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE ON +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_EVS_VERSION +SESSION_VALUE NULL +GLOBAL_VALUE 1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_EVS_VIEW_FORGET_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 86400.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 86400.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_KEEP_PAGES_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_KEEP_PLAINTEXT_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 134217728 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 134217728 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_MEM_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_NAME +SESSION_VALUE NULL +GLOBAL_VALUE galera.cache +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE galera.cache +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_GCACHE_PAGE_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 134217728 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 134217728 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_RECOVER +SESSION_VALUE NULL +GLOBAL_VALUE ON +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE ON +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCACHE_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 10485760 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 10485760 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCOMM_THREAD_PRIO +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_GCS_FC_DEBUG +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_FC_FACTOR +SESSION_VALUE NULL +GLOBAL_VALUE 1.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_FC_LIMIT +SESSION_VALUE NULL +GLOBAL_VALUE 16 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 16 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_FC_MASTER_SLAVE +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_FC_SINGLE_PRIMARY +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_MAX_PACKET_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 64500 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 64500 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_MAX_THROTTLE +SESSION_VALUE NULL +GLOBAL_VALUE 0.250000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0.250000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_RECV_Q_HARD_LIMIT +SESSION_VALUE NULL +GLOBAL_VALUE 9223372036854775807 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 9223372036854775807 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_RECV_Q_SOFT_LIMIT +SESSION_VALUE NULL +GLOBAL_VALUE 0.250000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0.250000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_SYNC_DONOR +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GCS_VOTE_POLICY +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GMCAST_GROUP +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_GMCAST_MCAST_ADDR +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_GMCAST_MCAST_TTL +SESSION_VALUE NULL +GLOBAL_VALUE 1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GMCAST_PEER_ADDR +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_GMCAST_PEER_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 3.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 3.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GMCAST_SEGMENT +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GMCAST_TIME_WAIT +SESSION_VALUE NULL +GLOBAL_VALUE 5.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 5.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_GMCAST_VERSION +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_IST_RECV_ADDR +SESSION_VALUE NULL +GLOBAL_VALUE 127.0.0.1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 127.0.0.1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_IST_RECV_BIND +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PC_ANNOUNCE_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 3.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 3.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_BOOTSTRAP +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_CHECKSUM +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_IGNORE_QUORUM +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_IGNORE_SB +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_LINGER +SESSION_VALUE NULL +GLOBAL_VALUE 20.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 20.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_NPVO +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_RECOVERY +SESSION_VALUE NULL +GLOBAL_VALUE ON +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE ON +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_VERSION +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PC_WAIT_PRIM +SESSION_VALUE NULL +GLOBAL_VALUE ON +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE ON +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_WAIT_PRIM_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 30.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 30.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PC_WEIGHT +SESSION_VALUE NULL +GLOBAL_VALUE 1 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 1 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_PROTONET_VERSION +SESSION_VALUE NULL +GLOBAL_VALUE 0 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 0 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_REPL_CAUSAL_READ_TIMEOUT +SESSION_VALUE NULL +GLOBAL_VALUE 30.000000 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 30.000000 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE DOUBLE +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE 2.2250738585072e-308 +NUMERIC_MAX_VALUE 1.797693134862316e308 +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_REPL_COMMIT_ORDER +SESSION_VALUE NULL +GLOBAL_VALUE 3 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 3 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_REPL_KEY_FORMAT +SESSION_VALUE NULL +GLOBAL_VALUE FLAT8 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE FLAT8 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_REPL_MAX_WS_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE 2147483647 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 2147483647 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_CHECKSUM +SESSION_VALUE NULL +GLOBAL_VALUE 2 +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE 2 +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BIGINT +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE -9223372036854775808 +NUMERIC_MAX_VALUE 9223372036854775807 +NUMERIC_BLOCK_SIZE 0 +ENUM_VALUE_LIST NULL +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_DYNAMIC +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_RECV_BUF_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE auto +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE auto +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_SOCKET_SEND_BUF_SIZE +SESSION_VALUE NULL +GLOBAL_VALUE auto +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE auto +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_PROVIDER_SOCKET_SSL +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_SSL_CA +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_SOCKET_SSL_CERT +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_SOCKET_SSL_CIPHER +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_SSL_COMPRESSION +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY YES +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL +VARIABLE_NAME WSREP_PROVIDER_SOCKET_SSL_KEY +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_SOCKET_SSL_PASSWORD_FILE +SESSION_VALUE NULL +GLOBAL_VALUE +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE VARCHAR +VARIABLE_COMMENT Wsrep provider option +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_SOCKET_SSL_RELOAD +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT Wsrep provider option +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT REQUIRED +GLOBAL_VALUE_PATH NULL diff --git a/mysql-test/suite/wsrep/r/wsrep_provider_plugin_wsrep_off.result b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_wsrep_off.result new file mode 100644 index 00000000..b6ad7e84 --- /dev/null +++ b/mysql-test/suite/wsrep/r/wsrep_provider_plugin_wsrep_off.result @@ -0,0 +1,5 @@ +SELECT @@wsrep_on; +@@wsrep_on +0 +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider%'; +variable_type global_value diff --git a/mysql-test/suite/wsrep/t/alter_table_innodb.cnf b/mysql-test/suite/wsrep/t/alter_table_innodb.cnf index d8e27463..f757621b 100644 --- a/mysql-test/suite/wsrep/t/alter_table_innodb.cnf +++ b/mysql-test/suite/wsrep/t/alter_table_innodb.cnf @@ -1,4 +1,4 @@ -!include include/default_mysqld.cnf +!include include/default_my.cnf [mysqld] wsrep-on=0 diff --git a/mysql-test/suite/wsrep/t/mdev_10186.cnf b/mysql-test/suite/wsrep/t/mdev_10186.cnf index 284c8876..035565fc 100644 --- a/mysql-test/suite/wsrep/t/mdev_10186.cnf +++ b/mysql-test/suite/wsrep/t/mdev_10186.cnf @@ -1,4 +1,4 @@ -!include include/default_mysqld.cnf +!include include/default_my.cnf [mysqld] wsrep-on=0 diff --git a/mysql-test/suite/wsrep/t/pool_of_threads.test b/mysql-test/suite/wsrep/t/pool_of_threads.test index 8e95d0ca..f035236d 100644 --- a/mysql-test/suite/wsrep/t/pool_of_threads.test +++ b/mysql-test/suite/wsrep/t/pool_of_threads.test @@ -1,3 +1,4 @@ +--source include/have_innodb.inc --source include/have_wsrep_enabled.inc --source include/have_binlog_format_row.inc diff --git a/mysql-test/suite/wsrep/t/variables_debug.test b/mysql-test/suite/wsrep/t/variables_debug.test index 5e90d61c..b218586f 100644 --- a/mysql-test/suite/wsrep/t/variables_debug.test +++ b/mysql-test/suite/wsrep/t/variables_debug.test @@ -8,7 +8,7 @@ --let $galera_version=26.4.11 source include/check_galera_version.inc; -source include/galera_variables_ok.inc; +source include/galera_variables_ok_debug.inc; --replace_column 2 # SHOW GLOBAL STATUS LIKE 'wsrep%'; diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin.cnf b/mysql-test/suite/wsrep/t/wsrep_provider_plugin.cnf new file mode 100644 index 00000000..c61599ac --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin.cnf @@ -0,0 +1,8 @@ +!include ../my.cnf + +[mysqld.1] +wsrep-on=ON +wsrep-cluster-address=gcomm:// +wsrep-provider=@ENV.WSREP_PROVIDER +binlog-format=ROW +plugin-wsrep-provider=ON diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin.test b/mysql-test/suite/wsrep/t/wsrep_provider_plugin.test new file mode 100644 index 00000000..453e5bb0 --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin.test @@ -0,0 +1,41 @@ +# +# Verify that system variables can be modified via wsrep_provider +# plugin and wsrep_provider/wsrep_provider_options cannot be modified. +# + +--source include/have_wsrep.inc +--source include/have_innodb.inc + +--let $galera_version=26.4.14 +source include/check_galera_version.inc; + +CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB; + +SET GLOBAL wsrep_provider_repl_max_ws_size=1; +SHOW VARIABLES LIKE 'wsrep_provider_repl_max_ws_size'; + +--error ER_UNKNOWN_ERROR +INSERT INTO t1 VALUES (1); + +SET GLOBAL wsrep_provider_repl_max_ws_size=DEFAULT; +SHOW VARIABLES LIKE 'wsrep_provider_repl_max_ws_size'; + +INSERT INTO t1 VALUES (1); + +# Variable should be read only, must not take effect +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET GLOBAL wsrep_provider_options='repl.max_ws_size=1'; +INSERT INTO t1 VALUES (2); + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET GLOBAL wsrep_provider='none'; + +DROP TABLE t1; + +CALL mtr.add_suppression("transaction size limit"); +CALL mtr.add_suppression("rbr write fail"); + +# +# MDEV-30120 :Update the wsrep_provider_options read_only value in the system_variables table. +# +SELECT VARIABLE_NAME,READ_ONLY FROM information_schema.system_variables where VARIABLE_NAME like '%wsrep_provider_options%'; diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.cnf b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.cnf new file mode 100644 index 00000000..c61599ac --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.cnf @@ -0,0 +1,8 @@ +!include ../my.cnf + +[mysqld.1] +wsrep-on=ON +wsrep-cluster-address=gcomm:// +wsrep-provider=@ENV.WSREP_PROVIDER +binlog-format=ROW +plugin-wsrep-provider=ON diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.test b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.test new file mode 100644 index 00000000..02854653 --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.test @@ -0,0 +1,77 @@ +--source include/have_wsrep.inc +--source include/have_innodb.inc + +--let $galera_version=26.4.14 +source include/check_galera_version.inc; + +# +# Test string option +# + +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_socket_recv_buf_size'; +--error ER_WRONG_VALUE_FOR_VAR +set global wsrep_provider_socket_recv_buf_size = 'foo'; +set global wsrep_provider_socket_recv_buf_size = '1M'; +show global variables like 'wsrep_provider_socket_recv_buf_size'; +set global wsrep_provider_socket_recv_buf_size = default; +show global variables like 'wsrep_provider_socket_recv_buf_size'; + + +# +# Test integer option +# + +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_evs_send_window'; +--error ER_WRONG_VALUE_FOR_VAR +set global wsrep_provider_evs_send_window = -10; +set global wsrep_provider_evs_send_window = 10; +show global variables like 'wsrep_provider_evs_send_window'; +set global wsrep_provider_evs_send_window = default; +show global variables like 'wsrep_provider_evs_send_window'; + + +# +# Test double option +# + +select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_gcs_max_throttle'; +--error ER_WRONG_VALUE_FOR_VAR +set global wsrep_provider_gcs_max_throttle = 1.1; +set global wsrep_provider_gcs_max_throttle = 0.5; +show global variables like 'wsrep_provider_gcs_max_throttle'; +set global wsrep_provider_gcs_max_throttle = default; +show global variables like 'wsrep_provider_gcs_max_throttle'; + + +# +# Test bool option +# + +select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_cert_log_conflicts'; +set global wsrep_provider_cert_log_conflicts = on; +show global variables like 'wsrep_provider_cert_log_conflicts'; +set global wsrep_provider_cert_log_conflicts = off; +show global variables like 'wsrep_provider_cert_log_conflicts'; +set global wsrep_provider_cert_log_conflicts = default; +show global variables like 'wsrep_provider_cert_log_conflicts'; + + +# +# Test read-only option +# + +select read_only from information_schema.system_variables where variable_name = 'wsrep_provider_evs_auto_evict'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global wsrep_provider_evs_auto_evict = on; + + +# +# Test deprecated option (expect warning in result file) +# + +set global wsrep_provider_gcs_fc_master_slave = default; + + +call mtr.add_suppression("error setting param"); +call mtr.add_suppression("Unknown parameter"); +call mtr.add_suppression("Setting parameter"); diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.cnf b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.cnf new file mode 100644 index 00000000..c61599ac --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.cnf @@ -0,0 +1,8 @@ +!include ../my.cnf + +[mysqld.1] +wsrep-on=ON +wsrep-cluster-address=gcomm:// +wsrep-provider=@ENV.WSREP_PROVIDER +binlog-format=ROW +plugin-wsrep-provider=ON diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.test b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.test new file mode 100644 index 00000000..e65d5130 --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_defaults.test @@ -0,0 +1,34 @@ +--source include/have_wsrep.inc +--source include/have_innodb.inc + +--let $galera_version=26.4.16 +source include/check_galera_version.inc; + +SELECT COUNT(*) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_provider%' AND VARIABLE_NAME NOT IN ( + 'wsrep_provider', + 'wsrep_provider_options', + 'wsrep_provider_base_dir', + 'wsrep_provider_base_port', + 'wsrep_provider_gcache_dir', + 'wsrep_provider_dbug', + 'wsrep_provider_gcache_debug', + 'wsrep_provider_signal', + 'wsrep_provider_protonet_backend', + 'wsrep_provider_repl_proto_max', + 'wsrep_provider_gmcast_listen_addr'); + +--vertical_results +SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES +WHERE VARIABLE_NAME LIKE 'wsrep_provider_%' AND VARIABLE_NAME NOT IN ( + 'wsrep_provider', + 'wsrep_provider_options', + 'wsrep_provider_base_dir', + 'wsrep_provider_base_port', + 'wsrep_provider_gcache_dir', + 'wsrep_provider_dbug', + 'wsrep_provider_gcache_debug', + 'wsrep_provider_signal', + 'wsrep_provider_protonet_backend', + 'wsrep_provider_repl_proto_max', + 'wsrep_provider_gmcast_listen_addr') +ORDER BY VARIABLE_NAME; diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.cnf b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.cnf new file mode 100644 index 00000000..cd129a29 --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.cnf @@ -0,0 +1,12 @@ +# Use default setting for mysqld processes +!include include/default_my.cnf + +[mysqld] +wsrep-on=OFF + +[mysqld.1] +wsrep-on=OFF +#galera_port=@OPT.port +#ist_port=@OPT.port +#sst_port=@OPT.port +plugin-wsrep-provider=ON diff --git a/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.test b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.test new file mode 100644 index 00000000..b99b8769 --- /dev/null +++ b/mysql-test/suite/wsrep/t/wsrep_provider_plugin_wsrep_off.test @@ -0,0 +1,6 @@ +--source include/have_wsrep.inc +--source include/have_innodb.inc + +SELECT @@wsrep_on; + +select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider%'; diff --git a/mysql-test/suite/wsrep/t/wsrep_variables_wsrep_off.cnf b/mysql-test/suite/wsrep/t/wsrep_variables_wsrep_off.cnf index 2e66b1ef..23b1392e 100644 --- a/mysql-test/suite/wsrep/t/wsrep_variables_wsrep_off.cnf +++ b/mysql-test/suite/wsrep/t/wsrep_variables_wsrep_off.cnf @@ -1,5 +1,5 @@ # Use default setting for mysqld processes -!include include/default_mysqld.cnf +!include include/default_my.cnf [mysqld] wsrep-on=OFF |