OCF_HEARTBEAT_MYSQL() | OCF_HEARTBEAT_MYSQL() |
ocf_heartbeat_mysql-proxy - Manages a MySQL Proxy instance
mysql-proxy [start | stop | monitor | meta-data | validate-all]
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 back-end server is actually working.
Tested with MySQL Proxy 0.8.1 and 0.8.3 on Debian 6.0.
binary
(optional, string, default "/usr/sbin/mysql-proxy")
client_binary
(optional, string, default "mysql")
defaults_file
(optional, string, no default)
proxy_backend_addresses
(optional, string, default "127.0.0.1:3306")
proxy_read_only_backend_addresses
(optional, string, default "127.0.0.1:3306")
proxy_address
(optional, string, default ":4040")
log_level
(optional, string, no default)
keepalive
(optional, string, no default)
plugins
(optional, string, no default)
admin_address
(optional, string, default "127.0.0.1:4041")
admin_username
(optional, string, no default)
admin_password
(optional, string, no default)
admin_lua_script
(optional, string, no default)
test_table
(optional, string, default "mysql.user")
test_user
(optional, string, no default)
test_passwd
(optional, string, no default)
parameters
(optional, string, no default)
pidfile
(unique, optional, string, default "/run/resource-agents/mysql-proxy-RESOURCE_ID.pid")
This resource agent supports the following actions (operations):
start
stop
reload
monitor
validate-all
meta-data
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"
The following is an example configuration for a mysql-proxy resource using pcs(8)
pcs resource create p_mysql-proxy ocf:heartbeat:mysql-proxy \
op monitor depth="0" timeout="20s" interval="60s"
http://clusterlabs.org/
ClusterLabs contributors (see the resource agent source for information about individual authors)