- 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 on Linux.
To find out your Linux distribution, run:
# plesk version | grep "OS version"
# cat /etc/*-release
Note: MariaDB 10.3 is not currently supported in Plesk Onyx. Support for this version will be added in the upcoming release Plesk Obsidian. For details, visit this link.
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.
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
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.
To start an upgrade of MySQL/MariaDB, connect to a server via SSH as root/superuser and follow the instructions for your operating system:
- How to backup/restore all MySQL databases in Plesk for Linux
- The Application Vault page or any application cannot be opened in Plesk: Can't open lib '/usr/lib/libmyodbc5.so'
- Can't connect to local MySQL server through socket
- Application Vault is not accessible: 502 Bad Gateway / WordPress installation hangs on 100%
- After successful MySQL upgrade, the old version of database server is shown in Plesk interface