MySQL Bugs: #117828: MySQL Router Destination Query

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Hello Justin Yaple,

Thank you for the feature request!

regards,
Umesh