Percona MySQL server 5.6 re-enables systemd service on yum update

[Nick Abbott]

Apologies if this is the incorrect section to raise bugs for Percona MySQL server 5.6 - I've not been able to find a more appropriate section. If this is the incorrect place, please re-direct me to the correct place.

We run Percona MySQL in a cluster so the service is disabled in systemd and managed by Pacemaker:

[root@BCF-WEBDB-01 ~]# systemctl list-unit-files | grep sql
mysqld.service disabled

When we updated Percona-Server-server-56.x86_64 on CentOS 7:

[root@159 ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)

the mysql service was re-enabled.

[root@BCF-WEBDB-01 ~]# systemctl list-unit-files | grep sql
mysql.service enabled
mysqld.service enabled

Is this desired behaviour? We can't find any other packages that exhibit this behaviour.

This caused MySQL to start outside the cluster the next time the server was booted.

Regards,

Nick

[root@BCF-WEBDB-02 ~]# rpm -qi Percona-Server-server-56-5.6.35-rel80.0.el7.x86_64
Name : Percona-Server-server-56
Version : 5.6.35
Release : rel80.0.el7
Architecture: x86_64
Install Date: Thu 23 Mar 2017 09:22:25 GMT
Group : Applications/Databases
Size : 92124644
License : Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Under the GNU General Public License (http://www.gnu.org/licenses/).
Signature : DSA/SHA1, Fri 03 Feb 2017 08:16:04 GMT, Key ID 1c4cbdcdcd2efd2a
Source RPM : Percona-Server-56-5.6.35-rel80.0.el7.src.rpm
Build Date : Fri 03 Feb 2017 08:14:29 GMT
Build Host : vps-centos7-x64-04.ci.percona.com
Relocations : (not relocatable)
Packager : Percona MySQL Development Team <email address hidden>
Vendor : Percona, Inc
URL : http://www.percona.com/
Summary : Percona Server: a very fast and reliable SQL database server
Description :
The Percona Server software delivers a very fast, multi-threaded, multi-user,
and robust SQL (Structured Query Language) database server. Percona Server
is intended for mission-critical, heavy-load production systems.

Percona recommends that all production deployments be protected with a support
contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime,
be eligible for hot fixes, and boost your team's productivity.

This package includes the Percona Server with XtraDB binary
as well as related utilities to run and administer Percona Server.

If you want to access and work with the database, you have to install
package "Percona-Server-client-56" as well!

[Jericho Rivera (jericho-rivera)]

Confirmed as described when upgrading to PS 5.6.35

[Jericho Rivera (jericho-rivera)]

Can't test with MySQL Community 5.6, but on upstream 5.7 upgrading to latest 5.7.17 from previous 5.7 will enable systemd mysqld.service when it is originally disabled.

[Laurynas Biveinis (laurynas-biveinis)]

Jericho, please set 5.5/5.7 bug status

[Jericho Rivera (jericho-rivera)]

Confirmed on both 5.5 and 5.7 as well.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1083