MySQL Bugs: #114906: Feature request: possibility to drain MySQL Router connections

Bug #114906	Feature request: possibility to drain MySQL Router connections
Submitted:	7 May 2024 10:10	Modified:	7 May 2024 19:51
Reporter:	Abel Cabezas	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Router	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	MySQL Router

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
With the introduction of a drain functionality for MySQL Router instances it would  be possible to reduce the impact of MySQL Router upgrades or any other type of maintenance operations by following blue/green deployment approaches. This way MySQL Router interventions could be transparent.

Ideally this feature should allow several options:

- Kill all active sessions inmmediatelly
- Set a timeout for all the active sessions to be drained 
- Wait until all active sessions have finished

How to repeat:
Non reproducible

Thank you for the report.