| 1 |
connection node_2; |
| 2 |
connection node_1; |
| 3 |
# Correct Galera library found |
| 4 |
SELECT COUNT(*) `expect 49` FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_%'; |
| 5 |
expect 49 |
| 6 |
49 |
| 7 |
SELECT VARIABLE_NAME, VARIABLE_VALUE |
| 8 |
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES |
| 9 |
WHERE VARIABLE_NAME LIKE 'wsrep_%' |
| 10 |
AND VARIABLE_NAME NOT IN ( |
| 11 |
'WSREP_PROVIDER_OPTIONS', |
| 12 |
'WSREP_SST_RECEIVE_ADDRESS', |
| 13 |
'WSREP_NODE_ADDRESS', |
| 14 |
'WSREP_NODE_NAME', |
| 15 |
'WSREP_PROVIDER', |
| 16 |
'WSREP_DATA_HOME_DIR', |
| 17 |
'WSREP_NODE_INCOMING_ADDRESS', |
| 18 |
'WSREP_START_POSITION', |
| 19 |
'WSREP_PATCH_VERSION' |
| 20 |
) |
| 21 |
ORDER BY VARIABLE_NAME; |
| 22 |
VARIABLE_NAME VARIABLE_VALUE |
| 23 |
WSREP_ALLOWLIST |
| 24 |
WSREP_AUTO_INCREMENT_CONTROL ON |
| 25 |
WSREP_CERTIFICATION_RULES strict |
| 26 |
WSREP_CERTIFY_NONPK ON |
| 27 |
WSREP_CLUSTER_ADDRESS gcomm:// |
| 28 |
WSREP_CLUSTER_NAME my_wsrep_cluster |
| 29 |
WSREP_CONVERT_LOCK_TO_TRX OFF |
| 30 |
WSREP_DBUG_OPTION |
| 31 |
WSREP_DEBUG NONE |
| 32 |
WSREP_DESYNC OFF |
| 33 |
WSREP_DIRTY_READS OFF |
| 34 |
WSREP_DRUPAL_282555_WORKAROUND OFF |
| 35 |
WSREP_FORCED_BINLOG_FORMAT NONE |
| 36 |
WSREP_GTID_DOMAIN_ID 0 |
| 37 |
WSREP_GTID_MODE OFF |
| 38 |
WSREP_IGNORE_APPLY_ERRORS 7 |
| 39 |
WSREP_LOG_CONFLICTS OFF |
| 40 |
WSREP_MAX_WS_ROWS 0 |
| 41 |
WSREP_MAX_WS_SIZE 2147483647 |
| 42 |
WSREP_MODE |
| 43 |
WSREP_MYSQL_REPLICATION_BUNDLE 0 |
| 44 |
WSREP_NOTIFY_CMD |
| 45 |
WSREP_ON ON |
| 46 |
WSREP_OSU_METHOD TOI |
| 47 |
WSREP_RECOVER OFF |
| 48 |
WSREP_REJECT_QUERIES NONE |
| 49 |
WSREP_RESTART_SLAVE OFF |
| 50 |
WSREP_RETRY_AUTOCOMMIT 1 |
| 51 |
WSREP_SLAVE_FK_CHECKS ON |
| 52 |
WSREP_SLAVE_THREADS 1 |
| 53 |
WSREP_SLAVE_UK_CHECKS OFF |
| 54 |
WSREP_SR_STORE table |
| 55 |
WSREP_SST_AUTH ******** |
| 56 |
WSREP_SST_DONOR |
| 57 |
WSREP_SST_DONOR_REJECTS_QUERIES OFF |
| 58 |
WSREP_SST_METHOD rsync |
| 59 |
WSREP_STATUS_FILE |
| 60 |
WSREP_SYNC_WAIT 15 |
| 61 |
WSREP_TRX_FRAGMENT_SIZE 0 |
| 62 |
WSREP_TRX_FRAGMENT_UNIT bytes |