connection node_2;
connection node_1;
connection node_1;
connection node_2;
Performing State Transfer on a server that starts from a clean var directory
This is accomplished by shutting down node #2 and removing its var directory before restarting it
connection node_1;
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
CREATE TABLE t2 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1;
CREATE TABLE t3 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=NO;
CREATE TABLE t4 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=YES;
CREATE TABLE t5 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
CREATE TABLE t6 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=NO;
CREATE TABLE t7 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES;
CREATE TABLE t8 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=NO;
CREATE TABLE t9 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=YES;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
insert into t9 values ('node1_committed_before');
insert into t9 values ('node1_committed_before');
insert into t9 values ('node1_committed_before');
insert into t9 values ('node1_committed_before');
insert into t9 values ('node1_committed_before');
insert into t8 values ('node1_committed_before');
insert into t8 values ('node1_committed_before');
insert into t8 values ('node1_committed_before');
insert into t8 values ('node1_committed_before');
insert into t8 values ('node1_committed_before');
insert into t7 values ('node1_committed_before');
insert into t7 values ('node1_committed_before');
insert into t7 values ('node1_committed_before');
insert into t7 values ('node1_committed_before');
insert into t7 values ('node1_committed_before');
insert into t6 values ('node1_committed_before');
insert into t6 values ('node1_committed_before');
insert into t6 values ('node1_committed_before');
insert into t6 values ('node1_committed_before');
insert into t6 values ('node1_committed_before');
insert into t5 values ('node1_committed_before');
insert into t5 values ('node1_committed_before');
insert into t5 values ('node1_committed_before');
insert into t5 values ('node1_committed_before');
insert into t5 values ('node1_committed_before');
insert into t4 values ('node1_committed_before');
insert into t4 values ('node1_committed_before');
insert into t4 values ('node1_committed_before');
insert into t4 values ('node1_committed_before');
insert into t4 values ('node1_committed_before');
insert into t3 values ('node1_committed_before');
insert into t3 values ('node1_committed_before');
insert into t3 values ('node1_committed_before');
insert into t3 values ('node1_committed_before');
insert into t3 values ('node1_committed_before');
insert into t2 values ('node1_committed_before');
insert into t2 values ('node1_committed_before');
insert into t2 values ('node1_committed_before');
insert into t2 values ('node1_committed_before');
insert into t2 values ('node1_committed_before');
insert into t1 values ('node1_committed_before');
insert into t1 values ('node1_committed_before');
insert into t1 values ('node1_committed_before');
insert into t1 values ('node1_committed_before');
insert into t1 values ('node1_committed_before');
COMMIT;
connection node_2;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
insert into t9 values ('node2_committed_before');
insert into t9 values ('node2_committed_before');
insert into t9 values ('node2_committed_before');
insert into t9 values ('node2_committed_before');
insert into t9 values ('node2_committed_before');
insert into t8 values ('node2_committed_before');
insert into t8 values ('node2_committed_before');
insert into t8 values ('node2_committed_before');
insert into t8 values ('node2_committed_before');
insert into t8 values ('node2_committed_before');
insert into t7 values ('node2_committed_before');
insert into t7 values ('node2_committed_before');
insert into t7 values ('node2_committed_before');
insert into t7 values ('node2_committed_before');
insert into t7 values ('node2_committed_before');
insert into t6 values ('node2_committed_before');
insert into t6 values ('node2_committed_before');
insert into t6 values ('node2_committed_before');
insert into t6 values ('node2_committed_before');
insert into t6 values ('node2_committed_before');
insert into t5 values ('node2_committed_before');
insert into t5 values ('node2_committed_before');
insert into t5 values ('node2_committed_before');
insert into t5 values ('node2_committed_before');
insert into t5 values ('node2_committed_before');
insert into t4 values ('node2_committed_before');
insert into t4 values ('node2_committed_before');
insert into t4 values ('node2_committed_before');
insert into t4 values ('node2_committed_before');
insert into t4 values ('node2_committed_before');
insert into t3 values ('node2_committed_before');
insert into t3 values ('node2_committed_before');
insert into t3 values ('node2_committed_before');
insert into t3 values ('node2_committed_before');
insert into t3 values ('node2_committed_before');
insert into t2 values ('node2_committed_before');
insert into t2 values ('node2_committed_before');
insert into t2 values ('node2_committed_before');
insert into t2 values ('node2_committed_before');
insert into t2 values ('node2_committed_before');
insert into t1 values ('node2_committed_before');
insert into t1 values ('node2_committed_before');
insert into t1 values ('node2_committed_before');
insert into t1 values ('node2_committed_before');
insert into t1 values ('node2_committed_before');
COMMIT;
Shutting down server ...
connection node_1;
Cleaning var directory ...
SET AUTOCOMMIT=OFF;
START TRANSACTION;
insert into t9 values ('node1_committed_during');
insert into t9 values ('node1_committed_during');
insert into t9 values ('node1_committed_during');
insert into t9 values ('node1_committed_during');
insert into t9 values ('node1_committed_during');
insert into t8 values ('node1_committed_during');
insert into t8 values ('node1_committed_during');
insert into t8 values ('node1_committed_during');
insert into t8 values ('node1_committed_during');
insert into t8 values ('node1_committed_during');
insert into t7 values ('node1_committed_during');
insert into t7 values ('node1_committed_during');
insert into t7 values ('node1_committed_during');
insert into t7 values ('node1_committed_during');
insert into t7 values ('node1_committed_during');
insert into t6 values ('node1_committed_during');
insert into t6 values ('node1_committed_during');
insert into t6 values ('node1_committed_during');
insert into t6 values ('node1_committed_during');
insert into t6 values ('node1_committed_during');
insert into t5 values ('node1_committed_during');
insert into t5 values ('node1_committed_during');
insert into t5 values ('node1_committed_during');
insert into t5 values ('node1_committed_during');
insert into t5 values ('node1_committed_during');
insert into t4 values ('node1_committed_during');
insert into t4 values ('node1_committed_during');
insert into t4 values ('node1_committed_during');
insert into t4 values ('node1_committed_during');
insert into t4 values ('node1_committed_during');
insert into t3 values ('node1_committed_during');
insert into t3 values ('node1_committed_during');
insert into t3 values ('node1_committed_during');
insert into t3 values ('node1_committed_during');
insert into t3 values ('node1_committed_during');
insert into t2 values ('node1_committed_during');
insert into t2 values ('node1_committed_during');
insert into t2 values ('node1_committed_during');
insert into t2 values ('node1_committed_during');
insert into t2 values ('node1_committed_during');
insert into t1 values ('node1_committed_during');
insert into t1 values ('node1_committed_during');
insert into t1 values ('node1_committed_during');
insert into t1 values ('node1_committed_during');
insert into t1 values ('node1_committed_during');
COMMIT;
START TRANSACTION;
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
connect node_1a_galera_st_clean_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
insert into t9 values ('node1_to_be_rollbacked_after');
insert into t9 values ('node1_to_be_rollbacked_after');
insert into t9 values ('node1_to_be_rollbacked_after');
insert into t9 values ('node1_to_be_rollbacked_after');
insert into t9 values ('node1_to_be_rollbacked_after');
insert into t8 values ('node1_to_be_rollbacked_after');
insert into t8 values ('node1_to_be_rollbacked_after');
insert into t8 values ('node1_to_be_rollbacked_after');
insert into t8 values ('node1_to_be_rollbacked_after');
insert into t8 values ('node1_to_be_rollbacked_after');
insert into t7 values ('node1_to_be_rollbacked_after');
insert into t7 values ('node1_to_be_rollbacked_after');
insert into t7 values ('node1_to_be_rollbacked_after');
insert into t7 values ('node1_to_be_rollbacked_after');
insert into t7 values ('node1_to_be_rollbacked_after');
insert into t6 values ('node1_to_be_rollbacked_after');
insert into t6 values ('node1_to_be_rollbacked_after');
insert into t6 values ('node1_to_be_rollbacked_after');
insert into t6 values ('node1_to_be_rollbacked_after');
insert into t6 values ('node1_to_be_rollbacked_after');
insert into t5 values ('node1_to_be_rollbacked_after');
insert into t5 values ('node1_to_be_rollbacked_after');
insert into t5 values ('node1_to_be_rollbacked_after');
insert into t5 values ('node1_to_be_rollbacked_after');
insert into t5 values ('node1_to_be_rollbacked_after');
insert into t4 values ('node1_to_be_rollbacked_after');
insert into t4 values ('node1_to_be_rollbacked_after');
insert into t4 values ('node1_to_be_rollbacked_after');
insert into t4 values ('node1_to_be_rollbacked_after');
insert into t4 values ('node1_to_be_rollbacked_after');
insert into t3 values ('node1_to_be_rollbacked_after');
insert into t3 values ('node1_to_be_rollbacked_after');
insert into t3 values ('node1_to_be_rollbacked_after');
insert into t3 values ('node1_to_be_rollbacked_after');
insert into t3 values ('node1_to_be_rollbacked_after');
insert into t2 values ('node1_to_be_rollbacked_after');
insert into t2 values ('node1_to_be_rollbacked_after');
insert into t2 values ('node1_to_be_rollbacked_after');
insert into t2 values ('node1_to_be_rollbacked_after');
insert into t2 values ('node1_to_be_rollbacked_after');
insert into t1 values ('node1_to_be_rollbacked_after');
insert into t1 values ('node1_to_be_rollbacked_after');
insert into t1 values ('node1_to_be_rollbacked_after');
insert into t1 values ('node1_to_be_rollbacked_after');
insert into t1 values ('node1_to_be_rollbacked_after');
connection node_2;
Starting server ...
SET AUTOCOMMIT=OFF;
START TRANSACTION;
COMMIT;
connection node_1;
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t9 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t8 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t7 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t6 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t5 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t4 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t3 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t2 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
insert into t1 values ('node1_to_be_committed_after');
COMMIT;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
insert into t9 values ('node1_committed_after');
insert into t9 values ('node1_committed_after');
insert into t9 values ('node1_committed_after');
insert into t9 values ('node1_committed_after');
insert into t9 values ('node1_committed_after');
insert into t8 values ('node1_committed_after');
insert into t8 values ('node1_committed_after');
insert into t8 values ('node1_committed_after');
insert into t8 values ('node1_committed_after');
insert into t8 values ('node1_committed_after');
insert into t7 values ('node1_committed_after');
insert into t7 values ('node1_committed_after');
insert into t7 values ('node1_committed_after');
insert into t7 values ('node1_committed_after');
insert into t7 values ('node1_committed_after');
insert into t6 values ('node1_committed_after');
insert into t6 values ('node1_committed_after');
insert into t6 values ('node1_committed_after');
insert into t6 values ('node1_committed_after');
insert into t6 values ('node1_committed_after');
insert into t5 values ('node1_committed_after');
insert into t5 values ('node1_committed_after');
insert into t5 values ('node1_committed_after');
insert into t5 values ('node1_committed_after');
insert into t5 values ('node1_committed_after');
insert into t4 values ('node1_committed_after');
insert into t4 values ('node1_committed_after');
insert into t4 values ('node1_committed_after');
insert into t4 values ('node1_committed_after');
insert into t4 values ('node1_committed_after');
insert into t3 values ('node1_committed_after');
insert into t3 values ('node1_committed_after');
insert into t3 values ('node1_committed_after');
insert into t3 values ('node1_committed_after');
insert into t3 values ('node1_committed_after');
insert into t2 values ('node1_committed_after');
insert into t2 values ('node1_committed_after');
insert into t2 values ('node1_committed_after');
insert into t2 values ('node1_committed_after');
insert into t2 values ('node1_committed_after');
insert into t1 values ('node1_committed_after');
insert into t1 values ('node1_committed_after');
insert into t1 values ('node1_committed_after');
insert into t1 values ('node1_committed_after');
insert into t1 values ('node1_committed_after');
COMMIT;
connection node_1a_galera_st_clean_slave;
ROLLBACK;
SELECT COUNT(*) FROM t1;
COUNT(*)
30
SELECT COUNT(*) FROM t2;
COUNT(*)
30
SELECT COUNT(*) FROM t3;
COUNT(*)
30
SELECT COUNT(*) FROM t4;
COUNT(*)
30
SELECT COUNT(*) FROM t5;
COUNT(*)
30
SELECT COUNT(*) FROM t6;
COUNT(*)
30
SELECT COUNT(*) FROM t7;
COUNT(*)
30
SELECT COUNT(*) FROM t8;
COUNT(*)
30
SELECT COUNT(*) FROM t9;
COUNT(*)
30
SELECT * FROM t1;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t2;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t3;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t4;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t5;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t6;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t7;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t8;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t9;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
COMMIT;
SET AUTOCOMMIT=ON;
connection node_1;
SELECT COUNT(*) FROM t1;
COUNT(*)
30
SELECT COUNT(*) FROM t2;
COUNT(*)
30
SELECT COUNT(*) FROM t3;
COUNT(*)
30
SELECT COUNT(*) FROM t4;
COUNT(*)
30
SELECT COUNT(*) FROM t5;
COUNT(*)
30
SELECT COUNT(*) FROM t6;
COUNT(*)
30
SELECT COUNT(*) FROM t7;
COUNT(*)
30
SELECT COUNT(*) FROM t8;
COUNT(*)
30
SELECT COUNT(*) FROM t9;
COUNT(*)
30
SELECT * FROM t1;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t2;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t3;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t4;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t5;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t6;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t7;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t8;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
SELECT * FROM t9;
f1
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node1_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node2_committed_before
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_committed_during
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_to_be_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
node1_committed_after
COMMIT;
DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8,t9;
COMMIT;
SET AUTOCOMMIT=ON;
disconnect node_2;
disconnect node_1;