mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
a50a5e0f3b
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. Note: This commit contains additional changes compared to those already made for the 10.5 branch. + small refactoring after main fix. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
52 lines
1.4 KiB
Text
52 lines
1.4 KiB
Text
--source include/galera_cluster.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;
|
|
set global wsrep_mode=default;
|
|
|
|
--connection node_1
|
|
drop table t1,t2,t3,t4,t5;
|
|
set global wsrep_mode=default;
|