gtid_strict_mode

Overview

In 23.08 ES, 23.07 ES:

Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed. When ON the same server-id semisync-replicated transactions that duplicate existing ones in binlog are ignored without error and slave interruption.

In 10.6 ES, 10.6 CS, 10.5 ES, 10.4 ES, 10.3 ES:

Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed. When ON the same server-id semisync-replicated transactions that duplicate exising ones in binlog are ignored without error and slave interruption.

In 10.6 ES, 10.5 ES, 10.4 ES:

Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed. When ON the same server-id semisync-replicated transactions that duplicate exising ones in binlog are ignored without error and slave interruption.

In 10.5 CS, 10.4 CS, 10.3 CS, 10.2 ES, 10.2 CS:

Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed.

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

Command-line

--gtid_strict_mode[={OFF|ON}]

Configuration file

Supported

Dynamic

Yes

Scope

Global

Data Type

BOOLEAN (OFF, ON)

Product Default Value

OFF

SKYSQL

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

Multi-Node Analytics

10.6

ON (choices: OFF, ON)

Single Node Analytics

10.6

ON (choices: OFF, ON)

Replicated Transactions

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

Single Node Transactions

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

GCP

Multi-Node Analytics

10.6

ON (choices: OFF, ON)

Single Node Analytics

10.6

ON (choices: OFF, ON)

Replicated Transactions

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

Single Node Transactions

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

ColumnStore Data Warehouse

10.6

ON

Enterprise Server With Replica(s)

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

Enterprise Server Single Node

10.4

ON

10.5

ON

10.6

ON

GCP

ColumnStore Data Warehouse

10.6

ON

Enterprise Server With Replica(s)

10.4

ON (choices: OFF, ON)

10.5

ON (choices: OFF, ON)

10.6

ON (choices: OFF, ON)

Enterprise Server Single Node

10.4

ON

10.5

ON

10.6

ON

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES