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

Reply via email to