Articles in this section

How to upgrade MariaDB on Plesk for Linux

Leo Mastropierro

Updated March 26, 2026 07:31

kb: how-to Plesk for Linux ABT: Group B

Applicable to:

Plesk for Linux

Question

How to upgrade MariaDB on Plesk for Linux?

Answer

In Plesk Obsidian 18.0.60 we have released our new tool in beta test to upgrade MariaDB to a supported LTS branch via Plesk User Interface. It checks configuration, performs DB backup, configures MariaDB package repositories, performs the upgrade, and runs necessary post-upgrade actions.

Starting from Plesk Obsidian 18.0.71, the feature is available for all Plesk Obsidian servers

Plesk UI

Note: This automatic tool is not available on CloudLinux. For this operating system proceed to the "Manual procedure".

Login to Plesk UI as admin.
Go to Tools & Settings > Database Servers page:
Click the "Upgrade now" button.
Feedback about this feature can be left using the following link.

Manual procedure

This section provides manual instructions for upgrading MySQL 5.5 to 5.6/5.7 and MariaDB 5.5 to 10.0/10.1/10.2/10.3/10.4/10.5/10.6/10.11/11.4 on Linux.

Note: Upgrade can be performed in a command-line interface with the instructions below at your own risk. This task is supposed to be performed by a system administrator.
If you are not familiar with Linux system administration and would like our professionals to handle this task on your behalf, contact Professional Services team at https://www.plesk.com/professional-services/.

To find out your Linux distribution, run:

# plesk version | grep "OS version"

Or:

# cat /etc/*-release

Warning: MariaDB 10.11 is supported starting from Plesk Obsidian 18.0.52. MariaDB 10.4 and later versions are supported starting from Plesk Obsidian 18.0.30. Previous versions (Onyx and older) do not support MariaDB starting from 10.3 and there are no plans to implement it currently.

Warning:
Direct upgrade from MySQL 5.1 to MySQL 5.6/5.7 will break table's structure. The instructions for upgrading MySQL from 5.1 to 5.5 on Linux are available here: How to upgrade MySQL from 5.1 to 5.5 on Linux

Warning:
Direct upgrade from MariaDB 5.5 or 5.7 to MariaDB 10.6 or later versions is not possible.
You should first upgrade MariaDB 5.5. or 5.7 to any MariaDB from 10.3 to 10.5, and then perform an update to MariaDB 10.6 or later

It is strongly recommended to create a server snapshot (full backup) before upgrading. Perform MySQL/MariaDB upgrade at your own risk.

Before starting a MySQL/MariaDB upgrade, stop the WatchDog service if it is used on a server. Check its status with the service watchdog status command.

Note: MySQL/MariaDB will not be upgraded on CentOS/RHEL-based operating systems if it was installed from the Webtatic Yum repository:

# rpm -qa | grep -i mysql
mysql55w-server-5.5.57-1.w6.x86_64

To start an upgrade of MySQL/MariaDB, connect to a server via SSH as root/superuser and follow the instructions for your operating system:

Plesk on CentOS 8/AlmaLinux 8/AlmaLinux 9

By default, CentOS 8 is shipped with MariaDB 10.3.

For security reasons, create a database dump of all databases with the following command:

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

# service mariadb stop
Remove additional package conflicting with 10.4 version:

# yum remove mariadb-gssapi-server
For security reasons, copy the database directory in a separate folder:

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Configure MariaDB repository: open the Setting MariaDB repositories page, select your OS distro (for AlmaLinux 8 use RHEL 8), release, and desired MariaDB version. Once done, the configuration that should be added to the /etc/yum.repos.d/MariaDB.repo file will appear.

Warning: MariaDB 10.4 and later versions are supported since 18.0.30, make sure the latest Plesk version is installed.

Here is an example for MariaDB 10.4:

5.1. Open/create the MariaDB.repo file in any text editor. In this example, we are using the vi editor:

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

5.2. Add the content below to the file:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=1
module_hotfixes=1

The configuration item module_hotfixes=1 is a workaround for what MariaDB told is a dnf bug. See MDEV-20673 for more details

5.3. Save the changes and close the file.
Check if the mariadb-server package is already installed:

# rpm -q --whatprovides mariadb-server

If it is installed and the command above gives output, remove it using the following command:

# rpm -e --nodeps `rpm -q --whatprovides mariadb-server`
Reset all the cache:

# yum clean all
Start an upgrade of MariaDB to 10.4:

# yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
In case upgrading to MariaDB 10.6 or newer it is needed to adjust the my.cnf configuration file to match the new requirements:

# sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/my.cnf
Once the upgrade is finished, start MariaDB:

# systemctl restart mariadb
Upgrade MySQL databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mariadb-upgrade -uadmin
Restart mariadb service:

# systemctl restart mariadb
Execute this command to update the package version inside Plesk:

# plesk sbin packagemng -sdf
Restore SELinux context:

# restorecon -v /var/lib/mysql/*

Plesk on CentOS 7 / RHEL 7

By default, CentOS 7 is shipped with MariaDB 5.5. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7.

Automatic method

Note: The script below is applicable only for upgrading default MariaDB 5.5 to the MariaDB 10.5 version, for other cases apply the steps from the Manual Method section. Make sure Obsidian 18.0.30 or later is installed on the server.

Download the attached script and provide it with executable rights:

# wget https://raw.githubusercontent.com/plesk/kb-scripts/master/c7-mariadb-10-5-upgrade/c7-mariadb-10-5-upgrade.sh && chmod +x c7-mariadb-10-5-upgrade.sh
Execute the script via CLI:

# ./c7-mariadb-10-5-upgrade.sh

Manual Method

For security reasons, create a database dump of all databases with the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all-databases.sql
Stop MariaDB:

# service mariadb stop
Remove additional mariadb-bench package if installed:

# rpm -e --nodeps mariadb-bench
For security reasons, copy the database directory to a separate folder:

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Check if the mariadb-server package is already installed:

# rpm -q --whatprovides mariadb-server

If it is installed and the command above gives output, remove it using the following command:

# rpm -e --nodeps `rpm -q --whatprovides mariadb-server`
Configure MariaDB repository:

Warning: MariaDB 10.4 and later versions are supported since 18.0.30, make sure the latest Plesk version is installed.

Here is an example for MariaDB 10.5:

6.1. The following command adds the MariaDB 10.5 repository:

# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.5.26

Note: Make sure that other MariaDB repositories are not enabled in /etc/yum.repos.d/.
Reset all the cache:

# yum clean all
Start an upgrade of MariaDB:

# yum install MariaDB-client MariaDB-server MariaDB-compat MariaDB-shared
In case upgrading to MariaDB 10.6 or newer it is needed to adjust the my.cnf configuration file to match the new requirements:

# sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/my.cnf
Start MariaDB:

# systemctl restart mariadb

OR

# systemctl restart mysql
Upgrade MySQL databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart mysql service:

# systemctl restart mariadb

OR

# systemctl restart mysql
Execute this command to update the package version inside Plesk:

# plesk sbin packagemng -sdf

Note: After an upgrade, there may appear 'mysql' init script. It should be removed to avoid conflicts with MariaDB service. The same commands can be used to fix already existing conflict:

# systemctl stop mysql; killall mysqld # to stop the incorrect service if it is started
# rm -f /etc/init.d/mysql && systemctl daemon-reload # to remove the incorrect service script and reload systemctl configuration
# systemctl start mariadb # to start MariaDB if not started
# systemctl enable mariadb # to make sure that MariaDB will start after the server reboot automatically

Plesk on CloudLinux

Create a backup of all databases with the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all-databases.sql
Stop the MySQL service:

# systemctl stop mysqld
Copy a database's directory to a separate folder like this (for backup purposes also):

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
In case bind-address directive is present in /etc/my.cnf make sure that it is as follows :

# bind-address = 127.0.0.1
Start the MySQL service:

# systemctl start mysqld
- Select MySQL/MariaDB version to install:
  
  Note: The following command does not work if governor-mysql package is not installed. In such case, install it:
  
  # yum install governor-mysql
  
  # /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION
  
  Note: Where 'MYSQL_VERSION' has to be substituted with one of the following:
  mariadb102 for MariaDB v10.2
  mariadb103 for MariaDB v10.3
  mariadb104 for MariaDB v10.4
  mariadb105 for MariaDB v10.5
  mariadb106 for MariaDB v10.6
  mariadb1011 for MariaDB v10.11
  mariadb1104 for MariaDB v11.4
  mysql56 for MySQL v5.6
  mysql57 for MySQL v5.7
  mysql80 for MySQL v8.0
  mysql84 for MySQL v8.4
  As for now MariaDB v11.8 is not supported by mysqlgovernor.py
  
  Note: where 'MYSQL_VERSION' is the target database server version that should be replaced with the value from the table above. The upgrade should proceed in series, for example, for MariaDB 10.1 to 10.3:
  10.1 → 10.2;
  10.2 → 10.3.
  More information can be found here. If there is an issue with Governor, Cloudlinux support should be contacted for further support.
Install selected previously MariaDB engine:

# /usr/share/lve/dbgovernor/mysqlgovernor.py --install

Warning: CloudLinux does not recommend to downgrade from MySQL v5.6, MariaDB 10.x
Restart MySQL/MariaDB:

# systemctl restart mysql
Upgrade MySQL/MariaDB databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart MySQL:

# systemctl restart mysql
Execute the following command to update package version inside Plesk:

# plesk sbin packagemng -sdf

Plesk on Debian 9

Debian 9 is basically shipped with MariaDB. MariaDB 10.x version is a drop-in replacement for MySQL 5.5/5.6/5.7

Backup all existing databases using the KB article How to backup/restore a Plesk database dump and follow instructions on MariaDB site to update it:

https://mariadb.com/kb/en/mariadb/installing-mariadb-deb-files/

Example for MariaDB 10.2

Install MariaDB:

1.1. Stop the MariaDB service:

# service mariadb stop

# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.2

# apt install mariadb-server-10.2

If the installation fails with unmet dependencies:

dpkg: mariadb-server-10.1: dependency problems, but removing anyway as you requested:
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.1 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.2 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
<...>
The following packages have unmet dependencies:
mariadb-server-10.2 : Depends: mariadb-client-10.2 (>= 10.2.19+maria~stretch) but it is not going to be installed
Depends: mariadb-server-core-10.2 (>= 10.2.19+maria~stretch) but it is not going to be installed

Run the command below to correct them:

# apt --fix-broken install
Check MySQL/MariaDB version:

# mysql -V
mysql Ver 15.1 Distrib 10.2.19-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Start the MariaDB service:

# systemctl start mariadb

Note: It may be already started
Upgrade MySQL/MariaDB databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart MySQL/MariaDB service:

# systemctl restart mariadb
Execute the following command to update package version inside Plesk:

# plesk sbin packagemng -sdf

Plesk on Debian 10/Debian 11

By default, Debian 10 is shipped with MariaDB 10.3.

For security reasons, create a database dump of all databases with the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all-databases.sql
Stop MariaDB:

# service mariadb stop

Here is an example for MariaDB 10.4:

Warning: MariaDB 10.4 and later versions are supported since 18.0.30, make sure the latest Plesk version is installed.

Install repositories:

# apt-get install software-properties-common dirmngr apt-transport-https

# apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.4
Create a backup of all MySQL/MariaDB data:

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Start an upgrade with the following command. Leave all fields empty when asked for a 'root' user password:

# apt-get update

# apt-get install mariadb-server

If the installation fails with unmet dependencies:

plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.3 which provides virtual-mysql-server is to be removed.
Package mysql-server is not installed.
[...]
dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.4_1%3a10.4.14+maria~buster_amd64.deb (--unpack):
trying to overwrite '/usr/bin/my_print_defaults', which is also in package mariadb-server-core-10.3 1:10.3.22-0+deb10u1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Errors were encountered while processing:
/var/cache/apt/archives/mariadb-server-10.4_1%3a10.4.14+maria~buster_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

OR

The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-10.4 (>= 1:10.4.14+maria~buster) but it is not going to be installed
plesk-mysql-server : PreDepends: virtual-mysql-server or
mysql-server but it is not installable
Depends: virtual-mysql-server or
mysql-server but it is not installable

Run the command below to correct them:

# apt --fix-broken install
Adjust the /etc/mysql/my.cnfand/or /etc/mysql/mariadb.conf.d/50-server.cnf configuration file to match the new requirements:

# sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/mysql/my.cnf

# sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/mysql/mariadb.conf.d/50-server.cnf
Start the MariaDB service:

# systemctl start mariadb.service
Upgrade MySQL/MariaDB databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart MySQL/MariaDB service:

# systemctl restart mariadb
Execute the following command to update package version inside Plesk:

# plesk sbin packagemng -sdf

Plesk on Ubuntu 18.04

Ubuntu 18.04 is shipped with MariaDB 10.1. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7. In order to upgrade MariaDB 10.1 to MariaDB 10.x, follow these steps:

Create a backup of all databases with the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-databases.sql
Stop the MariaDB service:

# systemctl stop mariadb

Here is an example for MariaDB 10.2:

Warning: MariaDB 10.4 and later versions are supported since 18.0.30, make sure the latest Plesk version is installed.

Install repositories:

# apt-get install software-properties-common

# apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.2
Create a backup of all MySQL/MariaDB data:

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Start an upgrade with the following command. Leave all fields empty when asked for a root user password:

# apt-get update

# apt-get install mariadb-server
Start the MariaDB service:

# systemctl start mariadb
Upgrade MySQL/MariaDB databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart MySQL/MariaDB service:

# systemctl restart mariadb
Execute the following command to update package version inside Plesk:

# plesk sbin packagemng -sdf

Plesk on Ubuntu 20.04/Ubuntu 22.04

By default, Ubuntu 20.04 is shipped with MariaDB 10.3 and Ubuntu 22.04 with MariaDB 10.6.

For security reasons, create a database dump of all databases with the following command:

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

# service mariadb stop

Here is an example for MariaDB 10.4:

Warning: MariaDB 10.4 and later versions are supported since 18.0.30, make sure the latest Plesk version is installed.

Install repositories:

# apt-get install software-properties-common

# apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.4
Create a backup of all MySQL data:

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Start an upgrade with the following command. Leave all fields empty when asked for a 'root' user password:

# apt-get update

# apt-get install mariadb-server
Adjust the my.cnf configuration file to match the new requirements:

# sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/mysql/my.cnf
Start the MariaDB service:

# service mariadb start
Upgrade MySQL/MariaDB databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Restart mysql service:

# service mariadb restart
Execute the following command to update package version inside Plesk:

# plesk sbin packagemng -sdf

More information available in MySQL documentation at http://dev.mysql.com/.

Comments

89 comments

Ricardo Ribeiro
November 20, 2023 12:09

Hi all,

I recently upgraded the old version from 10.3 to 10.4.32, and now I wanted to do the rest of the updates, starting with 10.5, but I'm getting the following error:

If you can help me, I would appreciate it.

yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
Upgrading directly from MySQL 10.4 to MariaDB 10.5 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'

You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-10.5.23-1.el8.x86_64) scriptlet failed, exit status 1

Error in PREIN scriptlet in rpm package MariaDB-server
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 5/10
error: MariaDB-server-10.5.23-1.el8.x86_64: install failed

Upgrading : MariaDB-backup-10.5.23-1.el8.x86_64 5/10
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 5/10
Running scriptlet: MariaDB-client-10.4.32-1.el8.x86_64 6/10
error: MariaDB-server-10.4.32-1.el8.x86_64: erase skipped

Cleanup : MariaDB-client-10.4.32-1.el8.x86_64 6/10
Running scriptlet: MariaDB-client-10.4.32-1.el8.x86_64 6/10
Running scriptlet: MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Cleanup : MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Running scriptlet: MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Running scriptlet: MariaDB-common-10.4.32-1.el8.x86_64 8/10
Cleanup : MariaDB-common-10.4.32-1.el8.x86_64 8/10
Running scriptlet: MariaDB-common-10.4.32-1.el8.x86_64 8/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Cleanup : MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-common-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-client-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Verifying : MariaDB-backup-10.5.23-1.el8.x86_64 1/10
Verifying : MariaDB-backup-10.4.32-1.el8.x86_64 2/10
Verifying : MariaDB-client-10.5.23-1.el8.x86_64 3/10
Verifying : MariaDB-client-10.4.32-1.el8.x86_64 4/10
Verifying : MariaDB-common-10.5.23-1.el8.x86_64 5/10
Verifying : MariaDB-common-10.4.32-1.el8.x86_64 6/10
Verifying : MariaDB-server-10.5.23-1.el8.x86_64 7/10
Verifying : MariaDB-server-10.4.32-1.el8.x86_64 8/10
Verifying : MariaDB-shared-10.5.23-1.el8.x86_64 9/10
Verifying : MariaDB-shared-10.4.32-1.el8.x86_64 10/10

Upgraded:
MariaDB-backup-10.5.23-1.el8.x86_64 MariaDB-client-10.5.23-1.el8.x86_64
MariaDB-common-10.5.23-1.el8.x86_64 MariaDB-shared-10.5.23-1.el8.x86_64
Failed:
MariaDB-server-10.4.32-1.el8.x86_64 MariaDB-server-10.5.23-1.el8.x86_64

Error: Transaction failed

0
Unknown User
November 27, 2023 09:39 (Edited November 27, 2023 09:39)

I ran into the "A manual upgrade is required." issue too, going from MariaDB 10.6 to 10.11.

This helped me:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-databases.sql
systemctl stop mariadb
cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
rpm -q --whatprovides mysql-server
rpm -e --nodeps `rpm -q --whatprovides mysql-server`

This removes the old MariaDB without removing dependencies and then the upgrade succeeds.

@Plesk support: this should be added to the manual. Currently it isn't correct.

P.S. I'm on Almalinux 8.

1
Unknown User
November 27, 2023 11:46

I need to upgrade database from MariaDB 10.3.39 to 10.11 but there is no instructions for MariaDB for CloudLinux (7.9) ?
Product: Plesk Obsidian v18.0.57

1
Unknown User
December 14, 2023 01:01

I need to upgrade database from MariaDB 10.3.39 to 10.11 but there is no instructions for MariaDB for CloudLinux (7.9) ?
Product: Plesk Obsidian v18.0.57

No help...

0
Julian Bonpland Mignaquy
December 14, 2023 09:06

Hi,

Please refer to the section called Plesk for Cloudlinux.

0
Gravu Trad
January 03, 2024 02:36

How to go back to original plesk version please?

0
Joe C
March 01, 2024 23:34

We have:

Dedicated CentOS Linux 7.9.2009 (Core) Server w/128G Ram 4TB SSD

Plesk Obsidian 18.0.58 Update #2, last updated on Jan 25, 2024 07:08 AM

MariaDb 5.5.68

Running Several WordPress Sites, (about 80 with databases)
PhP 8.3, with Apache & Nginx running together
(Nginx is the front end server to Apache)

Can we use the 'Automatic Upgrade Tool via UI'
to upgrade MariaDB 5.5.68 to MariaDB 10.5?

Thanks.

Joe C. - VP

0
Julian Bonpland Mignaquy
March 04, 2024 09:04

Joe C yes, you will see the option 10.5.

0
jason swain
March 12, 2024 08:58

Hi,

I'm using plesk obsidian 18.0.58 on a virtual cloud server (at ionos) with Ubuntu 20.04

I can see from your note: that the 'Automatic Upgrade Tool via UI' which is currently in Beta will not work with CloudLinux (i tried to edit the panel.ini anyway just in case and it failed)

My question is... will that functionality become available to me eventually?

Thanks
Jason.S

0
440Music
April 10, 2024 03:17

I had an issue trying to upgrade a production server and was offline for a few hours.
I followed the wrong instructions glad I had a good backup. I found this help page to be spot on with a new OS Rocky8.9 and Plesk. I did an update as root using ssh.

I followed the instruction and now I can get on with the final configuration
Thank you

1
Elisabeth Kahnert
May 18, 2024 13:13

Plesk Ubuntu 20.4 LTS
Was unabled to upgrade form mariadb 10.3 with the GUI. Got an error
"Running mysqlcheck ...
table nameXYZ
warning : Found row where the auto_increment column has the value 0"

I tried then to upgrade manually and while doing mysqldump got this error: mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES

Probably the sys schema came along with the upgrade from mysql to mariadb, but I don't know if it's used anywhere or if I can just drop it safely.

0
Julian Bonpland Mignaquy
May 20, 2024 08:13

Hi Elisabeth Kahnert, please open a support ticket with us so we can investigate what happened.

0
Elisabeth Kahnert
May 21, 2024 11:56

Hello Julian Bonpland Mignaquy, I would but if I try and submit a request, I get We identified that the Plesk license was purchased not directly from Plesk but through one of the Plesk Resellers. So I'll try it through the reseller, but last time I tried to solve a case via resller, it took forever and didn't do much good. It would be just nice to know if plesk uses the views from the sys database or if I can just drop database sys, because in the standard mariadb 10.3 it isn't used.

0
Daniel Garcia Gonzalez
May 27, 2024 13:11

Hello, I also have Ubuntu 20.04LTS with MariaDB 10.3.39.

I was wondering if you were able to fix the issue, I'd like to upgdate my MariaDB to 10.11 but if that could end with an issue with the DB server then I'll wait.

Thanks in advance!

Kind regards

0
Daniel Garcia Gonzalez
May 27, 2024 13:32 (Edited May 27, 2024 13:42)

Hello I've done the update and now plesk and our entire server is not working. The error we are getting is the following:

● mariadb.service - MariaDB 10.11.8 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Mon 2024-05-27 13:30:36 UTC; 8s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3336854 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3336866 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3336868 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, s>
Process: 3336903 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 3336903 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [Note] Plugin 'FEEDBACK' is disabled.
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [Note] Server socket created on IP: '127.0.0.1'.
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [ERROR] Do you already have another server running on port: 3306 ?
May 27 13:30:35 ns3218302 mariadbd[3336903]: 2024-05-27 13:30:35 0 [ERROR] Aborting
May 27 13:30:36 ns3218302 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 27 13:30:36 ns3218302 systemd[1]: mariadb.service: Failed with result 'exit-code'.
May 27 13:30:36 ns3218302 systemd[1]: Failed to start MariaDB 10.11.8 database server.

I checked and there's no process using port 3306 I'm not sure what can I do please we need a solution for this

Update: In case somebody faces this issue I solved it by following this guide: https://support.plesk.com/hc/en-us/articles/12376924598935-Unable-to-start-MariaDB-10-6-on-a-Plesk-server-Bind-on-TCP-IP-port-Got-error-22-Invalid-argument

The only thing is that I had the my.coinf file in a nother folder but besides that looks like it's working fine

1
Julian Bonpland Mignaquy
July 01, 2024 08:44

Hi Elisabeth Kahnert, yes, you can drop the view before the procedure as described here https://support.plesk.com/hc/en-us/articles/12389317092375-Unable-create-database-dump-View-database-table-references-invalid-table-s-or-column-s-or-function-s-or-definer-invoker-of-view-lack-rights-to-use-them-when-using-LOCK-TABLES in the last command.

0
David Delgado Santana
July 22, 2024 19:59

I cannot upgrade MariaDB to latest version via web interface, it simply does nothing. I am running Alma Linux 9.4 (compatible with Red Hat Enterprise Linux 9.4) with latest updates and Plesk Obsidian 18.0.62 Update 1. PHP Version 8.3.9. MariaDB 10.5.22. I do not have mariadb root password, since Plesk handles this through the admin user. So...

I have been looking for a way to upgrade MariaDB to latest version in this situation, and I built a guide. I would like to know if it is good enough and I can upgrate mariadb and keep plesk running. Would you please check it and tell me if i have to make any modifications?

This is the Guide:

If you can’t upgrade MariaDB through the Plesk interface, you can perform the upgrade via the command line. Here’s a step-by-step guide to help you upgrade MariaDB on AlmaLinux 9 with Plesk:

Backup Your Databases:
plesk db dump > /root/all-databases.sql

Stop MariaDB Service:
systemctl stop mariadb

Add the MariaDB Repository: Create a new repo file:
vi /etc/yum.repos.d/MariaDB.repo
Paste the following contents into the file:
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/11.4.2/almalinux9-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Remove Old MariaDB Server:
dnf remove mariadb-server
dnf clean all

Install the Latest MariaDB Version:
dnf install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

Start MariaDB Service:
systemctl start mariadb
systemctl enable mariadb

Run MariaDB Upgrade:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

Verify the Installation:
mysql -V
systemctl status mariadb

This process should help you upgrade MariaDB to the latest version while ensuring compatibility with Plesk123.

Could I perform this upgrade safety? I do not want my plesk server and linux to stop working properly. Than you so much in advance for your help.

0
Julian Bonpland Mignaquy
July 24, 2024 08:13

Hi David Delgado Santana if the automatic procedure does not work please open a support ticket with us so we can check for any errors in the logs.

In this same ticket you can find a manual procedure.

0
Nicolas EDOT EDOT
September 25, 2024 03:38

is the auto update soon for almalinux ?

0
Julian Bonpland Mignaquy
September 25, 2024 08:40

hi Nicolas EDOT EDOT,

please add the following to panel.ini How to edit Plesk panel.ini:

[databaseManagement]
features.canBeUpgraded = 1

0
Tobias Magnus
October 07, 2024 23:28

Even I have Plesk 18.0.63, an update button is not shown (current mariaDb version: 10.5.26 / need 10.11)

0
Julian Bonpland Mignaquy
October 08, 2024 08:13

Tobias Magnus could you please specify which OS you are running?

0
Tobias Magnus
October 08, 2024 08:16

The server runs on Debian 11

0
Julian Bonpland Mignaquy
October 08, 2024 09:18
HI Tobias Magnus i deployed a new deb 11, then added the following with 'plesk conf panel.ini':
```
[databaseManagement]
features.canBeUpgraded = 1
```
And the Upgrade Now button was shown:

If it is still now shown for you please erase the content of your your panel.ini and try again.

If the issue persists please open a support ticket with us.
0

Vianney ZAHNER

October 08, 2024 11:58

Hi Julian,

Under AlmaLinux I have the error below when updating:

The following package manager configuration files contain options that may result in an upgrade failure:
/etc/yum.repos.d/epel.repo

To proceed with the upgrade, comment out or remove the following options:
exclude, excludepkgs, includepkgs, installonlypkgs, tsflags.

Julian Bonpland Mignaquy
October 09, 2024 08:18

Vianney ZAHNER please proceed here https://support.plesk.com/hc/en-us/articles/22595758353943-MariaDB-pre-upgrade-check-failed-The-following-package-manager-configuration-files-contain-options-that-may-result-in-an-upgrade-failure

0
Vianney ZAHNER
October 09, 2024 11:59

Hello Julian,

Many thanks, It worked perfectly.

0
Michel CLAR
January 21, 2025 20:48

Hello,
after editing and saving the panel.ini file with the good tool, NO upgrade LINK is displayed.
Please, tell how to proceed. 10.6 MariaDb is required for Drupal 11.

0
Julian Bonpland Mignaquy
January 23, 2025 11:14
Michel CLAR hi!, please show me the output of:
```
cat /usr/local/psa/admin/conf/panel.ini
```
1
Michel CLAR
January 23, 2025 11:19

[debug]
; Enable debug mode (do not use in production environment)
;enabled = on
[log]
; Log messages verbosity level (from 0 to 7)
; 0 - only critical errors, 7 - all including debug messages, default - 3
;filter.priority = 7
; Enable logging of SQL queries
;show.sql_query = on
; Enable logging of external utilities calls
;show.util_exec = on
; Enable logging of stdin and stdout for external utilities calls (do not use in production environment)
;show.util_exec_io = on
; Enable logging of APSC activities
;apsc.enabled = on
[aps]
; Disable APS apps at all
;enabled = off
[locale]
; Show locale keys instead of localized string (values: off, on, long)
;showKeys = long
[help]
; Documentation URL
;url = http://example.com
[promos]
; Disable other products promotions
;enabled = off
[facebook]
; Hide Like link
;showLikeLink = off
[rating]
; Hide feedback dialog with question to rate product
;enabled = off
[DatabaseManagement]
features.canBeUpgraded = true
[cli]
; Ignore nonexistent options in command line interface
;ignoreNonexistentOptions = off
[pmm]
; Allow to upload modified, corrupted, created on another server or in an older Panel version
; that does not support signing of backups. Set this option only if you trust to backup creator because upload of modified
; backup may compromise you server. If value is on then users just informed about changes in backup and restore isn't blocked
; Values: on, off
;allowRestoreModifiedDumps = off
$

0

Please sign in to leave a comment.