how-to replacing mysql/mariadb by percona

[jodumont]

So;
I'm using more and more percona
and when I tried this how to https://vestacp.com/docs/#how-to-instal ... ian-ubuntu

I tried through a copy of my prod LXC and also on a brand new install VestaCP inside a VM; but always on Debian 9 and systematically I had this issue :

the installation of percona won't finish
It will ask for a fix-broken which will still be broken

So on the brand new installation; I resolve it like this

1. remove mariadb

Code: Select all

apt remove --purge -y mariadb*

2. install percona

Code: Select all

curl -fsSLo /tmp/percona.deb https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i /tmp/percona.deb
apt update
lastPercona=$(apt search percona-server-server-|grep "percona-server-server-"|cut -d'/' -f1|tail -1|rev|cut -d- -f1|rev)
apt install -y percona-server-server-$lastPercona percona-server-client-$lastPercona
update-rc.d mysql defaults

than with this I'm able to use create database via VestaCP UI

To be safe; in production; I would backup my database than restore them after.


o BTW; if you decide and/or define a new password when you install percona you must udpate the info into : /usr/local/vesta/conf/mysql.conf
to keep the vestacp webui working
also might worth to change it inside /root/.my.cnf too