How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Updated November 23, 2020 21:04

Plesk for Linux kb: how-to

Applicable to:

Plesk for Linux

This article provides 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 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 administering 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.4 and 10.5 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.

Warnings:
Direct upgrade from MySQL 5.1 to MySQL 5.6/5.7 will break tables 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

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

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

Notes: MySQL 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

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, 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: Do not select versions 10.4 and 10.5 unless you have Plesk Obsidian older than 18.0.30. these MariaDB versions are supported starting from Plesk Obsidian 18.0.30.

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:

CONFIG_TEXT: [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.
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
Once the upgrade is finished, start MariaDB:

# systemctl restart mariadb
Upgrade MySQL databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_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.

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 packages like mariadb-bench:

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

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

# rpm -q --whatprovides mysql-server

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

# rpm -e --nodeps `rpm -q --whatprovides mysql-server`
Configure MariaDB repository: open the Setting MariaDB repositories page, select your OS distro, 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: Do not select versions 10.4 and 10.5 unless you have Plesk Obsidian older than 18.0.30. these MariaDB versions are supported starting from Plesk Obsidian 18.0.30.

Here is an example for MariaDB 10.2:

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

6.2. Add the content below to the file:

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

6.3. Save the changes and close the file.
Start an upgrade of MariaDB:

# yum install MariaDB-client MariaDB-server MariaDB-compat MariaDB-shared
Once the upgrade is finished, 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 /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 CentOS 6 / RHEL 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

If the command fails with "Cannot load from mysql.proc. The table is probably corrupted", apply the solution from this KB article.
Stop MySQL server:

# service mysqld stop
For security reasons, create a backup of all existing databases:

# cp -a /var/lib/mysql /var/lib/mysql_backup
Disable Atomic repository, if it is enabled:

# vi /etc/yum.repos.d/atomic.repo
enabled = 0
Check for MySQL repo files left from previous installation.

# ls -l /etc/yum.repos.d/mysql*

If any found, remove them:

# rm -rf /etc/yum.repos.d/mysql-community-source.repo
Install the MySQL-community repository:

# yum install https://dev.mysql.com/get/mysql80-community-release-el6-1.noarch.rpm
Configure MySQL repository:

7.1. Open the mysql-community.repo file in a text editor. In this example, we are using the vi editor:

# vi /etc/yum.repos.d/mysql-community.repo

7.2. Select a MySQL version. In this example, we are upgrading MySQL to 5.7:

Warning: Disable MySQL 8.0 repository and exclude mysql-connector-odbc-8 version, as these releases are not supported by Plesk yet. If it is not disabled, yum will install the latest version which will cause major issues.

CONFIG_TEXT: [mysql56-community]
enabled=0
...
[mysql57-community]
enabled=1
...
[mysql80-community]
enabled=0
...
[mysql-connectors-community]
exclude=mysql-connector-odbc-8*
...

7.3. Save the changes and close the file.
Install MySQL packages:

# yum update mysql

If update of mysql package ends with Nothing to do message, make sure that mysql* packages are not added to excludes in yum.conf file and remove it if it is in the list:

# cat /etc/yum.conf | grep exclude
exclude=php-common php-cli php mysql* httpd* mod_ssl*
Type y if this message appears:

CONFIG_TEXT: warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : MySQL Release Engineering mysql-build@oss.oracle.com
Package: mysql57-community-release-el6-7.noarch (@/mysql57-community-release-el6-7.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]:
Start MySQL server:

# service mysqld start

If the service does not start, check the following article: MySQL fails to start: mysql.user table is damaged.
Upgrade MySQL databases:

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

# service mysqld restart
Execute the following commands to update package version inside Plesk:

# plesk bin service_node --update local
# plesk sbin packagemng -sdf

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 > /tmp/all-databases.sql
Stop the MySQL service:

# service mysqld stop
Copy a databases directory in a separate folder like this (for backup purposes also):

# cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
Start the MySQL service:

# service mysqld start
Ensure that [mysqlclient] repository is enabled in
/etc/yum.repos.d/cl-mysql.repo and the below command displays similar output:

# yum repolist enabled | grep mysqlclient
Repository extras is listed more than once in the configuration
mysqclient/7/x86_64 mysqlclient 7
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=XXXXX

Note: Where 'XXXXX' has to be substituted with one of the following:
mariadb100 for MariaDB v10.0
mariadb101 for MariaDB v10.1
mariadb102 for MariaDB v10.2
mysql55 for MySQL v5.5
mysql56 for MySQL v5.6
mysql57 for MySQL v5.7
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:

# service mysql restart
Upgrade MySQL databases:

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

# service mysql restart
Execute the following commands to update package version inside Plesk:

# plesk bin service_node --update local
# plesk sbin packagemng -sdf

Plesk on Debian 8 & 9

Debian 8 & 9 are 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:

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:

CONFIG_TEXT: 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

If the command above fails with the following error:

CONFIG_TEXT: [...]
Preparing to unpack .../mariadb-server-10.0_10.0.32-0+deb8u1_amd64.deb ...
47146
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: warning: subprocess old pre-removal script returned error exit status 1
dpkg: trying script from the new package instead ...
47146
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.0_10.0.32-0+deb8u1_amd64.deb (--unpack):
subprocess new pre-removal script returned error exit status 1
insserv: warning: script 'apf' missing LSB tags and overrides
Errors were encountered while processing:
/var/cache/apt/archives/mariadb-server-10.0_10.0.32-0+deb8u1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
[...]

Check this article: Plesk Update failed: There is a MySQL server running, but we failed in our attempts to stop it.

Check MySQL 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:

# service mariadb start

Note: It may be already started

Upgrade MySQL databases:

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

Restart mysql service:

# service mariadb restart

Execute the following commands to update package version inside Plesk:

# plesk bin service_node --update local
# plesk sbin packagemng -sdf

Plesk on Debian 10

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 > /tmp/all-databases.sql
Stop MariaDB:

# service mariadb stop

Here is an example for MariaDB 10.4:

Warning: Do not select versions 10.4 and 10.5 unless you have Plesk Obsidian older than 18.0.30. these MariaDB versions are supported starting from Plesk Obsidian 18.0.30.

Install repositories from Setting up MariaDB Repositories page:

Warning: Check the file "/etc/apt/sources.list" and the files inside directory "/etc/apt/sources.list.d/" and disable (comment with # at the beginning of the line) all MySQL repositories (e.g. MySQL 8 repository) to avoid installation of wrong MySQL versions by mistake.

# apt-get install software-properties-common dirmngr

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

# add-apt-repository 'deb [arch=amd64] https://mirror.truenetwork.ru/mariadb/repo/10.4/debian buster main'

For other MariaDB versions replace 10.4 with 10.5 in the repository path.
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

If the installation fails with unmet dependencies:

CONFIG_TEXT: 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

CONFIG_TEXT: 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
Start the MariaDB service:

# service mariadb start
Upgrade MySQL databases:

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

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

# plesk bin service_node --update local
# 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:

# service mariadb stop

Here is an example for MariaDB 10.2:

Warning: Do not select versions 10.4 and 10.5 unless you have Plesk Obsidian older than 18.0.30, these MariaDB versions are supported starting from Plesk Obsidian 18.0.30.

Install repositories from Setting up MariaDB Repositories page:

Warning: Check the file "/etc/apt/sources.list" and the files inside directory "/etc/apt/sources.list.d/" and disable (comment with # at the beginning of the line) all MySQL repositories (e.g. MySQL 8 repository) to avoid installation of wrong MySQL versions by mistake.

# apt-get install software-properties-common

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

# add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.truenetwork.ru/mariadb/repo/10.2/ubuntu bionic main'

For other MariaDB versions replace 10.2 with 10.3, etc. in the repository path.
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
Start the MariaDB service:

# service mariadb start
Upgrade MySQL databases:

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

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

# plesk bin service_node --update local
# plesk sbin packagemng -sdf

Plesk on Ubuntu 20.04

By default, Ubuntu 20.04 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

Here is an example for MariaDB 10.4:

Warning: Do not select versions 10.4 and 10.5 unless you have Plesk Obsidian older than 18.0.30. these MariaDB versions are supported starting from Plesk Obsidian 18.0.30.

Install repositories from Setting up MariaDB Repositories page:

Warning: Check the file "/etc/apt/sources.list" and the files inside directory "/etc/apt/sources.list.d/" and disable (comment with # at the beginning of the line) all MySQL repositories (e.g. MySQL 8 repository) to avoid installation of wrong MySQL versions by mistake.

# apt-get install software-properties-common

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

# add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.truenetwork.ru/mariadb/repo/10.4/ubuntu focal main'

For other MariaDB versions replace 10.4 with 10.5 in the repository path.
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
Start the MariaDB service:

# service mariadb start
Upgrade MySQL databases:

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

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

# plesk bin service_node --update local
# plesk sbin packagemng -sdf

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

Comments

183 comments

Anzhelika Khapaknysh November 13, 2019 08:55

Hi @Roberto,

I'd recommend contacting our Support Team for assistance. They will check this issue in details

0

Comment actions Permalink
murat November 16, 2019 14:03 (Edited November 16, 2019 14:14)

i have ubuntu 18.04.3, Plesk Obsidian 18.0.20 update 2 and mariadb default 10.1

I applied this article in order.

after;

root@sonbahar:~# apt install mariadb-server
...
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mariadb.service - MariaDB 10.2.29 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 Sat 2019-11-16 14:58:00 CET; 10ms ago
Docs: man:mysqld(8)
...

dpkg: error processing package mariadb-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.27-3ubuntu1) ...
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for systemd (237-3ubuntu10.31) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for ureadahead (0.100.0-21) ...
Errors were encountered while processing:
mariadb-server-10.2
mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@sonbahar:~#

PLEASE HELP ME.

REGARDS

0

Comment actions Permalink
Anzhelika Khapaknysh November 18, 2019 12:59

@murat,

Such issues required investigation on the server.

Please contact our Support Team for assistance.

0

Comment actions Permalink
Gilberto December 05, 2019 08:43

HI,

I have installed Obsidian and now some client has problem to import Database (utf8_unicode_520_ci). Your raccomended instruction ist to upgrade MariaDB.Questions:

- can I use with Obsidian and install from Red Hat Softwer Collection the MariaDB10.3?

- can I migrate MariaDB 5.5.64 direct to MariaDB 10.3? On RedHat Manual they raccomand to migrate to Version 10 at first and than to 10.3 https://access.redhat.com/documentation/en-us/red_hat_software_collections/3/html/3.3_release_notes/chap-migration

- can I use your instrution for Cento OS to migrate to MariaDB 10.3

Thanks in advice

0

Comment actions Permalink
Anton Maslov December 14, 2019 01:07

Hi Gilberto,

For RedHat please follow their guide. Direct upgrade from 5.5 to 10.3 not recommended.

0

Comment actions Permalink
Michael Zagaris January 21, 2020 00:19

Hello, just upgraded my MariaDB from 5.5 to 10.3 on Plesk Obsidia 18.0.21 and it worked just great..Took me 5 minutes and all websites are working just fine and i believe faster. I upgraded because i believe that 5.5 was causing some freezes on some queries that included SELECT DISTINCT..That happened a lot of times lately, so i hope this gets fixed..i believe it was about Copying tmp tables, or Waiting for table lock isues

0

Comment actions Permalink
Ivan Postnikov January 24, 2020 12:34

Hello Michael Zagaris

Glad to hear that all went well, thank you for the feedback.

0

Comment actions Permalink
Nerque January 25, 2020 19:20

I guess some of the steps are related to the change from mysql to mariadb, right?

If we consider that we are changing from mariadb 5.5 to mariadb 10.3, in Centos 7.7, could the summary of the steps be like I show below?

----------------------

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

service mariadb stop

rpm -qa | grep mariadb

==> rpm -e --nodeps <other-mariadb-package>

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

rpm -q --whatprovides mariadb-server

rpm -e --nodeps `rpm -q --whatprovides mariadb-server`

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

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.3/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

yum install MariaDB-server MariaDB-client

systemctl restart mariadb

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

systemctl restart mariadb

plesk sbin packagemng -sdf

--------------------------------------

My maridb related packages are:

plesk-libmariadbclient-3.0-3.0.9-1centos.7.190417.1743.x86_64
mariadb-libs-5.5.64-1.el7.x86_64
sw-mariadb-client-1.0.0-centos7.17031417.x86_64
mariadb-server-5.5.64-1.el7.x86_64
plesk-libmariadbclient-1.0-1.0.0-1centos.7.190329.1026.x86_64
mariadb-5.5.64-1.el7.x86_64

So I guess I don't need to uninstall any of them individually, right? I guess with the command "rpm -e --nodeps `rpm -q --whatprovides mariadb-server`" they will be uninstalled

If we follow all these steps, what should we do if something fails and we need to restore the previous version?

0

Comment actions Permalink
Julian Bonpland Mignaquy January 27, 2020 11:50

Hi Nerque that is correct, you may skip this part:

rpm -q --whatprovides mariadb-server

rpm -e --nodeps `rpm -q --whatprovides mariadb-server`

Since you are already running mariadb you do not need to remove mysql.

0

Comment actions Permalink
Nerque January 27, 2020 19:53

First of all, thanks for the answer.

If it is not necessary to uninstall the current version of MariaDB (5.5), could I update MariaDB, instead of uninstalling the old version and installing the new one(10.3)?

I understood from some site that it was not recommended, and that it was better to uninstall version 5.5 and then install version 10.3. I don't know if that's true.

If an upgrade were possible, I suppose the steps would be:

-------------------------------------------------

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

service mariadb stop

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

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

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.3/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

yum -y upgrade maria*

systemctl restart mariadb

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

systemctl restart mariadb

plesk sbin packagemng -sdf

-----------------------------------------

Is this all right?

And, although a copy of the databases is made, with the dump and copy of the mysql folder, I am not very clear about the process to recover it in case of disaster. Uninstall MariaDB 10.3, remove the repo file, reinstall the default version of centos, restore mysql folder and then recover the dump? Would this be the right order? Is it necessary to restore the mysql folder or is it enough to recover the dump?

Thank you in advance

0

Comment actions Permalink
Kingsley Felix January 30, 2020 06:40

I am on debian 9 and i wish to upgrade mariadb to 10.3

0

Comment actions Permalink
Nerque January 30, 2020 09:25

Since message approval takes a long time, I tried to perform the actions I listed above, and some recommended from other sites, by uninstalling mariadb 5.5, just in case.

------------------------------------------------------

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

for DB in $(mysql -uadmin -p`cat /etc/psa/.psa.shadow` -B -e "show databases" -s --skip-column-names); do

mysqldump -u admin -p`cat /etc/psa/.psa.shadow` $DB > ~/backup/$DB.sql

done

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -B -e "SET GLOBAL innodb_fast_shutdown=0;"

systemctl stop monit.service

systemctl disable mariadb

systemctl stop mariadb

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

cp /etc/my.cnf ~/backup/

cp -v -a /etc/my.cnf.d/ ~/backup/

rpm -e --nodeps `rpm -q --whatprovides mariadb-server`

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

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.3/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

yum install MariaDB-server MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

systemctl enable mariadb

systemctl restart mariadb

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

systemctl restart mariadb

plesk sbin packagemng -sdf

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -B -e "SELECT VERSION();"

systemctl restart monit.service

------------------------------------------------------

And... apparently, everything's fine. All the websites are working as before... Good.

0

Comment actions Permalink
Ivan Postnikov January 30, 2020 14:38

Hello Nerque

Thank you for the message, glad to hear everything went fine.

0

Comment actions Permalink
Ivan Postnikov January 30, 2020 15:05

Hello Kingsley Felix

As I can see, you've already contacted our Professional Services for assistance!

0

Comment actions Permalink
Kingsley Felix January 31, 2020 16:15

Yes and am not interested anymore... $147 just to upgrade a DATABASE

0

Comment actions Permalink
Ivan Postnikov February 06, 2020 14:06

Hello Kingsley Felix

Thank you for the feedback.

In that case, feel free to do it on your side, following steps from this article, as confirmed by other Pleskians, steps for 10.3 are identical.

0

Comment actions Permalink
Kingsley Felix February 08, 2020 09:08 (Edited February 08, 2020 09:09)

the commands for debian 9 is FAILING, NOT FOUND ERROR.

# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.3
-bash: sudo: command not found
curl: (23) Failed writing body (360 != 1369)

0

Comment actions Permalink
Anton Maslov February 20, 2020 23:31

Hello Kingsley,

Please install "sudo" command:

apt-get install sudo -y

0

Comment actions Permalink
WebITBuero March 03, 2020 07:49

Warning: MariaDB 10.3 is supported starting from Plesk Obsidian. Previous versions (Onyx and older) do not support MariaDB 10.3. For details, visit this link.
"this link" => https://support.plesk.com/hc/en-us/articles/360006201833 is a opps page!

0

Comment actions Permalink
Alexey Lapshin March 09, 2020 05:36

Hello @WebITBuero

Thank you for bringing our attention on this. The article is updated.

0

Comment actions Permalink
Rashid Qureshi April 05, 2020 11:50

I have followed this Article.

Everything went fine but the Mysql version still shows to be 5.5?

What did I do wrong?

0

Comment actions Permalink
Ivan Postnikov April 06, 2020 13:11

Hello Rashid Qureshi,

Most probably, you haven't executed this command at the end:

# plesk sbin packagemng -sdf

0

Comment actions Permalink
Necro May 30, 2020 19:18 (Edited May 31, 2020 04:26)

Hi there!

Thanks for providing this, i used to update MariaDB 5.5.65 on CentOS 7 to MariaDB 10.3, latest stable supported by Plesk.

Everything went smoothly and no errors so far, however i didn't understand what you mean on the last step:

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.

What is " 'mysql' init script", is it an error message that appears on the SSH window, on Plesk, on an error log?

Should i run those final steps anyway?

# systemctl stop mysql; killall mysqld # to stop the incorrect service if it is started
# rm /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

Thanks!

0

Comment actions Permalink
Ivan Postnikov May 31, 2020 14:19

Hello Necro

> What is " 'mysql' init script"

This is a leftover from previously installed MySQL server. Init script is a script for a service to start on boot.

> Should i run those final steps anyway?

The last step is required to make sure the processes of old MySQL version are stopped, to start MariaDB if not started, and to make sure that MariaDB will start after the server reboot. I would recommend not avoiding it.

0

Comment actions Permalink
Necro June 01, 2020 00:14 (Edited June 01, 2020 00:23)

Ok thanks Ivan!!

It already seems that Plesk is running much faster on MariaDB 10.3 than on previous 5.5 👍

Do we need to secure MariaDB? I was reading a tutorial (https://linuxize.com/post/install-mariadb-on-centos-7/) that recommended to run the mysql_secure_installation script which will perform several security related tasks like set up the root user password, remove the anonymous user, restrict root user access to the local machine, and remove the test database.

Or does Plesk takes care of this already?

Thanks again!

0

Comment actions Permalink
Ivan Postnikov June 09, 2020 07:50

Hello Necro

It's recommended to stay with the configuration, predefined by Plesk.

Also, here're general recommendations for securing Plesk installation: https://support.plesk.com/hc/en-us/articles/115000626925

0

Comment actions Permalink
Dennis June 29, 2020 08:40

Hi,

After upgrading mariadb from version 10.1 to 10.3 on debian 9.12 plesk does not seem to recognize the mysql service anymore under server components and says "The component was not installed". Everything seems to be working fine though and under "Database Servers" the new version seems in place. I followed the procedure for debian 8/9 in this article and executed the commands to update the package version inside plesk. Below you can find more details regarding my configuration:

mysql Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64)

Plesk Obsidian Web Host Edition
Version 18.0.27 Update #1

Thank you in advance for your reply! Cheers

0

Comment actions Permalink
Ivan Postnikov July 07, 2020 15:37

Hello Dennis

Please, try going to Tools & Settings > Plesk Components and click "Refresh".

In case this won't help, consider submitting a support request.

0

Comment actions Permalink
Mark S. July 13, 2020 09:00

Hello, I just wanted to update MariaDB to version 10.3.23 under Debian 10. So far all good, after the installation there were errors on an apt --fix-broken install but results in:

dpkg: regarding .../mariadb-client-core-10.3_1%3a10.3.23+maria~buster_amd64.deb containing mariadb-client-core-10.3:
mariadb-client-10.3 conflicts with mysql-client-core-5.5
mariadb-client-core-10.3 provides mysql-client-core-5.5 and is to be installed.

dpkg: error processing archive /var/cache/apt/archives/mariadb-client-core-10.3_1%3a10.3.23+maria~buster_amd64.deb (--unpack):
conflicting packages - not installing mariadb-client-core-10.3
dpkg: regarding .../mariadb-client-10.3_1%3a10.3.23+maria~buster_amd64.deb containing mariadb-client-10.3:
mariadb-client-core-10.3 conflicts with mysql-client-5.5
mariadb-client-10.3 provides mysql-client-5.5 and is to be installed.

dpkg: error processing archive /var/cache/apt/archives/mariadb-client-10.3_1%3a10.3.23+maria~buster_amd64.deb (--unpack):
conflicting packages - not installing mariadb-client-10.3
Errors were encountered while processing:
/var/cache/apt/archives/mariadb-client-core-10.3_1%3a10.3.23+maria~buster_amd64.deb
/var/cache/apt/archives/mariadb-client-10.3_1%3a10.3.23+maria~buster_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Any ideas? If I look at https://packages.debian.org/search?lang=de&searchon=names&keywords=mysql-server-core, the package "mysql-server-core-5.5" for buster does not exist.

0

Comment actions Permalink
Dennis July 22, 2020 08:39

Hi Ivan

I think you mean Tools & Settings > Server Components? I tried that already but that doesn't resolve the issue unfortunately. I'll submit a support request instead. Cheers

0

Comment actions Permalink