Bug #119013 can't set more than one tables using option --replicate-wild-ignore-table

Submitted: 16 Sep 2025 3:06 Modified: 22 Sep 2025 14:42
Reporter: karry zhang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 2025 3:06] karry zhang
Description:
I recently encountered the following issue while using Fitelr. I configured the following in my cnf file:
replicate-wild-ignore-table=tt.%,phpmyadmin.%

Executing show slave status yields the following output:
show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: ####
Master_User: ####
Master_Port: ####
Connect_Retry: 60
Master_Log_File: mysql-bin.000081
Read_Master_Log_Pos: 197
Relay_Log_File: mysql-relay-bin.000140
Relay_Log_Pos: 429
Relay_Master_Log_File: mysql-bin.000081
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: tt.%,phpmyadmin.%

It appears that the filter has been successfully configured, just like using CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE, but it actually hasn't taken effect.

I reviewed the code and found that using replicate-wild-ignore-table doesn't allow you to configure multiple filters at once, but the documentation doesn't indicate this.
I reviewed the documentation for all filter options at https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_rep...
and found the following description for --replicate-ignore-db:
To specify more than one database to ignore, use this option multiple times, once for each database. Because database names can contain commas, if you supply a comma-separated list, it is treated as the name of a single database.

Unfortunately, this is not mentioned in the other options, which is very confusing for users.

How to repeat:
see the document 
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_rep....

Suggested fix:
Add the comment similar to --replicate-ignore-db mentioned above.
[22 Sep 2025 14:42] MySQL Verification Team
Thank you.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.