Man Linux: Main Page and Category List

NAME

       ocf_heartbeat_mysql - Manages a MySQL database instance

SYNOPSIS

       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

       http://www.linux-ha.org/wiki/mysql_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information
       about individual authors)