Bug #98051 solecism in docs 17.4.6 Replicating Different Databases to Different Slaves
Submitted: 23 Dec 2019 8:21 Modified: 8 Jan 2020 17:55
Reporter: Peter Brawley (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[23 Dec 2019 8:21] Peter Brawley
Description:
In 17.4.6 Replicating Different Databases to Different Slaves ...

Important
You should not use --replicate-do-db for this purpose when using statement-based replication, since statement-based replication causes this option's ***affects*** to vary according to the database that is currently selected. (emphasis added)

MySQL is surely advancing but its options don't yet have feelings, you need ***effects*** here.

How to repeat:
as above

Suggested fix:
As above
[23 Dec 2019 11:18] MySQL Verification Team
Thank you for the bug report.
[8 Jan 2020 17:55] Stefan Hinz
Posted by developer:
 
Typo fixed (in MySQL Manual 5.5, 5.6, 5.7, and 8.0). Thanks for reporting!