mirror of
https://github.com/MariaDB/server.git
synced 2025-04-27 17:39:57 +02:00

Tweak `multi_source.master_info_file` re. MDEV-31857’s new default `Master_SSL_Verify_Server_Cert=0` was optional before that secure-by-default change. Now, passwordless connections must disable SSL certificate verification. Because the default unnamed connection cannot be deleted by RESET REPLICA ALL, it must be explicitly left passwordless and having `Master_SSL_Verify_Server_Cert=0`. The named connection is cleaned up by RESET REPLICA ALL and thus not affected.
18 lines
740 B
Text
18 lines
740 B
Text
CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_port=SERVER_MYPORT_1, master_ssl_verify_server_cert=0;
|
|
CHANGE MASTER 'named' TO master_host='localhost', master_user='test', master_port=SERVER_MYPORT_2;
|
|
--list_files @@datadir *.info
|
|
relay-log-named.info
|
|
relay-log.info
|
|
--list_files MYSQL_TMP_DIR *.txt
|
|
master_info_file-named.txt
|
|
master_info_file.txt
|
|
multi-master_info_file.txt
|
|
--cat_file MYSQL_TMP_DIR/multi-master_info_file.txt
|
|
named
|
|
FOUND 1 matches in master_info_file.txt
|
|
FOUND 1 matches in master_info_file.txt
|
|
FOUND 1 matches in master_info_file.txt
|
|
FOUND 1 matches in master_info_file-named.txt
|
|
FOUND 1 matches in master_info_file-named.txt
|
|
FOUND 1 matches in master_info_file-named.txt
|
|
RESET REPLICA 'named' ALL;
|