--source include/galera_cluster.inc --source include/have_innodb.inc --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3 # Save original auto_increment_offset values. --let $node_1=node_1 --let $node_2=node_2 --LET $node_3=node_3 --source ../galera/include/auto_increment_offset_save.inc --connection node_1 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; --connection node_2 --source include/shutdown_mysqld.inc --connection node_1 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size' --source include/wait_condition.inc --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1 --connection node_1b SET SESSION wsrep_trx_fragment_size = 1; SET AUTOCOMMIT=OFF; START TRANSACTION; INSERT INTO t1 VALUES (1); INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (3); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); --connection node_2 --source include/start_mysqld.inc --source include/wait_until_connected_again.inc --source include/galera_wait_ready.inc SELECT COUNT(*) FROM mysql.wsrep_streaming_log; --connection node_1 SELECT COUNT(*) FROM mysql.wsrep_streaming_log; COMMIT; SELECT COUNT(*) FROM t1; --connection node_2 SELECT COUNT(*) FROM t1; DROP TABLE t1; --disconnect node_1b --source ../galera/include/auto_increment_offset_restore.inc