Considerations on MySQL use in systemd Environments

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.

*Notes: The setting of “Location of my.cnf” is used inside LifeKeeper to read the settings in my.cnf. The value set up here is not used by the systemctl startup command. In the case where the my.cnf file is in a different path from the default, set up MySQL for Systemd correctly and make sure the MySQL service starts and stops as expected. Also, the “include” directive is not supported. All the configuration information must be described in a single my.cnf file.