mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
7e748d075b
* Fixes galera.galera_bf_kill_debug test case. * Enable galera_ssl_upgrade, galera_ssl_reload, galera_pc_bootstrap * Add MDEV to disabled tests that miss it Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
79 lines
3.9 KiB
Text
79 lines
3.9 KiB
Text
#
|
|
# Test upgrading the SSL certificates in a rolling fashion.
|
|
#
|
|
# 1. The starting state with the old key and cert is is described in galera_ssl_upgrade.cnf
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_ssl_communication.inc
|
|
--source include/have_openssl.inc
|
|
--source include/force_restart.inc
|
|
|
|
# Save original auto_increment_offset values.
|
|
--let $node_1=node_1
|
|
--let $node_2=node_2
|
|
--source include/auto_increment_offset_save.inc
|
|
|
|
# Setup galera ports
|
|
--connection node_1
|
|
--source suite/galera/include/galera_base_port.inc
|
|
--let $NODE_GALERAPORT_1 = $_NODE_GALERAPORT
|
|
|
|
--connection node_2
|
|
--source suite/galera/include/galera_base_port.inc
|
|
--let $NODE_GALERAPORT_2 = $_NODE_GALERAPORT
|
|
|
|
SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
|
|
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
|
|
|
|
# 2. Restart node #1 with a socket.ssl_ca that includes both the new and the old certificate
|
|
|
|
--connection node_1
|
|
--source include/shutdown_mysqld.inc
|
|
--let $restart_noprint = 1
|
|
--let $start_mysqld_params = --wsrep-cluster-address=gcomm://127.0.0.1:$NODE_GALERAPORT_2 --wsrep_provider_options=base_port=$NODE_GALERAPORT_1;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/galera-upgrade-ca-cert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/galera-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/galera-key.pem
|
|
--source include/start_mysqld.inc
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
|
|
--source include/wait_condition.inc
|
|
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
|
|
|
|
# 3. Restart node #2 with the new socket.ssl_ca , socket.ssl_cert and socket.ssl_key
|
|
|
|
--connection node_2
|
|
--source include/shutdown_mysqld.inc
|
|
--let $start_mysqld_params = --wsrep_provider_options=base_port=$NODE_GALERAPORT_2;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/galera-upgrade-ca-cert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/galera-upgrade-server-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/galera-upgrade-server-key.pem
|
|
--source include/start_mysqld.inc
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
|
|
--source include/wait_condition.inc
|
|
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
|
|
|
|
# 4. Restart node #1 with the new socket.ssl_ca , socket.ssl_cert and socket.ssl_key
|
|
|
|
--connection node_1
|
|
--source include/shutdown_mysqld.inc
|
|
--let $start_mysqld_params = --wsrep-cluster-address=gcomm://127.0.0.1:$NODE_GALERAPORT_2 --wsrep_provider_options=base_port=$NODE_GALERAPORT_1;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/galera-upgrade-ca-cert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/galera-upgrade-server-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/galera-upgrade-server-key.pem
|
|
--source include/start_mysqld.inc
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
|
|
--source include/wait_condition.inc
|
|
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
|
|
|
|
# 5. Make sure node_2 is ready as well
|
|
--connection node_2
|
|
--source include/galera_wait_ready.inc
|
|
|
|
# Upgrade complete. Both nodes now use the new key and certificate
|
|
|
|
# Restore original auto_increment_offset values.
|
|
--source include/auto_increment_offset_restore.inc
|
|
|
|
--connection node_1
|
|
call mtr.add_suppression("WSREP: write_handler\\(\\)");
|
|
--connection node_2
|
|
call mtr.add_suppression("WSREP: write_handler\\(\\)");
|