how-to replacing mysql/mariadb by percona
Posted: Fri Oct 05, 2018 8:38 am
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 :
1. remove mariadb
2. install percona
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
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 :
So on the brand new installation; I resolve it like thisthe installation of percona won't finish
It will ask for a fix-broken which will still be broken
1. remove mariadb
Code: Select all
apt remove --purge -y mariadb*
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
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