Upgrade MariaDB 5.5 to 10.1 on CentOS 7 Plesk Server

EDIT 2022-05: Now Plesk has an easy MySQL upgrade script, to do the upgrade, run

wget https://support.plesk.com/hc/en-us/article_attachments/4584125667858/c7-mariadb-10.5-upgrade.sh && chmod +x c7-mariadb-10.5-upgrade.sh
./c7-mariadb-10.5-upgrade.sh

For more information, see

https://support.plesk.com/hc/en-us/articles/12388091703703

CentOS 7 Plesk Server come with MariaDB 5.5

[root@224 ~]# mysql --version
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1
[root@224 ~]# 

The rpm packages installed where

[root@224 ~]# rpm -qa | grep -i maria
mariadb-libs-5.5.60-1.el7_5.x86_64
sw-mariadb-client-1.0.0-centos7.17031417.x86_64
mariadb-server-5.5.60-1.el7_5.x86_64
mariadb-5.5.60-1.el7_5.x86_64
[root@224 ~]# 

To upgrade MariaDB, first take a backup of all databases.

mysqldump -u admin -p`cat /etc/psa/.psa.shadow` --all-databases --routines --triggers > /root/all-databases.sql

Stop MariaDB databases

service mariadb stop

Make another backup of data files

cp -a /var/lib/mysql/ /var/lib/mysql_backup

Create file

vi /etc/yum.repos.d/MariaDB.repo

Add following content

[mariadb]
name = MariaDB 
baseurl = http://yum.mariadb.org/10.1/centos7-amd64 
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB 
gpgcheck = 1

Now run

yum install MariaDB-client MariaDB-server

This will upgrade your MariaDB 5.5 to MariaDB 10.1

Start MariaDB

service mariadb start

At this point, you have newer MariaDB 10.1

[root@224 ~]# mysql --version
mysql  Ver 15.1 Distrib 10.1.36-MariaDB, for Linux (x86_64) using readline 5.1
[root@224 ~]# 

You need to upgrade databases, for this, run

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

Restart MariaDB

service mariadb restart

update the package version inside Plesk

plesk sbin packagemng -sdf

Remove old MySQL symlink

rm -f /etc/init.d/mysql
systemctl daemon-reload

Back to Plesk