If MySQL (version 5.7.6 or later) is installed on a OS distribution adopting systemd, the mysqld_safe and mysqld_multi commands are not installed and thus unavailable for LifeKeeper use. In these environments, LifeKeeper will use the systemctl command to start and stop the MySQL service.
Set up MySQL referring to the article Managing MySQL Server with systemd. Specially set up the PID File as this is required for Systemd and LifeKeeper. Systemd MySQL set up and my.cnf set up must be the same on all nodes.
The following set up items must be defined for resource creation.
|Location of my.cnf||The full path of the directory that contains the my.cnf file used when starting the MySQL service with the systemctl command|
|Location of MySQL executables||The full path of the directory where the mysqladmin command is installed|