Unable to upgrade to Plesk Onyx: ‘mariadb-server >= 5.0.60 is needed by plesk-mysql-server – Plesk

Symptoms

Unable to upgrade Plesk 12.5 to Onyx or Onyx to Obsidian on CentOS 7 or CloudLinux 7:

Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.0.17-cos7.build1700161028.14.x86_64'] YumRPMCheckError: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.0.17-cos7.build1700161028.14.x86_64']

The same error occurs while trying to upgrade Plesk Onyx 17.0.17 to Plesk Onyx 17.5.3:

Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.5.3-cos7.build1705170317.16.x86_64']
YumRPMCheckError: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.5.3-cos7.build1705170317.16.x86_64']

MySQL Community server is installed instead of MariaDB.

Cause

Plesk Onyx and Plesk Obsidian do not support MySQL Community server after upgrade. Only new installation of Plesk with MySQL Community is supported.

Resolution

1. Login to Plesk via SSH

2. Install the required package manually:

   for upgrade to Plesk Onyx 17.0:

   # rpm -Uvh --nodeps http://autoinstall.plesk.com/PSA_17.0.17/dist-rpm-CentOS-7-x86_64/contrib/plesk-mysql-server-17.0.17-cos7.build1700161028.14.x86_64.rpm

   for upgrade to Plesk Onyx 17.5:

   # rpm -Uvh --nodeps http://autoinstall.plesk.com/PSA_17.5.3/dist-rpm-CentOS-7-x86_64/contrib/plesk-mysql-server-17.5.3-cos7.build1705170317.16.x86_64.rpm

   for upgrade to Plesk Onyx 17.8:

   # rpm -Uvh --nodeps http://autoinstall.plesk.com/PSA_17.8.11/dist-rpm-CentOS-7-x86_64/contrib/plesk-mysql-server-17.8.11-cos7.build1708180301.19.x86_64.rpm

   for upgrade to Plesk Obsidian 18:

   # rpm -Uvh --nodeps http://autoinstall.plesk.com/pool/PSA_18.0.20_1215/dist-rpm-CentOS-7-x86_64/contrib/plesk-mysql-server-18.0-2.centos.7+p18.0.17.0+t190721.1104.noarch.rpm

   Note: The address in the above command refers to Plesk 18.0.20. Browse http://autoinstall.plesk.com/pool/ to find the latest version available.