CentOS 7 Plesk Server come with MariaDB 5.5
1
2
3
|
[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
1
2
3
4
5
6
|
[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.
1
|
mysqldump -u admin -p`cat /etc/psa/.psa.shadow` --all-databases --routines --triggers > /root/all-databases.sql
|
Stop MariaDB databases
1
|
service mariadb stop
|
Make another backup of data files
1
|
cp -a /var/lib/mysql/ /var/lib/mysql_backup
|
Create file
1
|
nano /etc/yum.repos.d/MariaDB.repo
|
Add following content
1
2
3
4
5
|
[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
1
|
yum install MariaDB-client MariaDB-server
|
This will upgrade your MariaDB 5.5 to MariaDB 10.1
Start MariaDB
1
|
service mariadb start
|
At this point, you have newer MariaDB 10.1
1
2
3
|
[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
1
|
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
|
Restart MariaDB
1
|
service mariadb restart
|
update the package version inside Plesk
1
|
plesk sbin packagemng -sdf
|
Remove old MySQL symlink
1
2
|
rm -f /etc/init.d/mysql
systemctl daemon-reload
|