Article ID: 125586, created on May 22, 2015, last review on Nov 30, 2016

  • Applies to:
  • Plesk Automation 11.5

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.

Search Words

In current version of mysql dumper the backup manager has an issue with charset utf8mb4: mysqldump: Character set \'utf8mb4\' is not a compiled character set and is not specified in the \'/usr/share/mysql/charsets/Index.xml\' file\" Current Version is Ver 10.13 Distrib 5.1.73. Is it possible to provide an upgrade to version

database version

adding new Mysql version

Upgrade MysQL

mysql dumper

mysql 5.5

Upgrade mysql to 5.5

move mysql to 5.5

how to upgrade mysql

mysql upgrade

MySQL 5.5

upgrade mysql

Mysql 5.6.0

MySQL upgrade to 5.5

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF