table of contents
other versions
conflicting packages
OCF_HEARTBEAT_MYSQL(7) | OCF resource agents | OCF_HEARTBEAT_MYSQL(7) |
NAME¶
ocf_heartbeat_mysql - Manages a MySQL database instanceSYNOPSIS¶
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¶
binaryLocation of the MySQL binary (optional,
string, default /usr/bin/mysqld_safe)
config
Configuration file (optional, string, default
/etc/mysql/my.cnf)
datadir
Directory containing databases (optional,
string, default /var/lib/mysql)
user
User running MySQL daemon (optional, string,
default mysql)
group
Group running MySQL daemon (for logfile and
directory permissions) (optional, string, default mysql)
log
The logfile to be used for mysqld. (optional,
string, default /var/log/mysql.log)
pid
The pidfile to be used for mysqld. (optional,
string, default /var/run/mysqld/mysqld.pid)
socket
The socket to be used for mysqld. (optional,
string, default /var/run/mysqld/mysqld.sock)
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, default
root)
test_passwd
MySQL test user password (optional, string, no
default)
enable_creation
If the MySQL database does not exist, it will
be created (optional, integer, default 0)
additional_parameters
Additional parameters which are passed to the
mysqld on startup. (e.g. --skip-external-locking or --skip-grant-tables)
(optional, string, no default)
SUPPORTED ACTIONS¶
This resource agent supports the following actions (operations): startStarts the resource. Suggested minimum
timeout: 120.
stop
Stops the resource. Suggested minimum timeout:
120.
status
Performs a status check. Suggested minimum
timeout: 60.
monitor
Performs a detailed status check. Suggested
minimum timeout: 30. Suggested interval: 10.
validate-all
Performs a validation of the resource
configuration. Suggested minimum timeout: 5.
meta-data
Retrieves resource agent metadata (internal
use only). Suggested minimum timeout: 5.
EXAMPLE¶
The following is an example configuration for a mysql resource using the crm(8) shell:primitive example_mysql ocf:heartbeat:mysql \ op monitor depth="0" timeout="30" interval="10"
SEE ALSO¶
AUTHOR¶
Linux-HA contributors (see the resource agent source for information about individual authors)02/03/2011 | resource-agents 1.0.3 |