Replication filters not allowing consistent behavior

Description

Currently, it is impossible to get 100% consistent behavior using replication filters, even if the ROW binlog format is used. 

The problem is with CREATE/DROP FUNCTION/STORED PROCEDURE statements, as the replication-wild* filters do not apply to those:

https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_replicate-wild-do-table

Quoting:

The replication filter specified by the --replicate-wild-do-table option applies to tables, views, and triggers. It does not apply to stored procedures and functions, or events. 

This makes it difficult to apply filters that would allow to replicate all types of queries for a given db/table consistently. 

Upstream bugs related:

https://bugs.mysql.com/bug.php?id=48858

https://bugs.mysql.com/bug.php?id=102100

https://bugs.mysql.com/bug.php?id=106970

Environment

None

AFFECTED CS IDs

CS0041607

Activity

Details

Assignee

Reporter

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created November 15, 2023 at 8:19 AM
Updated March 6, 2024 at 9:30 AM