mirror of
https://github.com/MariaDB/server.git
synced 2025-04-09 08:45:33 +02:00
84 lines
2.9 KiB
Text
84 lines
2.9 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
connection node_2;
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
DROP TABLE t;
|
|
connection node_1;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
SET GLOBAL wsrep_forced_binlog_format=ROW;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
connection node_2;
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
DROP TABLE t;
|
|
connection node_1;
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
connection node_2;
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
DROP TABLE t;
|
|
connection node_1;
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
SET GLOBAL wsrep_forced_binlog_format=ROW;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
connection node_2;
|
|
SELECT * FROM t;
|
|
f0
|
|
NULL
|
|
DROP TABLE t;
|
|
connection node_1;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
ERROR HY000: wsrep_forced_binlog_format=[MIXED|STATEMENT] can't be set if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA]
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_mode = REPLICATE_ARIA;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_mode = REPLICATE_ARIA;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
ERROR HY000: wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|