Disabling AppArmor for installing PXC on ubuntu 16.04

[tom256]

@lorraine.pocklington;52415

Hello there Tom

Yes the original install failed which can be seen from this:

Yes, As I’ve mentioned before there was a packages conflict in for writing in ‘/usr/share/man/man1/mysqlman.1.gz’
I’ve solved this problem by “–force-overwrite”
[PHP]sudo apt-get -o Dpkg::Options::=“–force-overwrite” install percona-xtradb-cluster-57[/PHP]

@lorraine.pocklington;52415

The team here say that it looks like on that node you have the mysql-client installed, and this conflicts with Percona XtraDB Cluster.

Yes, I think so, the vestacp may installed it before. By the way being mysql-client installed or not is something PXC installation process must check it before installing anything.
Please tell the team to check it, Can they install PXC on a vestacp server?

@lorraine.pocklington;52416

You can’t have Oracle MySQL and Percona XtraDB Cluster code resident on the same machine, and this may have been the start of your issues here.

Now phpMyAdmin shows me I’m using Percona Server, So I don’t think I’m using MySQL anymore, Is there any way to fix this single node and use it again? for example by using:
[PHP]SET GLOBAL pxc_strict_mode=MASTER;[/PHP]

@lorraine.pocklington;52416

I will refer the documentation / advice about AppArmor to the team for review, to see if there is more clarity we can add there.

I fixed the AppArmor issue by this commands:

sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/

sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld

Only disabling MySQL profile is better than removing the whole AppArmor which was mentioned in PXC’s installation tutorial!