OCF_HEARTBEAT_MYSQL()OCF_HEARTBEAT_MYSQL()NAMEocf_heartbeat_mysql-proxy - Manages a MySQL Proxy instance
SYNOPSIS
mysql-proxy [start | stop | monitor | meta-data | validate-all]
DESCRIPTION
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.
SUPPORTED PARAMETERS
binary
Full path to the MySQL Proxy binary. For example,
"/usr/sbin/mysql-proxy".
(optional, string, default "/usr/sbin/mysql-proxy")
client_binary
Location of the MySQL client binary
(optional, string, default "mysql")
defaults_file
Full path to a MySQL Proxy configuration file. For example,
"/etc/mysql-proxy.conf".
(optional, string, no default)
proxy_backend_addresses
Address:port of the remote backend-servers (default:
127.0.0.1:3306).
(optional, string, default "127.0.0.1:3306")
proxy_read_only_backend_addresses
Address:port of the remote (read only) slave-server (default: ).
(optional, string, default "127.0.0.1:3306")
proxy_address
Listening address:port of the proxy-server (default: :4040). You
can also specify a socket like "/tmp/mysql-proxy.sock".
(optional, string, default ":4040")
log_level
Log all messages of level (error|warning|info|message|debug|) or
higher. An empty value disables logging.
(optional, string, no default)
keepalive
Try to restart the proxy if it crashed (default: ). Valid values:
true or false. An empty value equals "false".
(optional, string, no default)
plugins
Whitespace separated list of plugins to load (default: ). Note: The
admin plugin will be auto-loaded in case you specify an admin_*
parameter.
(optional, string, no default)
admin_address
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.
(optional, string, default "127.0.0.1:4041")
admin_username
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.
(optional, string, no default)
admin_password
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.
(optional, string, no default)
admin_lua_script
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.
(optional, string, no default)
test_table
Table to be tested in monitor statement (in database.table
notation)
(optional, string, default "mysql.user")
test_user
MySQL test user
(optional, string, no default)
test_passwd
MySQL test user password
(optional, string, no default)
parameters
The MySQL Proxy daemon may be called with additional parameters.
Specify any of them here.
(optional, string, no default)
pidfile
PID file
(unique, optional, string, default
"/var/run/resource-agents/mysql-proxy-default.pid")
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 30s.
stop
Stops the resource. Suggested minimum timeout: 30s.
reload
Suggested minimum timeout: 30s.
monitor
Performs a detailed status check. Suggested minimum timeout: 20s.
Suggested interval: 60s.
validate-all
Performs a validation of the resource configuration. Suggested
minimum timeout: 30s.
meta-data
Retrieves resource agent metadata (internal use only). Suggested
minimum timeout: 5s.
EXAMPLE
The following is an example configuration for a mysql-proxy resource
using the crm(8) shell:
primitive p_mysql-proxy ocf:heartbeat:mysql-proxy \
op monitor depth="0" timeout="20s" interval="60s"
SEE ALSO
http://www.linux-ha.org/wiki/mysql-proxy_(resource_agent)AUTHOR
Linux-HA contributors (see the resource agent source for information
about individual authors)
OCF_HEARTBEAT_MYSQL()