mirror of
https://github.com/MariaDB/server.git
synced 2025-06-17 18:24:41 +02:00
100 lines
1.6 KiB
Text
100 lines
1.6 KiB
Text
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;
|