MySQL Bugs: #99380: Mysql_master-slave replication

Bug #99380	Mysql_master-slave replication
Submitted:	28 Apr 2020 6:28	Modified:	29 Apr 2020 15:55
Reporter:	DBAJJ J	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	5.6.16	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	MySQL, mysql_replication

Description:
I have enabled master slave replication in my production environment. It only replicates one table, for this I have used the variable replicate-do-table in slave server and the replication runs smoothly. Today I have noticed something unusual, that is the functions which are created in master are also replicated in slave. Is this common?? reasons why??

Note: the table and the replicated function does not have any relation though.

How to repeat:
enable single table replication with replication-do-table filter in slave
start replication
create a function in master

Hi,

Yes, expected.

Replication filtering does not always run the way one would expect.
We try to explain it the best we can ( https://dev.mysql.com/doc/refman/8.0/en/replication-rules.html ) but there's always room for improvement.

in good health
Bogdan