Bug #45592 Extend mysql protocol in connect phase to accept options

• Submitted: 18 Jun 2009 16:07
• Modified: 23 Jun 2009 17:28
• Reporter: Samit pal
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any

[18 Jun 2009 16:07] Samit pal

Description:
The feature request is to extend the mysql protocol a bit. The connect phase can possibly take a few options. It can be thought of something similar to passing the host header  in http 1.1. This will really help for scenarios like mine where people are using some kind of mysql proxy between the server and the client. The options passed at connect time can be used by the proxies to make switching decisions. The extra option/s can possibly be a configurable parameter for the server. Obviously the clients will also have to be modified to make use of this.

This is where my request is coming from. I have a scenarios where i want to use mysql proxy to switch to a particular backend based on username or possibly database chosen. Its pretty hard if not impossible i think to do this with mysql proxy given the nature of the mysql protocol.

I suspect this can be a useful future. What do you guys think ? 

How to repeat:
Does not apply

[23 Jun 2009 17:28] Samit pal

After some thought i realized that what i said here doesn't really make much sense :-). I will close this.