Bug #101975 Add replication per-channel filters settings example to documenation.

• Submitted: 11 Dec 2020 14:28
• Modified: 7 Apr 18:56
• Reporter: lalit Choudhary
• Status: Closed
• 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 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 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!