MySQL Bugs: #108132: routing_strategy=fastest-response

Bug #108132	routing_strategy=fastest-response
Submitted:	12 Aug 2022 14:23	Modified:	15 Aug 2022 7:34
Reporter:	Justin Yaple	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Router	Severity:	S4 (Feature request)
Version:	8.0.30	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We just began implementing MySQL 8.0 Clusters and using the MySQL Router to distribute requests out to multiple servers.  We have servers distributed at multiple datacenters and the response time between datacenters is not the same.

How to repeat:
Setup a MySQL cluster with several servers in different sites and some additional latency between them.

Suggested fix:
It would be nice if we could keep the RO requests local if possible using a routing_strategy based on the response time of the server.  This could be based on something as simple as ping or more ideally the responsiveness of a query.

Hello Justin Yaple,

Thank you for the feature request!

regards,
Umesh