Scroll to navigation

OCF_HEARTBEAT_MYSQL() OCF_HEARTBEAT_MYSQL()

NAME

ocf_heartbeat_mysql-proxy - Manages a MySQL Proxy daemon

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. Tested with MySQL Proxy 0.7.0 on Debian 5.0.

SUPPORTED PARAMETERS

binary
Full path to the MySQL Proxy binary. For example, "/usr/sbin/mysql-proxy". (optional, string, default /usr/sbin/mysql-proxy)
defaults_file
Full path to a MySQL Proxy configuration file. For example, "/etc/mysql-proxy.conf". (unique, 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)
admin_address
Listening address:port of the admin-server (default: 127.0.0.1:4041). (optional, string, default 127.0.0.1:4041)
admin_username
Username to allow to log in (default: ). (optional, string, no default)
admin_password
Password to allow to log in (default: ). (optional, string, no default)
admin_lua_script
Script to execute by the admin plugin. (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)