connection node_2; connection node_1; create table t1(id serial, val varchar(100)) engine=myisam; insert into t1 values(null, 'a'); insert into t1 values(null, 'b'); insert into t1 select null, 'c'; insert into t1 select null, 'd' from t1; select * from t1; id val 1 a 3 b 5 c 7 d 9 d 11 d create table t2(id serial, val varchar(100)) engine=aria; insert into t2 values(null, 'a'); insert into t2 values(null, 'b'); insert into t2 select null, 'c'; insert into t2 select null, 'd' from t2; select * from t2; id val 1 a 3 b 5 c 7 d 9 d 11 d create table t3(id serial, val varchar(100)) engine=innodb; insert into t3 values(null, 'a'); insert into t3 values(null, 'b'); insert into t3 select null, 'c'; insert into t3 select null, 'd' from t3; select * from t3; id val 1 a 3 b 5 c 7 d 9 d 11 d set global wsrep_mode='REPLICATE_MYISAM,REPLICATE_ARIA'; create table t4(id serial, val varchar(100)) engine=myisam; insert into t4 values(null, 'a'); insert into t4 values(null, 'b'); insert into t4 select null, 'c'; insert into t4 select null, 'd' from t4; select * from t4; id val 1 a 2 b 3 c 4 d 5 d 6 d create table t5(id serial, val varchar(100)) engine=myisam; insert into t5 values(null, 'a'); insert into t5 values(null, 'b'); insert into t5 select null, 'c'; insert into t5 select null, 'd' from t5; select * from t2; id val 1 a 3 b 5 c 7 d 9 d 11 d connection node_2; select * from t1; id val select * from t2; id val select * from t3; id val 1 a 3 b 5 c 7 d 9 d 11 d select * from t4; id val 1 a 2 b 3 c 4 d 5 d 6 d select * from t5; id val 1 a 2 b 3 c 4 d 5 d 6 d connection node_1; drop table t1,t2,t3,t4,t5; set global wsrep_mode=default;