mirror of
https://github.com/MariaDB/server.git
synced 2025-09-14 13:22:17 +02:00
b39ea86305
A new Galera feature that allows retrying of applying of writesets at slave nodes (codership/mysql-wsrep-bugs/#1619). Currently replication applying stops for first non ignored failure occurring in event applying, and node will do emergency abort (or start inconsistency voting). Some failures, however, can be concurrency related, and applying may succeed if the operation is tried at later time. This feature introduces a new dynamic global option variable "wsrep_applier_retry_count" that controls the retry-applying feature: a zero value disables retrying and a positive value sets the maximum number of retry attempts. The default value for this option is zero, which means that this feature is disabled by default. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
63 lines
1.6 KiB
Text
63 lines
1.6 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
# Correct Galera library found
|
|
SELECT COUNT(*) `expect 49` FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_%';
|
|
expect 49
|
|
49
|
|
SELECT VARIABLE_NAME, VARIABLE_VALUE
|
|
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
|
|
WHERE VARIABLE_NAME LIKE 'wsrep_%'
|
|
AND VARIABLE_NAME NOT IN (
|
|
'WSREP_PROVIDER_OPTIONS',
|
|
'WSREP_SST_RECEIVE_ADDRESS',
|
|
'WSREP_NODE_ADDRESS',
|
|
'WSREP_NODE_NAME',
|
|
'WSREP_PROVIDER',
|
|
'WSREP_DATA_HOME_DIR',
|
|
'WSREP_NODE_INCOMING_ADDRESS',
|
|
'WSREP_START_POSITION',
|
|
'WSREP_PATCH_VERSION'
|
|
)
|
|
ORDER BY VARIABLE_NAME;
|
|
VARIABLE_NAME VARIABLE_VALUE
|
|
WSREP_ALLOWLIST
|
|
WSREP_APPLIER_RETRY_COUNT 0
|
|
WSREP_AUTO_INCREMENT_CONTROL ON
|
|
WSREP_CERTIFICATION_RULES strict
|
|
WSREP_CERTIFY_NONPK ON
|
|
WSREP_CLUSTER_ADDRESS gcomm://
|
|
WSREP_CLUSTER_NAME my_wsrep_cluster
|
|
WSREP_CONVERT_LOCK_TO_TRX OFF
|
|
WSREP_DBUG_OPTION
|
|
WSREP_DEBUG NONE
|
|
WSREP_DESYNC OFF
|
|
WSREP_DIRTY_READS OFF
|
|
WSREP_DRUPAL_282555_WORKAROUND OFF
|
|
WSREP_FORCED_BINLOG_FORMAT NONE
|
|
WSREP_GTID_DOMAIN_ID 0
|
|
WSREP_GTID_MODE OFF
|
|
WSREP_IGNORE_APPLY_ERRORS 7
|
|
WSREP_LOG_CONFLICTS OFF
|
|
WSREP_MAX_WS_ROWS 0
|
|
WSREP_MAX_WS_SIZE 2147483647
|
|
WSREP_MODE
|
|
WSREP_MYSQL_REPLICATION_BUNDLE 0
|
|
WSREP_NOTIFY_CMD
|
|
WSREP_ON ON
|
|
WSREP_OSU_METHOD TOI
|
|
WSREP_RECOVER OFF
|
|
WSREP_REJECT_QUERIES NONE
|
|
WSREP_RESTART_SLAVE OFF
|
|
WSREP_RETRY_AUTOCOMMIT 1
|
|
WSREP_SLAVE_FK_CHECKS ON
|
|
WSREP_SLAVE_THREADS 1
|
|
WSREP_SLAVE_UK_CHECKS OFF
|
|
WSREP_SR_STORE table
|
|
WSREP_SST_AUTH ********
|
|
WSREP_SST_DONOR
|
|
WSREP_SST_DONOR_REJECTS_QUERIES OFF
|
|
WSREP_SST_METHOD rsync
|
|
WSREP_STATUS_FILE
|
|
WSREP_SYNC_WAIT 15
|
|
WSREP_TRX_FRAGMENT_SIZE 0
|
|
WSREP_TRX_FRAGMENT_UNIT bytes
|