SIMPLE SOLUTIONS

OCF_HEARTBEAT_MYSQL-PROXY(7) - Linux man page online | Overview, conventions, and miscellany

Manages a MySQL Proxy instance.

Chapter
08/08/2019
OCF_HEARTBEAT_MYSQL() OCF_HEARTBEAT_MYSQL()

NAME

ocf_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 back-end 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 back-end 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-RESOURCE_ID.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 CRM SHELL

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"

EXAMPLE PCS

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"

SEE ALSO

http://clusterlabs.org/

AUTHOR

ClusterLabs contributors (see the resource agent source for information about individual authors)
OCF_HEARTBEAT_MYSQL()
This manual Reference Other manuals
ocf_heartbeat_mysql-proxy(7) referred by
refer to crm(8) | pcs(8)
Download raw manual
Index OCF resource agents (+99) resource-agents UNKNOWN (+98) № 7 (+1560)
Go top