mirror of
https://github.com/MariaDB/server.git
synced 2026-03-08 01:18:41 +01:00
41 lines
1.3 KiB
Text
41 lines
1.3 KiB
Text
--source include/galera_cluster.inc
|
|
|
|
# Save original auto_increment_offset values.
|
|
--let $node_1=node_1
|
|
--let $node_2=node_2
|
|
--source ../galera/include/auto_increment_offset_save.inc
|
|
|
|
SET SESSION wsrep_sync_wait=0;
|
|
--connection node_2
|
|
SET SESSION wsrep_sync_wait=0;
|
|
select @@wsrep_slave_threads;
|
|
SET @cluster_address_orig = @@wsrep_cluster_address;
|
|
SET GLOBAL wsrep_cluster_address=AUTO;
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_slave_threads=12;
|
|
SHOW WARNINGS;
|
|
SET GLOBAL wsrep_cluster_address=ON;
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_slave_threads=0;
|
|
SHOW WARNINGS;
|
|
SET GLOBAL wsrep_cluster_address='a';
|
|
--error ER_WRONG_VALUE_FOR_VAR
|
|
SET GLOBAL wsrep_slave_threads=2;
|
|
SHOW WARNINGS;
|
|
--disable_query_log
|
|
SET GLOBAL wsrep_cluster_address = @cluster_address_orig;
|
|
--enable_query_log
|
|
|
|
# wait (without using SELECT) for the cluster becoming ready for all SQL statements
|
|
let $show_statement= SHOW STATUS LIKE 'wsrep_ready';
|
|
let $field= Value;
|
|
let $condition= = 'ON';
|
|
--source include/wait_show_condition.inc
|
|
|
|
select @@wsrep_slave_threads;
|
|
show status like 'wsrep_cluster_size';
|
|
show status like 'wsrep_cluster_status';
|
|
call mtr.add_suppression("WSREP:.*");
|
|
|
|
# Restore original auto_increment_offset values.
|
|
--source ../galera/include/auto_increment_offset_restore.inc
|