replicate_ignore_db

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 in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

PARAMETERS

Command-line

Not Supported

Configuration file

Not Supported

Dynamic

Yes

Scope

Global

Data Type

VARCHAR

Default Value

"" (an empty string)

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

"" (an empty string)

AWS

HA (Primary/Replica)

10.5

"" (an empty string)

AWS

Transactional Standalone

10.4

"" (an empty string)

AWS

Transactional Standalone

10.5

"" (an empty string)

AWS

Distributed Transactions

10.5

"" (an empty string)

GCP

ColumnStore

10.5

"" (an empty string)

GCP

ColumnStore Multi

10.5

"" (an empty string)

GCP

Galera

10.4

"" (an empty string)

GCP

Galera

10.5

"" (an empty string)

GCP

HA (Primary/Replica)

10.4

"" (an empty string)

GCP

HA (Primary/Replica)

10.5

"" (an empty string)

GCP

HTAP

10.5

"" (an empty string)

GCP

Transactional Standalone

10.4

"" (an empty string)

GCP

Transactional Standalone

10.5

"" (an empty string)

GCP

Distributed Transactions

10.5

"" (an empty string)

See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.

CHANGE HISTORY

Release Series

History

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