Plesk Panel Upgrade to MariaDB 10.6

MariaDB, as a high-performance and reliable database management system, is widely used to meet the database needs of web applications. New versions of MariaDB provide developers and system administrators with the possibility to increase the efficiency of their projects by offering better performance, enhanced security and new features. In this guide, we will explain step by step how to upgrade to MariaDB 10.6 for users using Plesk Panel. You can follow this guide to have a better experience in database management by taking advantage of the new features offered by MariaDB 10.6.

AlmaLinux 9 Plesk Panel Upgrade to MariaDB 10.6

NOTE: Don't forget to take a backup!

1- Backup our database tables

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-databases.sql

2- Let's stop MariaDB service

service mariadb stop

3- Delete packages that conflict with the current version from the server

yum remove mariadb-gssapi-server -y

4- Let's backup the database directory anyway

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

5- Let's add the repos for MariaDB 10.6 and start the installation

sudo yum install wget -y
wget https://r.mariadb.com/downloads/mariadb_repo_setup
echo "935944a2ab2b2a48a47f68711b43ad2d698c97f1c3a7d074b34058060c2ad21b mariadb_repo_setup" \ | sha256sum -c -
chmod +x mariadb_repo_setup
sudo ./mariadb_repo_setup \ --mariadb-server-version="mariadb-10.6"

Run the above commands in sequence.

6- Install MariaDB Community Server and package dependencies

sudo yum install MariaDB-server MariaDB-backup -y

7-Start MariaDB service and upgrade MySQL databases

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

Run the above commands in sequence.

8- Upgrade package versions for Plesk

plesk bin service_node --update local
plesk sbin packagemng -sdf
restorecon -v /var/lib/mysql/*

Run the above commands in sequence.

In this guide, we explained step by step how you can upgrade to MariaDB 10.6 on Plesk Panel. Upgrading is an important step to improve database performance and security. Thanks to the new features and improvements offered by MariaDB 10.6, you can have a more effective and efficient experience in database management. By learning about the problems and solutions you may encounter during the upgrade process, it is possible to make a smooth transition. You can start following these steps to explore the new MariaDB version and take advantage of the benefits of using it in your projects. If you encounter any problems, you can get support from the MariaDB and Plesk communities.