Plesk Panel Upgrade to MariaDB 10.6

  • 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

    Code
    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

    Code
    service mariadb stop

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

    Code
    yum remove mariadb-gssapi-server -y

    4- Let's backup the database directory anyway

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

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

    Code
    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

    Code
    sudo yum install MariaDB-server MariaDB-backup -y

    7-Start MariaDB service and upgrade MySQL databases

    Code
    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

    Code
    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!