Location of the MySQL server binary

(optional, string, no default)

Location of the MySQL client binary

(optional, string, no default)

Configuration file

(optional, string, no default)

Directory containing databases

(optional, string, no default)

User running MySQL daemon

(optional, string, no default)

Group running MySQL daemon (for logfile and directory permissions)

(optional, string, no default)

The logfile to be used for mysqld.

(optional, string, no default)

The pidfile to be used for mysqld.

(optional, string, no default)

The socket to be used for mysqld.

(optional, string, no default)

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

(optional, boolean, default false)

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

(optional, string, no default)

The galera cluster address. This takes the form of: gcomm://node,node,node

Only nodes present in this node list will be allowed to start a galera instance. The galera node names listed in this address are expected to match valid pacemaker node names. If both names need to differ, you must provide a mapping in option cluster_host_map.

(required, string, no default)

A mapping of pacemaker node names to galera node names.

To be used when both pacemaker and galera names need to differ, (e.g. when galera names map to IP from a specific network interface) This takes the form of: pcmk1:node.1.galera;pcmk2:node.2.galera;pcmk3:node.3.galera

where the galera resource started on node pcmk1 would be named node.1.galera in the wsrep_cluster_address

(optional, string, no default)

Cluster check user.

(optional, string, no default)

Cluster check user password. Empty passwords are ignored unless the parameter "check_passwd_use_empty" is set to 1.

(optional, string, no default)

Use an empty "check_passwd" password. If this parameter is set to 1, "check_passwd" will be ignored and an empty password is used when calling the "mysql" client binary.

(optional, boolean, default 0)

If running in a 2-node pacemaker cluster, rely on pacemaker quorum to allow automatic recovery even when the other node is unreachable. Use it with caution! (and fencing)

(optional, boolean, default false)

Starts the resource. Suggested minimum timeout: 120s.

Stops the resource. Suggested minimum timeout: 120s.

Performs a status check. Suggested minimum timeout: 60s.

Performs a detailed status check. Suggested minimum timeout: 30s. Suggested interval: 20s.

Performs a detailed status check. Suggested minimum timeout: 30s. Suggested interval: 10s.

Performs a detailed status check. Suggested minimum timeout: 30s. Suggested interval: 30s.

Promotes the resource to the Master role. Suggested minimum timeout: 300s.

Demotes the resource to the Slave role. Suggested minimum timeout: 120s.

Performs a validation of the resource configuration. Suggested minimum timeout: 5s.

Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s.

primitive p_galera ocf:heartbeat:galera \


  params \


    wsrep_cluster_address=string \


  op monitor depth="0" timeout="30s" interval="20s" \


  op monitor role="Master" depth="0" timeout="30s" interval="10s" \


  op monitor role="Slave" depth="0" timeout="30s" interval="30s" 

ms ms_galera p_galera \


  meta notify="true" interleave="true"

pcs resource create p_galera ocf:heartbeat:galera \


  wsrep_cluster_address=string \


  op monitor OCF_CHECK_LEVEL="0" timeout="30s" interval="20s" \


  op monitor role="Master" OCF_CHECK_LEVEL="0" timeout="30s" interval="10s" \


  op monitor role="Slave" OCF_CHECK_LEVEL="0" timeout="30s" interval="30s" promotable