Bug #48512 MySQL Proxy Documentation for 14.6.4.2. Internal Structures needs updated
Submitted: 3 Nov 2009 18:29 Modified: 4 Dec 2009 12:10
Reporter: Chris Calender Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Documentation Severity:S4 (Feature request)
Version: OS:Any
Assigned to: MC Brown CPU Architecture:Any

[3 Nov 2009 18:29] Chris Calender
Description:
MySQL Proxy 14.6.4.2 Internal Structures

http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-scripting-structures.html

1. Under proxy.connection, it says you can use "proxy.connection.thread_id".

However, this has been deprecated:

proxy.connection.thread_id is deprecated, use proxy.connection.server.thread_id instead

So you should use proxy.connection.server.thread_id.  Also, proxy.connection.client.thread_id is now possible to be used.

2. There are also a number of other variables available for proxy.connection (for .client and .server):

proxy.connection.client.default_db
proxy.connection.client.username
proxy.connection.client.scrambled_password
proxy.connection.client.dst.name
proxy.connection.client.dst.address
proxy.connection.client.dst.port
proxy.connection.client.src.name
proxy.connection.client.src.address
proxy.connection.client.src.port

proxy.connection.server.scramble_buffer
proxy.connection.server.mysqld_version
proxy.connection.server.thread_id
proxy.connection.server.dst.name
proxy.connection.server.dst.address
proxy.connection.server.dst.port
proxy.connection.server.src.name
proxy.connection.server.src.address
proxy.connection.server.src.port

3. proxy.backends should now be proxy.global.backends, as per:

http://forge.mysql.com/wiki/MySQL_Proxy_0.6_to_0.7

4. Under proxy.backends [proxy.global.backends], the address no longer exists, but has been changed to the following:

proxy.global.backends.dst.name

Furthermore, the above can be broken into two separate variables:

proxy.global.backends.dst.address
proxy.global.backends.dst.port

This is also described here:

http://forge.mysql.com/wiki/MySQL_Proxy_0.6_to_0.7

How to repeat:
N/A

Suggested fix:
N/A
[4 Dec 2009 12:10] MC Brown
The structures have been updated with the new layout; I'll separately add a note to the changelog about the changes once I've collated all the changes.