mirror of
https://github.com/MariaDB/server.git
synced 2025-08-04 09:31:36 +02:00
0784dd32b1
If wsrep_mode=BINLOG_ROW_FORMAT_ONLY wsrep_forced_binlog_format can be DEFAULT (UNSPECIFIED) or ROW. Finally, if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] or wsrep_replicate_myisam=ON we allow wsrep_forced_binlog_format to be [DEFAULT|ROW]. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
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_replicate_myisam=ON;
|
|
ERROR HY000: wsrep_mode=REPLICATE_MYISAM can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
SET GLOBAL wsrep_replicate_myisam=ON;
|
|
ERROR HY000: wsrep_mode=REPLICATE_MYISAM can't be enabled if wsrep_forced_binlog != [NONE|ROW]
|
|
SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|