Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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, no default)

       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()

NAME | SYNOPSIS | DESCRIPTION | SUPPORTED PARAMETERS | SUPPORTED ACTIONS | EXAMPLE CRM SHELL | EXAMPLE PCS | SEE ALSO | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=ocf_heartbeat_mysql-proxy&sektion=7&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help