New Percona instructions
Posted: Thu Jun 01, 2017 6:52 pm
Hey y'all, I had to put this out there. The Percona instructions for:
Ubuntu 16.04 need to be changed/modified
I have gone through 2 complete re-installs of the OS due to slight issues. I also suggest that this be done on a new install of Vesta.
Ubuntu 16 aka Xenial installs php 7 and MySQL 5.7 <- that's important to remember. VestaCP instructions call for 5.5 on percona. Well, 5.5 and 5.7 have so many changes it's not even funny. This was the cause of numerous headaches. Oh, and the gpg key needs to be changed/updated. Here's how:
Assuming your root (if not add sudo before all commands)
1. Start with the GPG key
2.Add percona Repo
3. Install Percona 5.7 <- very important, 5.5 will give massive headaches and will not start correctly if at all
During the install it will ask for the root mysql password. If you don't want to change it, don't enter anything, just press enter. It will ask at least twice.
Then at the end of the install, it will tell your to run commands such as:
These are nothing more than useful functions from the Percona Toolkit. It doesn't hurt anything to run the commands.
4.Finally, update the rc
If you've had no problems to this point, congrats, it's installed. Lets check it:
or
As long as it's running, it's installed perfectly fine. Your good to go, congrats on swapping to Percona.
Ubuntu 16.04 need to be changed/modified
I have gone through 2 complete re-installs of the OS due to slight issues. I also suggest that this be done on a new install of Vesta.
Ubuntu 16 aka Xenial installs php 7 and MySQL 5.7 <- that's important to remember. VestaCP instructions call for 5.5 on percona. Well, 5.5 and 5.7 have so many changes it's not even funny. This was the cause of numerous headaches. Oh, and the gpg key needs to be changed/updated. Here's how:
Assuming your root (if not add sudo before all commands)
1. Start with the GPG key
Code: Select all
user@server: apt-key adv --keyserver keys.gnupg.net --recv-keys 8507EFA5
Code: Select all
user@server: echo "deb http://repo.percona.com/apt xenial main" >> /etc/apt/sources.list
user@server: echo "deb-src http://repo.percona.com/apt xenial main" >> /etc/apt/sources.list
Code: Select all
user@server: apt-get update
user@server: apt-get install percona-server-server-5.7 percona-server-client-5.7 -y
user@server: apt-get autoremove -y
user@server: apt-get clean all
Then at the end of the install, it will tell your to run commands such as:
Code: Select all
user@server: mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
user@server: mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
user@server: mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
4.Finally, update the rc
Code: Select all
user@server: update-rc.d mysql default
Code: Select all
user@server: systemctl status mysql
Code: Select all
user@server: service mysql status