Name

ocf:mysql — MySQL resource agent

Synopsis

[OCF_RESKEY_binary=string] [OCF_RESKEY_config=string] [OCF_RESKEY_datadir=string] [OCF_RESKEY_user=string] [OCF_RESKEY_group=string] [OCF_RESKEY_test_table=string] [OCF_RESKEY_test_user=string] [OCF_RESKEY_test_passwd=string] [OCF_RESKEY_enable_creation=integer] mysql [start | stop | status | monitor | validate-all | meta-data]

Description

Resource script for MySQL. It manages a MySQL Database instance as an HA resource.

Supported Parameters

OCF_RESKEY_binary=MySQL binary

Location of the MySQL binary

OCF_RESKEY_config=MySQL config

Configuration file

OCF_RESKEY_datadir=MySQL datadir

Directory containing databases

OCF_RESKEY_user=MySQL user

User running MySQL daemon

OCF_RESKEY_group=MySQL group

Group running MySQL daemon (for logfile and directory permissions)

OCF_RESKEY_test_table=MySQL test table

Table to be tested in monitor statement (in <database>.<table> notation)

OCF_RESKEY_test_user=MySQL test user

MySQL test user

OCF_RESKEY_test_passwd=MySQL test user password

MySQL test user password

OCF_RESKEY_enable_creation=Create the database if it does not exist

If the MySQL database does not exist, it will be created


SUSE Linux Enterprise Server Heartbeat Guide 10 SP1