Bug #101975 Add replication per-channel filters settings example to documenation.
Submitted: 11 Dec 2020 14:28 Modified: 7 Apr 2022 18:56
Reporter: lalit Choudhary Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[11 Dec 2020 14:28] lalit Choudhary
Description:
It will good and easy reference for the user if we have an example for replication per-channel filters settings in mysql configuration file.

https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html

per-channel filters setting:

replicate-do-db=channel_name:test
replicate-do-db=channel_name:my_db2
replicate-do-db=channel_name:my_db3
replicate-ignore-db=channel_name:db1
replicate-ignore-db=channel_name:db11
replicate-ignore-db=channel_name:my_db6
replicate-do-table=channel_name:test.t1
replicate-do-table=channel_name:test.t2
replicate-ignore-table=channel_name:test.t11
replicate-ignore-table=channel_name:test.t22
replicate-wild-do-table=channel_name:test.t%
replicate-wild-do-table=channel_name:test.s%
replicate-wild-ignore-table=channel_name:test.m%
replicate-wild-ignore-table=channel_name:test.n%
replicate-rewrite-db=channel_name:my_db7->rewrite_db7
replicate-rewrite-db=channel_name:my_db8->rewrite_db8

How to repeat:
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
[14 Dec 2020 7:11] MySQL Verification Team
Hello lalit Choudhary,

Thank you for the doc enhancement request.

regards,
Umesh
[6 Apr 2022 14:15] Jon Stephens
This issue has been assigned to me and I have it on my radar. I will try to take care of this soon. Thanks!
[7 Apr 2022 18:56] Jon Stephens
Fixed in mysqldoc rev 72728.

I've included a brief example and some cross-references to other parts of the Manual that explain use of MySQL command-line options in option files.

The changes to the docs have in fact been committed but may not be visible online for a few days.

Thanks!