MySQL Bugs: #20864: Replicate_Do_DB and Replicate_Do

Bug #20864	Replicate_Do_DB and Replicate_Do_Table have duplicate names
Submitted:	5 Jul 2006 9:04	Modified:	5 Jul 2006 12:29
Reporter:	Alex Lapin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.22	OS:	Linux (RHEL ES 4 Update 3)
Assigned to:		CPU Architecture:	Any

Description:
Duplicate database and table names displayed in the result of "SHOW SLAVE STATUS" command.

Replicate_Do_DB: cf,cf_image,cf,cf_image
Replicate_Do_Table: cf.users,cf.user_info,cf_image.profile_images,cf.users,cf_image.profile_images,cf.user_info

All replicate-do-db and replicate-do-table statements are not duplicated in the my.cnf for sure.

It is confusing. I am afraid that mysql slave could execute replicated statements twice.

How to repeat:
Set the following options in /etc/my.cnf on slave server

replicate-do-db=cf
replicate-do-table=cf.users
replicate-do-table=cf.user_info
 
replicate-do-db=cf_image
replicate-do-table=cf_image.profile_images

Restart the server. Run mysql client and execute "SHOW SLAVE STATUS" command:
mysql> SHOW SLAVE STATUS\G

Suggested fix:
Database and table names should not be duplicated

duplicate of Bug #20748