mirror of
https://github.com/MariaDB/server.git
synced 2025-04-05 14:55:32 +02:00
e2dbd9b6ac
When the IO thread (re)connect to a primary, no updates are available besides unique errors that cause the failure. These new `Master_info` numbers supplement SHOW SLAVE STATUS’s (most- recent) ‘Connecting’ state with statistics on (re)connect attempts: * `Connects_Tried`: how many retries have been attempted so far This was previously a local variable that only counted re-attempts; it’s now meaningful even after the “Connecting” state concludes. * `Master_Retry_Count` (from MDEV-25674): out of how many configured Side-note: Some of the tests updated by this commit dump the entire SHOW SLAVE STATUS, which might include non-deterministic entries. Reviewed-by: Kristian Nielsen <knielsen@knielsen-hq.org> Reviewed-by: Brandon Nesterenko <brandon.nesterenko@mariadb.com>
88 lines
3.2 KiB
Text
88 lines
3.2 KiB
Text
# Use `--master-retry-count` when not specified
|
|
CHANGE MASTER 'named' TO master_host='example.com';
|
|
CHANGE MASTER TO master_host='127.0.0.1', master_ssl_verify_server_cert=0;
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
1
|
|
named 1
|
|
# Replace when specified
|
|
CHANGE MASTER 'named' TO master_retry_count=11;
|
|
CHANGE MASTER TO master_retry_count=10;
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# Conventional views also show the configuations
|
|
Connection_name = ''
|
|
Connection_name = 'named'
|
|
Master_Retry_Count = '10'
|
|
Master_Retry_Count = '11'
|
|
Master_Retry_Count = '10'
|
|
Master_Retry_Count = '11'
|
|
SELECT CHANNEL_NAME, CONNECTION_RETRY_COUNT
|
|
FROM performance_schema.replication_connection_configuration;
|
|
CHANNEL_NAME CONNECTION_RETRY_COUNT
|
|
named 11
|
|
10
|
|
# Restore specified config on restart
|
|
# restart: --skip-slave-start
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# Keep specified config on RESET REPLICA
|
|
RESET REPLICA 'named';
|
|
RESET REPLICA;
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# Don't replace when not specified
|
|
CHANGE MASTER TO master_user='root';
|
|
CHANGE MASTER 'named' TO master_user='root';
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# 0 internally means "not specified"
|
|
CHANGE MASTER TO master_retry_count=0;
|
|
CHANGE MASTER 'named' TO master_retry_count=0;
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# Truncates decimals
|
|
CHANGE MASTER TO master_retry_count=0.5;
|
|
CHANGE MASTER 'named' TO master_retry_count=0.5;
|
|
SELECT Connection_name, Master_Retry_Count
|
|
FROM information_schema.SLAVE_STATUS;
|
|
Connection_name Master_Retry_Count
|
|
10
|
|
named 11
|
|
# Caps values (such as UINT64_MAX + 1) to `--master-retry-count`'s max
|
|
CHANGE MASTER TO master_retry_count=18446744073709551616;
|
|
CHANGE MASTER 'named' TO master_retry_count=18446744073709551616;
|
|
SELECT Connection_name
|
|
FROM information_schema.SLAVE_STATUS
|
|
WHERE Master_Retry_Count IN (4294967295, 18446744073709551615);
|
|
Connection_name
|
|
|
|
named
|
|
# Negative
|
|
CHANGE MASTER TO master_retry_count=-1;
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1
|
|
CHANGE MASTER 'named' TO master_retry_count=-1;
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1
|
|
# NaN
|
|
CHANGE MASTER TO master_retry_count='5';
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''5'' at line 1
|
|
CHANGE MASTER 'named' TO master_retry_count='5';
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''5'' at line 1
|
|
# Cleanup
|
|
RESET REPLICA 'named' ALL;
|