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_log=string] [OCF_RESKEY_pid=string] [OCF_RESKEY_socket=string] [OCF_RESKEY_test_table=string] [OCF_RESKEY_test_user=string] [OCF_RESKEY_test_passwd=string] [OCF_RESKEY_enable_creation=integer] [OCF_RESKEY_additional_parameters=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_log=MySQL log file

The logfile to be used for mysqld.

OCF_RESKEY_pid=MySQL pid file

The pidfile to be used for mysqld.

OCF_RESKEY_socket=MySQL socket

The socket to be used for mysqld.

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

OCF_RESKEY_additional_parameters=Additional paramters to pass to mysqld

Additional parameters which are passed to the mysqld on startup. (e.g. --skip-external-locking or --skip-grant-tables)