Preparing MySQL for Pacemaker high availability

In order for Pacemaker monitoring to function properly, you must ensure that MySQL’s database files reside on the DRBD device. If you already have an existing MySQL database, the simplest approach is to just move the contents of the existing /var/lib/mysql directory into the newly created filesystem on the DRBD device.

	Warning
	You must complete the next step while the MySQL database server is shut down.

node1:# mount /dev/drbd/by-res/mysql /mnt
node1:# mv /var/lib/mysql/* /mnt
node1:# umount /mnt

For a new MySQL installation with no existing data, you may also run the mysql_install_db command:

node1:# mount /dev/drbd/by-res/mysql /mnt
node1:# mysql_install_db --datadir=/mnt
node1:# umount /mnt

Regardless of the approach, the steps outlined here must be completed on only one cluster node.