Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.6.0
    • Galera
    • 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

          Activity

            jplindst Jan Lindström (Inactive) created issue -
            jplindst Jan Lindström (Inactive) made changes -
            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.
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.5 [ 23123 ]
            julien.fritsch Julien Fritsch made changes -
            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.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Mario Karuza [ mkaruza ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2021-01-27 06:11:33.0 2021-01-27 06:11:33.958
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.6.0 [ 24431 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            julien.fritsch Julien Fritsch made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            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'.

            ralf.gebhardt Ralf Gebhardt made changes -
            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'.

            ralf.gebhardt Ralf Gebhardt made changes -
            jplindst Jan Lindström (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 98128 ] MariaDB v4 [ 134038 ]

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.