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 Default (Analytical 10.5)

"" (an empty string)

SkySQL Default (Analytical/Multi 10.5)

"" (an empty string)

SkySQL Default (Cluster 10.4)

"" (an empty string)

SkySQL Default (Cluster 10.5)

"" (an empty string)

SkySQL Default (HTAP 10.5)

"" (an empty string)

SkySQL Default (Primary/Replica 10.4)

"" (an empty string)

SkySQL Default (Primary/Replica 10.5)

"" (an empty string)

SkySQL Default (Standalone 10.4)

"" (an empty string)

SkySQL Default (Standalone 10.5)

"" (an empty string)

SkySQL Default (Xpand 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