Bug #83710 Support redirection in MySQL protocol?
Submitted: 7 Nov 2016 2:54 Modified: 22 Jan 2017 10:24
Reporter: Xiangyu Hu Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: feature, login redirection, protocol

[7 Nov 2016 2:54] Xiangyu Hu
Description:
This would benefit a lot to various proxies and distributed MySQL clusters designs, by adding one more TCP handshake round-trip. 

Client                 Server 
<--------Greeting-------- 
---------Login----------> 
<-------NEW ENDPOINT----- 
------   MySQL     ----> 
------ Handshake -----> 

What's added to current protocol is that a new endpoint in included in the login response. Client will then choose to close current TCP connection while start another with the redirected destination.

How to repeat:
Feature request, non-repeatable.
[22 Jan 2017 10:24] Xiangyu Hu
Ping. Anyone has something to say about it?