wsrep_reject_queries

USAGE

DETAILS

Cluster Nodes can accept or reject queries from client connections. When the Node is configured to reject queries, it continues to replicate write-sets from the cluster and clients can still connect to the Node, but if the client attempts to execute a query, the query it returns an error.

This system variable allows you to specify whether and how the node rejects client queries:

Option

Description

NONE

Cluster Node accepts client queries.

ALL

Cluster Node rejects client queries.

ALL_KILL

Cluster Node rejects client queries and kills existing client connections, including the current connection, without waiting for any currently running queries to complete.

SYNONYMS

SCHEMA

PARAMETERS

Command-line

--wsrep_reject_queries[={NONE|ALL|ALL_KILL}]

Configuration file

Supported

Dynamic

Yes

Scope

Global

Data Type

ENUM (NONE, ALL, ALL_KILL)

Product Default Value

NONE

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

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

  • Added in MariaDB Community Server 10.3.6.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.14.

EXTERNAL REFERENCES