Rechercher une page de manuel
ocf_heartbeat_mysql
Langue: en
Version: 06/26/2010 (ubuntu - 25/10/10)
Section: 7 (Divers)
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
binary
- Location of the MySQL binary (optional, string, default /usr/bin/safe_mysqld)
config
- Configuration file (optional, string, default /etc/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/mysqld.log)
pid
- The pidfile to be used for mysqld. (optional, string, default /var/run/mysql/mysqld.pid)
socket
- The socket to be used for mysqld. (optional, string, default /var/lib/mysql/mysql.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):
start
- Starts 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
m[blue]http://www.linux-ha.org/wiki/mysql_(resource_agent)m[]
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre