replicate_ignore_db

Overview

Tell the slave to restrict replication to updates of tables whose names do not appear in the comma-separated list. For statement-based replication, only the default database (that is, the one selected by USE) is considered, not any explicitly mentioned tables in the query. For row-based replication, the actual names of table(s) being updated are checked.

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

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

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

Command-line

Not Supported

Configuration file

Not Supported

Dynamic

Yes

Scope

Global

Data Type

VARCHAR

Product Default Value

"" (an empty string)

SKYSQL

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

Multi-Node Analytics

10.6

"" (an empty string)

Single Node Analytics

10.6

"" (an empty string)

Replicated Transactions

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

Single Node Transactions

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

GCP

Multi-Node Analytics

10.6

"" (an empty string)

Single Node Analytics

10.6

"" (an empty string)

Replicated Transactions

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

Single Node Transactions

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

ColumnStore Data Warehouse

10.6

"" (an empty string)

Enterprise Server With Replica(s)

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

Enterprise Server Single Node

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

GCP

ColumnStore Data Warehouse

10.6

"" (an empty string)

Enterprise Server With Replica(s)

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

Enterprise Server Single Node

10.4

"" (an empty string)

10.5

"" (an empty string)

10.6

"" (an empty string)

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