Details
Assignee
UnassignedUnassignedReporter
Przemyslaw MalkowskiPrzemyslaw MalkowskiUpstream Bug URL
Needs QA
YesAffects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
Przemyslaw Malkowski
Przemyslaw MalkowskiUpstream Bug URL
Needs QA
Yes
Affects versions
Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created November 15, 2023 at 8:19 AM
Updated March 6, 2024 at 9:30 AM
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:
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