SLTechnology News&Howtos › Database ›

Mysql ignores replicated tables

Shulou Source: shulou.com Published: 2022-06-01 09:32:49 09月12日 Update

[mysqld]

Binlog-ignore-db = mysql

Replicate-ignore-db = mysql

Binlog-ignore-db = information_schema

Replicate-ignore-db = information_schema

Binlog-ignore-db = performance_schema

Replicate-ignore-db = performance_schema

Binlog-ignore-db = test

Replicate-ignore-db = test

Replicate-wild-ignore-table=mysql.%

Replicate-wild-ignore-table=information_schema.%

Replicate-wild-ignore-table=performance_schema.%

Replicate-wild-ignore-table=test.%