ocf:mysql-proxy — Manages a MySQL Proxy instance
[OCF_RESKEY_binary=string] [OCF_RESKEY_client_binary=string] [OCF_RESKEY_defaults_file=string] [OCF_RESKEY_proxy_backend_addresses=string] [OCF_RESKEY_proxy_read_only_backend_addresses=string] [OCF_RESKEY_proxy_address=string] [OCF_RESKEY_log_level=string] [OCF_RESKEY_keepalive=string] [OCF_RESKEY_plugins=string] [OCF_RESKEY_admin_address=string] [OCF_RESKEY_admin_username=string] [OCF_RESKEY_admin_password=string] [OCF_RESKEY_admin_lua_script=string] [OCF_RESKEY_test_table=string] [OCF_RESKEY_test_user=string] [OCF_RESKEY_test_passwd=string] [OCF_RESKEY_parameters=string] OCF_RESKEY_pidfile=string mysql-proxy [start | stop | reload | monitor | validate-all | meta-data]
This script manages MySQL Proxy as an OCF resource in a high-availability setup. The default monitor operation will verify that mysql-proxy is running. The level 10 monitor operation is left out intentionally for possible future enhancements in conjunction with the admin plugin. The level 20 monitor operation will perform a SELECT on a given table to verify that the connection to a backend-server is actually working. Tested with MySQL Proxy 0.8.1 and 0.8.3 on Debian 6.0.
Full path to the MySQL Proxy binary. For example, "/usr/sbin/mysql-proxy".
Location of the MySQL client binary
Full path to a MySQL Proxy configuration file. For example, "/etc/mysql-proxy.conf".
Address:port of the remote backend-servers (default: 127.0.0.1:3306).
Address:port of the remote (read only) slave-server (default: ).
Listening address:port of the proxy-server (default: :4040). You can also specify a socket like "/tmp/mysql-proxy.sock".
Log all messages of level (error|warning|info|message|debug|) or higher. An empty value disables logging.
Try to restart the proxy if it crashed (default: ). Valid values: true or false. An empty value equals "false".
Whitespace separated list of plugins to load (default: ). Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
Listening address:port of the admin plugin (default: 127.0.0.1:4041). Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
Username for the admin plugin (default: ). Required since MySQL Proxy 0.8.1, if the admin plugin is loaded. Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
Password for the admin plugin (default: ). Required since MySQL Proxy 0.8.1, if the admin plugin is loaded. Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
Script to execute by the admin plugin. Required since MySQL Proxy 0.8.1, if the admin plugin is loaded. Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
Table to be tested in monitor statement (in database.table notation)
MySQL test user
MySQL test user password
The MySQL Proxy daemon may be called with additional parameters. Specify any of them here.
PID file