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". (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 (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 example_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)