Oracle 5.0, Справочное руководство

Страница: 1431 / 3232

MySQL Proxy Scripting
1411
Attribute Description
client.src.address
The IP address of the client (originating) TCP/IP port
client.src.port
The port of the client (originating) TCP/IP endpoint
server.scramble_buffer
The scramble buffer used to scramble the password
server.mysqld_version
The MySQL version number of the server
server.thread_id
The ID of the thread handling the connection to the current server
server.dst.name
The combined
address:port
for the backend server for the current
connection (i.e. the connection to the MySQL server)
server.dst.address
The address for the backend server
server.dst.port
The port for the backend server
server.src.name
The combined
address:port
for the TCP/IP endpoint used by the
Proxy to connect to the backend server
server.src.address
The address of the endpoint for the proxy-side connection to the
MySQL server
server.src.port
The port of the endpoint for the proxy-side connection to the MySQL
server
proxy.global.backends
The
proxy.global.backends
table is partially writable and contains an array of all the configured
backend servers and the server metadata (IP address, status, etc.). You can determine the array index
of the current connection using
proxy.connection["backend_ndx"]
which is the index into this
table of the backend server being used by the active connection.
The attributes for each entry within the
proxy.global.backends
table are shown in the following
table.
Attribute Description
dst.name
The combined
address:port
of the backend server.
dst.address
The IP address of the backend server.
dst.port
The port of the backend server.
connected_clients
The number of clients currently connected.
state
The status of the backend server. See Backend State/Type
Constants [1414] .
type
The type of the backend server. You can use this to identify
whether the backed was configured as a standard read/write
backend, or a read-only backend. You can compare this value to the
proxy.BACKEND_TYPE_RW
and
proxy.BACKEND_TYPE_RO
.
proxy.queries
The
proxy.queries
object is a queue representing the list of queries to be sent to the server. The
queue is not populated automatically, but if you do not explicitly populate the queue, queries are
passed on to the backend server verbatim. Also, if you do not populate the query queue by hand, the
read_query_result()
function is not triggered.
The following functions are supported for populating the
proxy.queries
object.
Function Description
append(id,packet,
[options])
Appends a query to the end of the query queue. The
id
is an integer
identifier that you can use to recognize the query results when they
are returned by the server. The packet should be a properly formatted