mirror of
https://github.com/MariaDB/server.git
synced 2025-04-18 05:05:32 +02:00
eb30a9d633
Replication of MyISAM and Aria DML is experimental and best effort only. Earlier change make INSERT SELECT on both MyISAM and Aria to replicate using TOI and STATEMENT replication. Replication should happen only if user has set needed wsrep_mode setting. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
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_replicate_myisam=ON;
|
|
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_replicate_myisam=default;
|