No OneTemporary
Actions

Size

27 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/heartbeat/mysql-proxy b/heartbeat/mysql-proxy
	index 018a0a21c..f4395b6eb 100755
	--- a/heartbeat/mysql-proxy
	+++ b/heartbeat/mysql-proxy
	@@ -1,468 +1,688 @@
	#!/bin/sh
	#
	# Resource script for MySQL Proxy
	#
	# Description: Manages MySQL Proxy as an OCF resource in
	# an high-availability setup.
	#
	-# Tested with mysql-proxy 0.7.0 on Debian 5.0.
	+# Originally tested with MySQL Proxy 0.7.0 on Debian 5.0,
	+# but subsequent updates have been tested with MySQL Proxy 0.8.1 and 0.8.3 on Debian 6.0 only.
	+#
	# Based on the mysql and Pure-Ftpd OCF resource agents.
	#
	# Author: Raoul Bhatia <r.bhatia@ipax.at> : Original Author
	# License: GNU General Public License (GPL)
	#
	#
	# usage: $0 {start\|stop\|reload\|status\|monitor\|validate-all\|meta-data}
	#
	# The "start" arg starts a MySQL Proxy instance
	#
	# The "stop" arg stops it.
	#
	# TODO
	-# * add error checking like in mysql ocf ra (e.g. socketdir)
	+# * add in-depth monitoring by querying the mysql-proxy admin port
	#
	# Test via
	-# */usr/sbin/ocf-tester -n mp /usr/lib/ocf/resource.d/heartbeat/mysql-proxy
	-# */usr/sbin/ocf-tester -n ms -o binary="/usr/sbin/mysql-proxy" -o defaults_file="" -o parameters="--proxy-skip-profiling" \
	-# -o admin_address="127.0.0.1:4041" -o proxy_backend_addresses="192.168.100.200:42006" \
	-# -o proxy_address="/var/run/mysqld/mysqld.sock" /usr/lib/ocf/resource.d/heartbeat/mysql-proxy
	+# (note: this did not work with MySQL Proxy 0.8.1 and ocf-tester from resource-agents 3.9.2 on Debian 6.0)
	#
	-# * adding two mysql-instances (mysql-proxy-tcp and mysql-proxy-socket) and killing mysql-proxy-tcp
	-# beware, that as of mysql-proxy 0.7.0 (and possibly later), the socket is not automatically removed
	+# * /usr/sbin/ocf-tester -n mp -o binary="/usr/sbin/mysql-proxy" -o defaults_file="" -o parameters="--proxy-skip-profiling" \
	+# -o admin_address="127.0.0.1:4041" -o admin_username="root" -o admin_password="la" -o admin_lua_script="/usr/lib/mysql-proxy/lua/admin.lua" \
	+# -o proxy_backend_addresses="192.168.100.200:42006" -o proxy_address="/var/run/mysqld/mysqld.sock" /usr/lib/ocf/resource.d/heartbeat/mysql-proxy
	#
	#
	# OCF parameters:
	# OCF_RESKEY_binary
	+# OCF_RESKEY_client_binary
	# OCF_RESKEY_defaults_file
	# OCF_RESKEY_proxy_backend_addresses
	# OCF_RESKEY_proxy_read_only_backend_addresses
	# OCF_RESKEY_proxy_address
	# OCF_RESKEY_log_level
	# OCF_RESKEY_keepalive
	+# OCF_RESKEY_plugins
	# OCF_RESKEY_admin_address
	# OCF_RESKEY_admin_username
	# OCF_RESKEY_admin_password
	# OCF_RESKEY_admin_lua_script
	+# OCF_RESKEY_test_table
	+# OCF_RESKEY_test_user
	+# OCF_RESKEY_test_passwd
	# OCF_RESKEY_parameters
	# OCF_RESKEY_pidfile
	#
	##########################################################################

	# Initialization:

	: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/lib/heartbeat}
	. ${OCF_FUNCTIONS_DIR}/ocf-shellfuncs

	: ${OCF_RESKEY_binary="/usr/sbin/mysql-proxy"}
	+: ${OCF_RESKEY_client_binary="mysql"}
	: ${OCF_RESKEY_defaults_file=""}
	: ${OCF_RESKEY_proxy_backend_addresses="127.0.0.1:3306"}
	: ${OCF_RESKEY_proxy_read_only_backend_addresses=""}
	: ${OCF_RESKEY_proxy_address=":4040"}
	: ${OCF_RESKEY_log_level=""}
	: ${OCF_RESKEY_keepalive=""}
	+: ${OCF_RESKEY_plugins=""}
	: ${OCF_RESKEY_admin_address="127.0.0.1:4041"}
	: ${OCF_RESKEY_admin_username=""}
	: ${OCF_RESKEY_admin_password=""}
	: ${OCF_RESKEY_admin_lua_script=""}
	+: ${OCF_RESKEY_test_table="mysql.user"}
	+: ${OCF_RESKEY_test_user=""}
	+: ${OCF_RESKEY_test_passwd=""}
	: ${OCF_RESKEY_parameters=""}
	: ${OCF_RESKEY_pidfile="${HA_RSCTMP}/mysql-proxy-${OCF_RESOURCE_INSTANCE}.pid"}
	USAGE="Usage: $0 {start\|stop\|reload\|status\|monitor\|validate-all\|meta-data}";

	##########################################################################

	usage() {
	echo $USAGE >&2
	}

	meta_data() {
	cat <<END
	<?xml version="1.0"?>
	<!DOCTYPE resource-agent SYSTEM "ra-api-1.dtd">
	<resource-agent name="mysql-proxy">
	<version>0.1</version>
	<longdesc lang="en">
	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.
	+
	+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 backend-server is actually working.
	+
	+Originally tested with MySQL Proxy 0.7.0 on Debian 5.0, but subsequent updates have been tested with MySQL Proxy 0.8.1 and 0.8.3 on Debian 6.0 only.
	</longdesc>
	-<shortdesc lang="en">Manages a MySQL Proxy daemon</shortdesc>
	+<shortdesc lang="en">Manages a MySQL Proxy instance</shortdesc>

	<parameters>

	<parameter name="binary" unique="0" required="0">
	<longdesc lang="en">
	Full path to the MySQL Proxy binary.
	For example, "/usr/sbin/mysql-proxy".
	</longdesc>
	<shortdesc lang="en">Full path to MySQL Proxy binary</shortdesc>
	<content type="string" default="/usr/sbin/mysql-proxy" />
	</parameter>

	-<parameter name="defaults_file" unique="1" required="0">
	+<parameter name="client_binary" unique="0" required="0">
	+<longdesc lang="en">
	+Location of the MySQL client binary
	+</longdesc>
	+<shortdesc lang="en">MySQL client binary</shortdesc>
	+<content type="string" default="mysql" />
	+</parameter>
	+
	+<parameter name="defaults_file" unique="0" required="0">
	<longdesc lang="en">
	Full path to a MySQL Proxy configuration file.
	For example, "/etc/mysql-proxy.conf".
	</longdesc>
	<shortdesc lang="en">Full path to configuration file</shortdesc>
	<content type="string" default="" />
	</parameter>

	<parameter name="proxy_backend_addresses" unique="0" required="0">
	<longdesc lang="en">
	Address:port of the remote backend-servers (default: 127.0.0.1:3306).
	</longdesc>
	<shortdesc lang="en">MySQL Proxy backend-servers</shortdesc>
	<content type="string" default="127.0.0.1:3306" />
	</parameter>

	<parameter name="proxy_read_only_backend_addresses" unique="0" required="0">
	<longdesc lang="en">
	Address:port of the remote (read only) slave-server (default: ).
	</longdesc>
	<shortdesc lang="en">MySql Proxy read only backend-servers</shortdesc>
	<content type="string" default="127.0.0.1:3306" />
	</parameter>

	<parameter name="proxy_address" unique="0" required="0">
	<longdesc lang="en">
	Listening address:port of the proxy-server (default: :4040).
	You can also specify a socket like "/tmp/mysql-proxy.sock".
	</longdesc>
	<shortdesc lang="en">MySQL Proxy listening address</shortdesc>
	<content type="string" default=":4040" />
	</parameter>

	<parameter name="log_level" unique="0" required="0">
	<longdesc lang="en">
	Log all messages of level (error\|warning\|info\|message\|debug\|) or higher.
	An empty value disables logging.
	</longdesc>
	<shortdesc lang="en">MySQL Proxy log level.</shortdesc>
	<content type="string" default="" />
	</parameter>

	<parameter name="keepalive" unique="0" required="0">
	<longdesc lang="en">
	Try to restart the proxy if it crashed (default: ).
	Valid values: true or false. An empty value equals "false".
	</longdesc>
	<shortdesc lang="en">Use keepalive option</shortdesc>
	<content type="string" default="" />
	</parameter>

	+<parameter name="plugins" unique="0" required="0">
	+<longdesc lang="en">
	+Whitespace separated list of plugins to load (default: ).
	+Note: The admin plugin will be auto-loaded in case you specify an admin_* parameter.
	+</longdesc>
	+<shortdesc lang="en">MySQL Proxy plugins</shortdesc>
	+<content type="string" default="" />
	+</parameter>
	+
	<parameter name="admin_address" unique="0" required="0">
	<longdesc lang="en">
	-Listening address:port of the admin-server (default: 127.0.0.1:4041).
	+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.
	</longdesc>
	-<shortdesc lang="en">MySQL Proxy admin-server address</shortdesc>
	+<shortdesc lang="en">MySQL Proxy admin plugin listening address</shortdesc>
	<content type="string" default="127.0.0.1:4041" />
	</parameter>

	<parameter name="admin_username" unique="0" required="0">
	<longdesc lang="en">
	-Username to allow to log in (default: ).
	+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.
	</longdesc>
	-<shortdesc lang="en">MySQL Proxy admin-server username</shortdesc>
	+<shortdesc lang="en">MySQL Proxy admin plugin username</shortdesc>
	<content type="string" default="" />
	</parameter>

	<parameter name="admin_password" unique="0" required="0">
	<longdesc lang="en">
	-Password to allow to log in (default: ).
	+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.
	</longdesc>
	-<shortdesc lang="en">MySQL Proxy admin-server password</shortdesc>
	+<shortdesc lang="en">MySQL Proxy admin plugin password</shortdesc>
	<content type="string" default="" />
	</parameter>

	<parameter name="admin_lua_script" unique="0" required="0">
	<longdesc lang="en">
	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.
	</longdesc>
	-<shortdesc lang="en">MySQL Proxy admin-server lua script</shortdesc>
	+<shortdesc lang="en">MySQL Proxy admin plugin lua script</shortdesc>
	<content type="string" default="" />
	</parameter>

	+<parameter name="test_table" unique="0" required="0">
	+<longdesc lang="en">
	+Table to be tested in monitor statement (in database.table notation)
	+</longdesc>
	+<shortdesc lang="en">MySQL test table</shortdesc>
	+<content type="string" default="mysql.user" />
	+</parameter>
	+
	+<parameter name="test_user" unique="0" required="0">
	+<longdesc lang="en">
	+MySQL test user
	+</longdesc>
	+<shortdesc lang="en">MySQL test user</shortdesc>
	+<content type="string" default="" />
	+</parameter>
	+
	+<parameter name="test_passwd" unique="0" required="0">
	+<longdesc lang="en">
	+MySQL test user password
	+</longdesc>
	+<shortdesc lang="en">MySQL test user password</shortdesc>
	+<content type="string" default="" />
	+</parameter>

	<parameter name="parameters" unique="0" required="0">
	<longdesc lang="en">
	The MySQL Proxy daemon may be called with additional parameters.
	Specify any of them here.
	</longdesc>
	<shortdesc lang="en">MySQL Proxy additional parameters</shortdesc>
	<content type="string" default="" />
	</parameter>

	<parameter name="pidfile" unique="1" required="0">
	<longdesc lang="en">PID file</longdesc>
	<shortdesc lang="en">PID file</shortdesc>
	<content type="string" default="${HA_RSCTMP}/mysql-proxy-${OCF_RESOURCE_INSTANCE}.pid" />
	</parameter>

	</parameters>

	<actions>
	<action name="start" timeout="30s" />
	<action name="stop" timeout="30s" />
	<action name="reload" timeout="30s" />
	<action name="monitor" depth="0" timeout="20s" interval="60s" />
	<action name="validate-all" timeout="30s" />
	<action name="meta-data" timeout="5s" />
	</actions>
	</resource-agent>
	END
	}

	isRunning()
	{
	kill -s 0 "$1" 2>/dev/null
	}

	mysqlproxy_status()
	{
	if [ -f "${pidfile}" ]; then
	# MySQL Proxy is probably running
	PID=`head -n 1 "${pidfile}"`
	if [ ! -z "$PID" ] ; then
	isRunning "$PID"
	- # @TODO in-depth check: issue a query and/or check proxy-admin interface
	return $?
	fi
	fi

	# MySQL Proxy is not running
	false
	}

	mysqlproxy_start()
	{
	# if MySQL Proxy is running return success
	if mysqlproxy_status ; then
	ocf_log info "MySQL Proxy already running."
	return $OCF_SUCCESS
	fi

	PARAM_PREFIX=''
	+
	+ # MySQL Proxy plugins to load
	+ # @TODO check if the plugins are actually available?
	+ if ocf_is_true $plugin_support; then
	+ for p in $plugins; do
	+ PARAM_PREFIX="$PARAM_PREFIX --plugins=$p"
	+ done
	+ fi
	+
	# check if the MySQL Proxy defaults-file exist
	if [ -f "$defaults_file" ]; then
	- PARAM_PREFIX="--defaults-file=$defaults_file "
	+ PARAM_PREFIX="$PARAM_PREFIX --defaults-file=$defaults_file"
	fi

	# set log-level
	if [ ! -z "$log_level" ]; then
	- PARAM_PREFIX="$PARAM_PREFIX --log-level=$log_level "
	+ PARAM_PREFIX="$PARAM_PREFIX --log-level=$log_level"
	fi

	# set keepalive
	if [ "$keepalive" = "true" ]; then
	- PARAM_PREFIX="$PARAM_PREFIX --keepalive "
	+ PARAM_PREFIX="$PARAM_PREFIX --keepalive"
	fi

	# honor admin_* options
	if [ ! -z "$admin_username" ]; then
	- PARAM_PREFIX="$PARAM_PREFIX --admin-username=$admin_username "
	+ PARAM_PREFIX="$PARAM_PREFIX --admin-username=$admin_username"
	fi
	if [ ! -z "$admin_password" ]; then
	- PARAM_PREFIX="$PARAM_PREFIX --admin-password=$admin_password "
	+ PARAM_PREFIX="$PARAM_PREFIX --admin-password=$admin_password"
	fi
	if [ ! -z "$admin_lua_script" ]; then
	- PARAM_PREFIX="$PARAM_PREFIX --admin-lua-script=$admin_lua_script "
	+ PARAM_PREFIX="$PARAM_PREFIX --admin-lua-script=$admin_lua_script"
	+ fi
	+
	+ # make sure that the pid directory exists
	+ pid_dir=`dirname $pidfile`
	+ if [ ! -d $pid_dir ] ; then
	+ ocf_log info "Creating PID directory '$pid_dir'."
	+ mkdir -p $pid_dir
	+ #chown $OCF_RESKEY_user:$OCF_RESKEY_group $pid_dir # c/p from mysql ra; currently not needed
	fi

	# split multiple proxy-address options.
	# currently unsupported but let us hope for the future ;)
	for pa in $proxy_address; do
	[ -z "$pa" ] && continue
	OPTIONS=" $OPTIONS --proxy-address=$pa"
	+
	+ # if $pa contains a slash, we are dealing with a socket
	+ # make sure that the socket directory exists
	+ if echo "$pa" \| grep -q '/' ; then
	+ socket_dir=`dirname $pa`
	+ if [ ! -d $socket_dir ] ; then
	+ ocf_log info "Creating socket directory '$socket_dir'."
	+ mkdir -p $socket_dir
	+ #chown $OCF_RESKEY_user:$OCF_RESKEY_group $socket_dir # c/p from mysql ra; currently not needed
	+ fi
	+ fi
	done

	# split multiple proxy-backend-addresses options.
	for pba in $proxy_backend_addresses; do
	[ -z "$pba" ] && continue
	OPTIONS=" $OPTIONS --proxy-backend-addresses=$pba"
	done

	# split multiple proxy-backend-addresses options.
	for proba in $proxy_read_only_backend_addresses; do
	[ -z "$proba" ] && continue
	OPTIONS=" $OPTIONS --proxy-read-only-backend-addresses=$proba"
	done

	- # build $OPTIONS and add addmin-address and pidfile
	+ # build $OPTIONS and add admin-address and pidfile
	OPTIONS="$PARAM_PREFIX $OPTIONS --admin-address=$admin_address --pid-file=${pidfile}"

	+ # add additional parameters
	+ if [ -n "$parameters" ]; then
	+ OPTIONS="$OPTIONS $parameters"
	+ fi
	+
	# start MySQL Proxy
	#start-stop-daemon --start --quiet --pidfile $pidfile --make-pidfile --name mysql-proxy --startas $binary -b -- $OPTIONS
	$binary --daemon $OPTIONS
	ret=$?

	if [ $ret -ne 0 ]; then
	ocf_log err "MySQL Proxy returned error." $ret
	return $OCF_ERR_GENERIC
	fi

	+ # @TODO add an initial monitoring action?
	+
	return $OCF_SUCCESS
	}


	mysqlproxy_stop()
	{
	if mysqlproxy_status ; then
	#start-stop-daemon --stop --quiet --retry 3 --exec $binary --pidfile $pidfile
	/bin/kill `cat "${pidfile}"`
	ret=$?

	if [ $ret -ne 0 ]; then
	ocf_log err "MySQL Proxy returned an error while stopping." $ret
	return $OCF_ERR_GENERIC
	fi

	# grant some time for shutdown and recheck
	sleep 1
	if mysqlproxy_status ; then
	ocf_log err "MySQL Proxy failed to stop."
	return $OCF_ERR_GENERIC
	fi

	# remove dangling socketfile, if specified
	for pa in $proxy_address; do
	if [ -S "$pa" ]; then
	ocf_log info "Removing dangling socket file '$pa'."
	rm -f "$pa"
	fi
	done

	# remove dangling pidfile
	if [ -f "${pidfile}" ]; then
	ocf_log info "Removing dangling pidfile '${pidfile}'."
	rm -f "${pidfile}"
	fi
	fi

	return $OCF_SUCCESS
	}

	mysqlproxy_reload()
	{
	if mysqlproxy_status; then
	ocf_log info "Reloading MySQL Proxy."
	kill -s HUP `cat ${pidfile}`
	fi
	}

	mysqlproxy_monitor()
	{
	+ local rc
	+ local mysql_options pa
	+ local mysql_server_parameter mysql_server_host mysql_server_port
	+
	if [ "${OCF_RESKEY_CRM_meta_interval:-0}" -eq "0" ]; then
	# in case of probe, monitor operation is surely treated as
	# under suspension. This will call start operation.
	# (c/p from ocf:heartbeat:sfex)
	mysqlproxy_validate_all
	rc=$?
	[ $rc -ne 0 ] && return $rc
	fi

	- if mysqlproxy_status ; then
	- return $OCF_SUCCESS
	+ if ! mysqlproxy_status ; then
	+ return $OCF_NOT_RUNNING
	fi

	- return $OCF_NOT_RUNNING
	+ if [ $OCF_CHECK_LEVEL -eq 20 -a -n "$OCF_RESKEY_test_table" ]; then
	+ mysql_options="--connect_timeout=10 --user=$OCF_RESKEY_test_user --password=$OCF_RESKEY_test_passwd"
	+
	+ # cycle each address
	+ for pa in $proxy_address; do
	+ # build correct connect parameter
	+ if [ -S "$pa" ]; then
	+ # we need to monitor a mysql socket
	+ mysql_server_parameter="--socket=$pa"
	+ else
	+ # we need to monitor a host address
	+ mysql_server_parameter=""
	+
	+ # split host:port
	+ # @TODO correctly handle IPv6 address
	+ # @TODO correctly handle 0.0.0.0 address
	+ mysql_server_host=`echo $pa \| cut -d : -f 1`
	+ mysql_server_port=`echo $pa \| cut -d : -f 2`
	+
	+ if [ -n $mysql_server_host ]; then
	+ mysql_server_parameter="$mysql_server_parameter --host=$mysql_server_host"
	+ fi
	+ if [ -n $mysql_server_port ]; then
	+ mysql_server_parameter="$mysql_server_parameter --port=$mysql_server_port"
	+ fi
	+ fi
	+
	+ # Check for test table
	+ ocf_run $mysql $mysql_server_parameter $mysql_options \
	+ -e "SELECT COUNT(*) FROM $OCF_RESKEY_test_table"
	+ rc=$?
	+
	+ if [ $rc -ne 0 ]; then
	+ ocf_log err "Failed to select from $OCF_RESKEY_test_table";
	+ return $OCF_ERR_GENERIC;
	+ fi
	+ done
	+
	+ fi
	+
	+ return $OCF_SUCCESS
	}

	mysqlproxy_validate_all()
	{
	+ # local variables
	+ local config_error=0
	+
	# check that the MySQL Proxy binary exists and can be executed
	- if [ ! -x "$binary" ]; then
	- ocf_log err "MySQL Proxy binary '$binary' does not exist or cannot be executed."
	- return $OCF_ERR_INSTALLED
	- fi
	+ check_binary $binary
	+ # @TODO skip the next test if OCF_CHECK_LEVEL == 0?
	+ check_binary $mysql

	# check for valid log-level
	- echo $log_level \| egrep "^(error\|warning\|info\|message\|debug\|)$" >/dev/null
	+ echo $log_level \| egrep -q "^(error\|warning\|info\|message\|debug\|)$"
	if [ $? -ne 0 ]; then
	ocf_log err "MySQL Proxy log level '$log_level' not in valid range error\|warning\|info\|message\|debug"
	return $OCF_ERR_CONFIGURED
	fi

	+
	+ # if we're running MySQL Proxy > 0.8.1 and there is any admin parameter set,
	+ # explicitly load the admin (and the proxy) plugin.
	+ # (version 0.8.2 does not load the admin plugin by default anymore)
	+ ocf_version_cmp "$version" "0.8.1"
	+ ret=$?
	+ if [ $ret -eq 2 ]; then
	+ # simple check: concat all parameters and check if the string has non-zero length
	+ if [ -n "$admin_username$admin_password$admin_lua_script$admin_address" ]; then
	+ plugins="proxy admin"
	+ has_plugin_admin=1
	+ else
	+ has_plugin_admin=0
	+ fi
	+ fi
	+
	+
	+ # check for required admin_* parameters for 0.8.1 and 0.8.2 (with admin module)
	+ # translated: if (version == 0.8.1 or (version > 0.8.1 and has_plugin_admin))
	+ if [ $ret -eq 1 -o $ $ret -eq 2 -a $has_plugin_admin -eq 1 $ ]; then
	+ if [ -z "$admin_username" ]; then
	+ ocf_log err "Missing required parameter \"admin_username\""
	+ config_error=1
	+ fi
	+ if [ -z "$admin_password" ]; then
	+ ocf_log err "Missing required parameter \"admin_password\""
	+ config_error=1
	+ fi
	+ if [ -z "$admin_lua_script" ]; then
	+ ocf_log err "Missing required parameter \"admin_lua_script\""
	+ config_error=1
	+ fi
	+
	+ # check if the admin_lua_script, if specified, exists
	+ if [ -n "$admin_lua_script" -a ! -e "$admin_lua_script" ]; then
	+ ocf_log err "MySQL Proxy admin lua script '$admin_lua_script' does not exist or is not readable."
	+ fi
	+ fi
	+
	+ # issue a warning during start if the user wants to load a plugin
	+ # but this version of MySQL Proxy does not support the plugin architecture.
	+ if [ -n "$plugins" ] && ocf_is_false "$plugin_support" && [ $__OCF_ACTION = 'start' ]; then
	+ ocf_log warn "You are running MySQL Proxy version '$version'. This version does not support the plugin architecture. Please use version 0.7.0 or later to load the plugins '$plugins'."
	+ fi
	+
	+ # exit in case we have found relevant config errors
	+ if [ $config_error -eq 1 ]; then
	+ exit $OCF_ERR_CONFIGURED
	+ fi
	+
	return $OCF_SUCCESS
	}

	#
	# Main
	#

	if [ $# -ne 1 ]; then
	usage
	exit $OCF_ERR_ARGS
	fi

	pidfile=$OCF_RESKEY_pidfile
	binary=$OCF_RESKEY_binary
	defaults_file=$OCF_RESKEY_defaults_file
	proxy_backend_addresses=$OCF_RESKEY_proxy_backend_addresses
	proxy_read_only_backend_addresses=$OCF_RESKEY_proxy_read_only_backend_addresses
	admin_address=$OCF_RESKEY_admin_address
	admin_username=$OCF_RESKEY_admin_username
	admin_password=$OCF_RESKEY_admin_password
	admin_lua_script=$OCF_RESKEY_admin_lua_script
	proxy_address=$OCF_RESKEY_proxy_address
	log_level=$OCF_RESKEY_log_level
	keepalive=$OCF_RESKEY_keepalive
	+plugins=`echo $OCF_RESKEY_plugins \| tr "[:space:]" "\n" \| sort -u`
	+mysql=$OCF_RESKEY_client_binary
	+parameters=$OCF_RESKEY_parameters
	+plugin_support=false
	+has_plugin_admin=0 # 0 because this simplifies the if statements

	# debugging stuff
	#echo OCF_RESKEY_binary=$OCF_RESKEY_binary >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_defaults_file=$OCF_RESKEY_defaults_file >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_proxy_backend_addresses=$OCF_RESKEY_proxy_backend_addresses >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_proxy_read_only_backend_addresses=$OCF_RESKEY_proxy_read_only_backend_addresses >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_proxy_address=$OCF_RESKEY_proxy_address >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_log_level=$OCF_RESKEY_log_level >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_keepalive=$OCF_RESKEY_keepalive >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_admin_address=$OCF_RESKEY_admin_address >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_admin_username=$OCF_RESKEY_admin_username >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_admin_password=$OCF_RESKEY_admin_password >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_admin_lua_script=$OCF_RESKEY_admin_lua_script >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_parameters=$OCF_RESKEY_parameters >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE
	#echo OCF_RESKEY_pidfile=$OCF_RESKEY_pidfile >> /tmp/prox_conf_$OCF_RESOURCE_INSTANCE


	+# handle some parameters before performing any additional checks
	+case $1 in
	+ meta-data) meta_data
	+ exit $?
	+ ;;
	+
	+ usage) usage
	+ exit $OCF_SUCCESS
	+ ;;
	+esac
	+
	+
	+# determine MySQL Proxy version
	+check_binary $binary
	+version=`$binary --version \| grep ^mysql-proxy \| awk '{print $NF}'`
	+
	+# version 0.7.0 (and later) support the plugin architecture and load the admin plugin by default
	+# version 0.8.1 loads admin plugin by default and requires the admin parameters to be set
	+# version 0.8.2 does not load the admin plugin by default anymore
	+ocf_version_cmp "$version" "0.7.0"
	+ret=$?
	+if [ $ret -eq 1 -o $ret -eq 2 ]; then
	+ plugin_support=true
	+ has_plugin_admin=1
	+fi
	+
	+
	+# perform action
	case $1 in
	start) mysqlproxy_validate_all &&
	mysqlproxy_start
	exit $?
	;;

	stop) mysqlproxy_validate_all &&
	mysqlproxy_stop
	exit $?
	;;

	reload) mysqlproxy_reload
	exit $?
	;;

	status) if mysqlproxy_status; then
	ocf_log info "MySQL Proxy is running."
	exit $OCF_SUCCESS
	else
	ocf_log info "MySQL Proxy is stopped."
	exit $OCF_NOT_RUNNING
	fi
	;;

	monitor) mysqlproxy_monitor
	exit $?
	;;

	validate-all) mysqlproxy_validate_all
	exit $?
	;;

	- meta-data) meta_data
	- exit $?
	- ;;
	-
	- usage) usage
	- exit $OCF_SUCCESS
	- ;;

	*) usage
	exit $OCF_ERR_UNIMPLEMENTED
	;;
	esac
	diff --git a/tools/ocft/mysql-proxy b/tools/ocft/mysql-proxy
	new file mode 100644
	index 000000000..436e7a3a0
	--- /dev/null
	+++ b/tools/ocft/mysql-proxy
	@@ -0,0 +1,82 @@
	+# mysql-proxy
	+# by r.bhatia@ipax.at
	+#
	+# test cases (to implement):
	+#
	+# * /usr/sbin/ocf-tester -n mp -o binary="/usr/sbin/mysql-proxy" -o defaults_file="" -o parameters="--proxy-skip-profiling" \
	+# -o admin_address="127.0.0.1:4041" -o admin_username="root" -o admin_password="la" -o admin_lua_script="/usr/lib/mysql-proxy/lua/admin.lua" \
	+# -o proxy_backend_addresses="192.168.100.200:42006" -o proxy_address="/var/run/mysqld/mysqld.sock" /usr/lib/ocf/resource.d/heartbeat/mysql-proxy
	+#
	+# * OCF_CHECK_LEVEL 20 check
	+
	+CONFIG
	+ AgentRoot /usr/lib/ocf/resource.d/heartbeat/
	+ InstallPackage mysql-proxy
	+ HangTimeout 20
	+
	+SETUP-AGENT
	+ # nothing
	+
	+CASE-BLOCK crm_setting
	+ Var OCF_RESKEY_CRM_meta_timeout=15000
	+ Var OCF_RESKEY_binary=/tmp/mysql-proxy
	+ Var OCF_RESKEY_admin_username=root
	+ Var OCF_RESKEY_admin_password=test123
	+ Var OCF_RESKEY_admin_lua_script=/usr/lib/mysql-proxy/lua/admin.lua
	+
	+CASE-BLOCK default_status
	+ AgentRun stop
	+
	+CASE-BLOCK prepare
	+ Bash [ ! -x /tmp/mysql-proxy ] && ln -s `which mysql-proxy` /tmp/mysql-proxy \|\| true
	+ Include crm_setting
	+
	+CASE-BLOCK teardown
	+ AgentRun stop
	+ BashAtExit rm -f /tmp/mysql-proxy
	+
	+CASE "check base env"
	+ Include prepare
	+ AgentRun start OCF_SUCCESS
	+ Include teardown
	+
	+CASE "check base env: invalid 'OCF_RESKEY_binary'"
	+ Include prepare
	+ Var OCF_RESKEY_binary=no_such
	+ AgentRun start OCF_ERR_INSTALLED
	+ BashAtExit rm -f /tmp/mysql-proxy
	+
	+CASE "normal start"
	+ Include prepare
	+ AgentRun start OCF_SUCCESS
	+ Include teardown
	+
	+CASE "normal stop"
	+ Include prepare
	+ AgentRun start
	+ AgentRun stop OCF_SUCCESS
	+ Include teardown
	+
	+CASE "double start"
	+ Include prepare
	+ AgentRun start
	+ AgentRun start OCF_SUCCESS
	+ Include teardown
	+
	+CASE "double stop"
	+ Include prepare
	+ AgentRun stop OCF_SUCCESS
	+
	+CASE "running monitor"
	+ Include prepare
	+ AgentRun start
	+ AgentRun monitor OCF_SUCCESS
	+ Include teardown
	+
	+CASE "not running monitor"
	+ Include prepare
	+ AgentRun monitor OCF_NOT_RUNNING
	+
	+CASE "unimplemented command"
	+ Include prepare
	+ AgentRun no_cmd OCF_ERR_UNIMPLEMENTED

File Metadata

Mime Type: text/x-diff
Expires: Thu, Jul 10, 1:18 AM (13 h, 48 m)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1983159
Default Alt Text: (27 KB)

No OneTemporaryActions

View Options

File Metadata

Event Timeline

No OneTemporary
Actions