Symptom

How to upgrade MySQL database engine to version 5.5 on Linux service node?

Resolution

There are two possible options:

1. Since update 18 Plesk Automation supports new role "MySQL 5.5 database server", so you can add new service node with MySQL 5.5.
2. It is possible to upgrade existing Database Server Service Node using the steps bellow. However it is strongly recomended to deploy new service node with MySQL 5.5 role.

2.1. Create DB backups on the management node.

2.2. Go to the service node where MySQL is planned to be upgraded and backup existing MySQL databases. It is recommended to take full server backup (or take a snapshot if a virtual environment is used).

2.3. Download and setup the repositories the packages are about to be downloaded from:

    # wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
    # wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
    # rpm -Uvh epel-release-6-8.noarch.rpm
    # rpm -Uvh remi-release-6.rpm

2.4. Install MySQL:

    # yum --enablerepo=remi update mysql-server

2.5. Make sure the versions are correct:

    # rpm -qa | grep mysql
    mysql-5.5.42-1.el6.remi.x86_64
    mysql-server-5.5.42-1.el6.remi.x86_64
    mysql-libs-5.5.42-1.el6.remi.x86_64
    compat-mysql51-5.1.54-1.el6.remi.x86_64

2.6. Check the databases structure:

    # mysql_upgrade

2.7. Reread the packages installed on the service node. Go to PA> Infrastructure> Service Nodes, select the service node where MySQL has been upgraded, then click Refresh under User-installed packages section.

2.8. As PHP version is upgraded from version 5.3 to 5.4 by dependencies, it should be updated in Customer Control Panel accordingly. Re-read PHP handlers information by using the following command on Plesk Automation Management node:

    # /usr/local/psa/bin/php_handler --reread -service-node 192.168.0.10

where `192.168.0.10` is the communication IP address of the service node where MySQL has been upgraded.