--source include/galera_cluster.inc --source include/have_innodb.inc --source include/have_aria.inc 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; 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; 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; 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; 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; --connection node_2 select * from t1; select * from t2; select * from t3; select * from t4; select * from t5; --connection node_1 drop table t1,t2,t3,t4,t5; set global wsrep_mode=default;