MySQL Proxy Command Options
1404
Type
string
Default
127.0.0.1:3306
The host name (or IP address) and port of the MySQL server to connect to. You can specify multiple
backend servers by supplying multiple options. Clients are connected to each backend server in
round-robin fashion. For example, if you specify two servers A and B, the first client connection will
go to server A; the second client connection to server B and the third client connection to server A.
When using this option on the command line, you can specify the option and the server multiple
times to specify multiple backends. For example:
shell>
mysql-proxy --proxy-backend-addresses 192.168.0.1:3306 --proxy-backend-addresses 192.168.0.2:3306
When using the option within the configuration file, you should separate multiple servers by commas.
The equivalent of the preceding example would be:
...
proxy-backend-addresses = 192.168.0.1:3306,192.168.0.2:3306
•
--proxy-pool-no-change-user
[1404]
Command-Line Format
--proxy-pool-no-change-user
Option-File Format
proxy-pool-no-change-user
Disable use of the MySQL protocol
CHANGE_USER
command when reusing a connection from the
pool of connections specified by the
proxy-backend-addresses
list.
•
--proxy-skip-profiling
[1404]
Command-Line Format
--proxy-skip-profiling
Option-File Format
proxy-skip-profiling
Disable query profiling (statistics time tracking). The default is for tracking to be enabled.
•
--proxy-fix-bug-25371
[1404]
Version Removed
0.8.1
Command-Line Format
--proxy-fix-bug-25371
Option-File Format
proxy-fix-bug-25371
Enable a workaround for an issue when connecting to a MySQL server later than 5.1.12 when using
a MySQL client library of any earlier version.
This option was removed in
mysql-proxy
0.8.1. Now,
mysql-proxy
returns an error message
at the protocol level if it sees a
COM_CHANGE_USER
being sent to a server that has a version from
5.1.14 to 5.1.17.
•
--proxy-lua-script=file_name
[1404]
,
-s file_name
Command-Line Format
--proxy-lua-script=file_name
-s file_name
Option-File Format
proxy-lua-script=file_name
Permitted Values
Type
file name
The Lua script file to be loaded. Note that the script file is not physically loaded and parsed until
a connection is made. Also note that the specified Lua script is reloaded for each connection;
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...