Public bug reported:
Seems like Systemd and Percona XtraDB Cluster don't like to play together in 16.04. There are multiple issues: 1. There is no way to "bootstrap-pxc" using systemctl and when I use "/etc/init.d/mysql bootstrap-pxc", then even though mysql is running, systemd doesn't think it is. See https://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/bootstrap.html for more info. Demonstration: root@sql1:~# ps ax | grep mysql 1428 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --wsrep-new-cluster 1902 pts/0 Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/percona-xtradb-cluster --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep-new-cluster --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=de1c3153-1c83-11e6-94af-63e494c70dbe:6 1997 pts/0 S+ 0:00 grep --color=auto mysql root@sql1:~# /etc/init.d/mysql status ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: inactive (dead) Docs: man:systemd-sysv-generator(8) root@sql1:~# systemctl status mysql ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: inactive (dead) Docs: man:systemd-sysv-generator(8) root@sql1:~# 2. There is no way to gracefully kill this mysql process: Demonstration: root@sql1:~# /etc/init.d/mysql stop [ ok ] Stopping mysql (via systemctl): mysql.service. root@sql1:~# systemctl stop mysql root@sql1:~# ps ax | grep mysql 1428 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --wsrep-new-cluster 1902 pts/0 Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/percona-xtradb-cluster --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep-new-cluster --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=de1c3153-1c83-11e6-94af-63e494c70dbe:6 2133 pts/0 S+ 0:00 grep --color=auto mysql Environment: Ubuntu Server 16.04 LTS I installed XtraDB Cluster using "apt-get -yq install percona-xtradb-cluster-server" ** Affects: percona-xtradb-cluster-5.6 (Ubuntu) Importance: Undecided Status: New ** Tags: pxc -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1583000 Title: Systemd issues with percona-xtradb-cluster-5.6 package To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.6/+bug/1583000/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs