wsrep_sst_donor_rejects_queries

Overview

Rejects blocking client sessions while node acts as a donor to a blocking SST operation.

See also: System Variables for MariaDB Enterprise Server 23.08, in 23.07 ES, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

USAGE

DETAILS

In a State Snapshot Transfer (SST), a donor node copies its local database and sends it to a joiner node, allowing the joiner to quickly bring itself into sync with the cluster. The specific SST method is set using the wsrep_sst_method system variable. Certain SST methods are blocking, meaning that during the operation the donor node blocks write operations from modifying the database.

This system variable configures how the node handles client connections while operating as a donor. When enabled, if a client or connector attempts to establish a blocking connection to the node while it performing a State Snapshot Transfer as a donor, the node rejects the connection.

SYNONYMS

SCHEMA

PARAMETERS

Command-line

--wsrep_sst_donor_rejects_queries[={OFF|ON}]

Configuration file

Supported

Dynamic

Yes

Scope

Global

Data Type

BOOLEAN (OFF, ON)

Product Default Value

OFF

SKYSQL

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.

EXTERNAL REFERENCES