Bug #90697 Specify X protocol connection attributes via AuthenticateStart and Reset

• Submitted: 30 Apr 2018 17:51
• Modified: 28 Feb 2020 4:51
• Reporter: Jason Rahman
• Status: Verified
• Category: MySQL Server: Document Store: X Plugin
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[30 Apr 2018 17:51] Jason Rahman

Description:
From the documentation, the X protocol does not appear to support connection attributes like the original client/server does. Consider extending the X protocol to include support for connection attributes like the client server protocol.

How to repeat:
Documentation seems to indicate this is not possible in the X protocol

Suggested fix:
Add connection attributes support to the X Protocol, passing the connection attributes in the AuthenticateStart message. Additionally, also include the connection attributes in the reset message. This is useful when pooling connections from clients, because when resetting the connection when retrieving from the pool, the attributes can be changed. Otherwise, the connection attributes are permanently bound to the connection, which implies the attributes must become part of the connection pool key that in turn could dramatically decrease the connection pool hit rate if even a few combinations of distinct connection attributes are used by the client.

[28 Feb 2020 4:51] MySQL Verification Team

Hello Jason,

Thank you for the feature request!

regards,
Umesh