Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas:
- A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera,
- A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera.
- A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated.
- A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated.
- A session writes to any other non-InnoDB storage engine, so the write will not be replicated.
- A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated.
Approach used for the implementation:
wsrep_mode is a server variable that one can use to enable/disable specific Galera features.
To set or unset the various features, use the following syntax:
SET GLOBAL wsrep_mode='cmd[,cmd]...';
Possible values:
- DEFAULT : Disable all features
- BINLOG_ROW_FORMAT_ONLY : Galera requires binlog format row
- REQUIRED_PRIMARY_KEY : Galera will require primary key for tables
- STRICT_REPLICATION : Warning is issued if changes are done to tables that storage engine is not supported by Galera
Variable wsrep_strict_ddl is deprecated and replaced with wsrep_mode='STRICT_REPLICATION'.
Attachments
Issue Links
- relates to
-
MDEV-24843 Remove parameter wsrep_strict_ddl
-
- Closed
-
-
MDEV-24945 Document new wsrep_mode system variable for Galera in 10.6
-
- Open
-
Activity
Field | Original Value | New Value |
---|---|---|
Description | Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with error message or produce a warning. |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.5 [ 23123 ] |
Description | Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with error message or produce a warning. |
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas: * A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera, * A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera. * A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated. * A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated. * A session writes to any other non-InnoDB storage engine, so the write will not be replicated. * A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated. |
Assignee | Mario Karuza [ mkaruza ] | Jan Lindström [ jplindst ] |
issue.field.resolutiondate | 2021-01-27 06:11:33.0 | 2021-01-27 06:11:33.958 |
Fix Version/s | 10.6.0 [ 24431 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Link | This issue relates to MENT-436 [ MENT-436 ] |
Link | This issue includes MENT-436 [ MENT-436 ] |
Link | This issue includes MENT-436 [ MENT-436 ] |
Link | This issue relates to TODO-2749 [ TODO-2749 ] |
Description |
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas: * A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera, * A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera. * A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated. * A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated. * A session writes to any other non-InnoDB storage engine, so the write will not be replicated. * A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated. |
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas: * A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera, * A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera. * A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated. * A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated. * A session writes to any other non-InnoDB storage engine, so the write will not be replicated. * A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated. +Approach used for the implementation:+ wsrep_mode is a server variable that one can use to enable/disable specific Galera features. To set or unset the various features, use the following syntax: SET GLOBAL wsrep_mode='cmd[,cmd]...'; Possible values: * DEFAULT : Disable all features * BINLOG_ROW_FORMAT_ONLY : Galera requires binlog format row * REQUIRED_PRIMARY_KEY : Galera will require primary key for tables * STRICT_REPLICATION : Warning is issued if changes are done to tables that storage engine is not supported by Galera * Variable wsrep_strict_ddl is deprecated and replaced with wsrep_mode='STRICT_REPLICATION'. |
Description |
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas: * A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera, * A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera. * A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated. * A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated. * A session writes to any other non-InnoDB storage engine, so the write will not be replicated. * A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated. +Approach used for the implementation:+ wsrep_mode is a server variable that one can use to enable/disable specific Galera features. To set or unset the various features, use the following syntax: SET GLOBAL wsrep_mode='cmd[,cmd]...'; Possible values: * DEFAULT : Disable all features * BINLOG_ROW_FORMAT_ONLY : Galera requires binlog format row * REQUIRED_PRIMARY_KEY : Galera will require primary key for tables * STRICT_REPLICATION : Warning is issued if changes are done to tables that storage engine is not supported by Galera * Variable wsrep_strict_ddl is deprecated and replaced with wsrep_mode='STRICT_REPLICATION'. |
Add configuration variable wsrep_strict_mode=[ON|OFF] where operations that are harmful or problematic in cluster environment are either refused with an error message or produce a warning.
Jan's suggested ideas: * A session has binlog_format set to STATEMENT, and the session writes to an InnoDB table. The associated statement will be logged in statement-based format, which is unsupported by Galera, * A session has binlog_format set to MIXED, and the session writes to an InnoDB table. The associated statement could be logged in statement-based format, which is unsupported by Galera. * A node has wsrep_replicate_myisam set to OFF, and a session on the node writes to a MyISAM table, so the write will not be replicated. * A node has wsrep_replicate_aria set to OFF, and a session on the node writes to an Aria table, so the write will not be replicated. * A session writes to any other non-InnoDB storage engine, so the write will not be replicated. * A session has wsrep_on set to OFF, and the session writes to an InnoDB table, so the write will not be replicated. +Approach used for the implementation:+ wsrep_mode is a server variable that one can use to enable/disable specific Galera features. To set or unset the various features, use the following syntax: SET GLOBAL wsrep_mode='cmd[,cmd]...'; Possible values: * DEFAULT : Disable all features * BINLOG_ROW_FORMAT_ONLY : Galera requires binlog format row * REQUIRED_PRIMARY_KEY : Galera will require primary key for tables * STRICT_REPLICATION : Warning is issued if changes are done to tables that storage engine is not supported by Galera Variable wsrep_strict_ddl is deprecated and replaced with wsrep_mode='STRICT_REPLICATION'. |
Link |
This issue relates to |
Link | This issue relates to MDEV-24945 [ MDEV-24945 ] |
Workflow | MariaDB v3 [ 98128 ] | MariaDB v4 [ 134038 ] |
Possible ideas: