Bug #117828 MySQL Router Destination Query
Submitted: 28 Mar 18:52 Modified: 30 Mar 14:47
Reporter: Justin Yaple Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Router Severity:S4 (Feature request)
Version:8.0.32 OS:Windows
Assigned to: CPU Architecture:x86
Tags: destination, router

[28 Mar 18:52] Justin Yaple
Description:
Hello,

We would like to be able to limit the servers returned from the metadata by name and other parameters instead of only the ROLE.

Example:
[routing:bootstrap_ro]
bind_address=0.0.0.0
bind_port=6447
destinations=metadata-cache://CLUSTER/?role=PRIMARY_AND_SECONDARY&host=%S01

This would allow the RO connections to connect to any server Primary or Secondary that the hostname ends in "S01".  Any metadata field should be usable for this criteria.

How to repeat:
Setup any MySQL Router.
[30 Mar 14:47] MySQL Verification Team
Hello Justin Yaple,

Thank you for the feature request!

regards,
Umesh