Articles in this section

See more

How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux?

Avatar
Robert Asilbekov
Updated
Follow

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

Warning: MariaDB 10.4 is not currently supported by Plesk.

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

  1. For security reasons, create a database dump of all databases with the following command:

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

  2. Stop MariaDB:

    # service mariadb stop

  3. Remove additional packages like mariadb-bench:

    # rpm -e --nodeps mariadb-bench

  4. For security reasons, copy the database directory in a separate folder:

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

  5. 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`

  6. Configure MariaDB repository: open the Setting MariaDB repositories page, select your OS distro, release and a desired MariaDB version. Once done, the configuration that should be added to the /etc/yum.repos.d/MariaDB.repo file will appear.

    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.

  7. Start an upgrade of MariaDB:

    # yum install MariaDB-client MariaDB-server

  8. Once the upgrade is finished, start MariaDB:

    # service mariadb start

    OR

    # service mysql start

  9. Upgrade MySQL databases:

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

  10. Restart mysql service:

    # service mariadb restart

    OR

    # service mysql restart

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

  1. For security reasons, create a database dump of all databases with the following command:

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

  2. Stop MySQL server:

    # service mysqld stop

  3. For security reasons, create a backup of all existing databases:

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

  4. Disable Atomic repository, if it is enabled:

    # vi /etc/yum.repos.d/atomic.repo
    enabled = 0

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

  6. Install the MySQL-community repository:

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

  7. Configure MariaDB 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, as this release is 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

    7.3. Save the changes and close the file.

  8. 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*

  9. 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]:

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

  11. Upgrade MySQL databases:

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

  12. Restart mysql service:

    # service mysqld restart

Plesk on CloudLinux

  1. Create a backup of all databases with the following command:

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

  2. Stop the MySQL service:

    # service mysqld stop

  3. Copy a databases directory in a separate folder like this (for backup purposes also):

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

  4. Start the MySQL service:

    # service mysqld start

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

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

  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

  8. Execute this command to update the package version inside Plesk:

    # plesk bin service_node --update local

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:

Example

Install MariaDB:

# 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

Execute this command to update package version inside Plesk:

# plesk bin service_node --update local

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.2, follow this steps:

  1. Create a backup of all databases with the following command:

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

  2. Stop the MariaDB service:

    # service mariadb stop

  3. Install repositories from downloads.mariadb.org, for example qq:

    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 --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
    # add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.truenetwork.ru/mariadb/repo/10.2/ubuntu bionic main'

  4. Create a backup of all MySQL data:

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

  5. Start an upgrade with the following command. Leave all fields empty when asked for a root user password:

    # apt-get install mariadb-server

  6. Start the MariaDB service:

    # service mariadb start

  7. Upgrade MySQL databases:

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

  8. Restart mysql service:

    # service mariadb restart

  9. Execute this command to update the package version inside Plesk:

    # plesk bin service_node --update local

Plesk on Ubuntu 14.04

Ubuntu 14.04 is shipped with MySQL 5.5 by default.

  1. Create a full server backup and a server's disk snapshot.

  2. Create a backup of /etc/mysql/my.cnf:

    # cp /etc/mysql/my.cnf{,_original}

  3. Add the MySQL APT Repository:

    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 a wrong MySQL version by mistake.

    • Go to the download page for the MySQL APT repository at http://dev.mysql.com/downloads/repo/apt/.

    • Select and download a release package for your platform:

      # wget https://dev.mysql.com/get/mysql-apt-config_0.8.11-1_all.deb

    • Install the downloaded release package:

      # dpkg -i mysql-apt-config_0.8.11-1_all.deb

      Warning: During an installation of the MySQL package, you will be asked to choose the versions of the MySQL server and other components that you want to install. If you are not sure which version to choose, do not change the options selected by default. You can also choose none if you do not want a particular component to be installed. After making choices for all components, choose Apply to finish the configuration and installation of the release package.

    • Update package information from the MySQL APT repository:

      # apt-get update

  4. Upgrade MySQL:

    # apt-get install mysql-server

    To avoid issues Agree when prompted to update /etc/mysql/my.cnf.

  5. Make sure that mysql-community-libs-compat package is installed. Install if it is missing.

  6. Upgrade MySQL databases:

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

  7. Restart MySQL server

    # service mysql restart

  8. In Plesk go to Tools & Settings > Server Components and click Refresh.

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

Related Articles

Comments

101 comments

Sort by Date Votes
  • Avatar
    Jan Bludau

    I would like to give a advise / complete the guide.

    if you have Watchdog configured to monitor mysql, it could happen that it will automatically try to start the server for example while copying cp -a the mariadb /data-folder/ ... then it woudn't succed. And i would recommend to disable watchdog monitoring while try to upgrade mysql / mariadb... it could cause errors...

    0
    Comment actions Permalink
  • Avatar
    Dinara Aspembitova

    Hello @Jan Bludau,

    Thank you for the notice.

    The article has been updated.

    1
    Comment actions Permalink
  • Avatar
    Jan Bludau

    Hello @Dinara Aspembitova,

    Cool, very fast :-)

    0
    Comment actions Permalink
  • Avatar
    WeHoDo

    Hi, im quite new on Plesk.
    I have an VPS with Centos 7 installed with Plesk.
    SQL 5.5.60 is running.

    Is there an option to upgrade from Plesk gui?

    1
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @WeHoDo,

    There is no such functionality, please, follow the steps from this article.

    In case you want it to be done from Plesk side, submit a request to Plesk Professional Services: https://www.plesk.com/professional-services/administrative-services/

    1
    Comment actions Permalink
  • Avatar
    WeHoDo

    @Ivan,

     

    Thank you for your quick reply.
    I will have a look.

    0
    Comment actions Permalink
  • Avatar
    Jan Bludau

    @Ivan: the mysql-upgrade guide is complette, everythink worked as aspected :-)

    to be more update2date is quite nice, more performance is also quite nice =D

    on the plesk gui for install i see that i could install a "MySQL Server" why you don't support updating it?

    the guide works as aspected, fully automatical, without a user input. You give an notice that you will do an backup and everything is cool :-)

    without exakt that line: "rpm -e --nodeps `rpm -q --whatprovides mysql-server`" you will destroy the plesk installation *smile*

    0
    Comment actions Permalink
  • Avatar
    Alisa Kasyanova

    @Jan Bludau
    Glad to know that this guide helped! You are right that it is necessary to use all the mentioned steps, or the upgrade could go wrong.
    >>> on the plesk gui for install i see that i could install a "MySQL Server" why you don't support updating it?
    The implementation of such automatic update is quite difficult, since every step should be done very attentively, and each step should be checked thoroughly. So as for now, such upgrades should be performed manually.

    1
    Comment actions Permalink
  • Avatar
    WeHoDo (Edited )

    Hi,

    I have tried to run the commands on Centos 7 on a test VPS.
    I get no errors, but in the GUI it stills show 5.5.60 as database server version.

    In the CLI I see this:
    mysql Ver 15.1 Distrib 10.2.23-MariaDB,

     

    Did I missed something?

     

    ==

    Never mind, now its shows the 10.2.23 version.
    Probaly some updates didnt renew directly.

     

    Will try to run on the live server.

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin

    Hi @WeHoDo,

    Glad to hear that the issue was resolved!

    Usually, the changes are reflected in Plesk immediately. Maybe the website page was cached and, thus, showed the incorrect info regarding the MariaDB version

    0
    Comment actions Permalink
  • Avatar
    Jorge Salazar (Edited )

    HI All,

     

    I am having issues to upgrade MySQL from 5.5 to maridb10.2.

     

    I am following the steps for Cloud Linux but when I am in the step 6 which is:

    /usr/share/lve/dbgovernor/mysqlgovernor.py --install

     

    The command returns an error saying that it could not install that because the file wasn't found:

    [root@localhost~]# /usr/share/lve/dbgovernor/mysqlgovernor.py --install
    !!!Before making any changing with database make sure that you have reserve copy of users data!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!Ctrl+C for cancellation of installation!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Instruction: how to create whole database backup - http://docs.cloudlinux.com/index.html?backing_up_mysql.html
    Start download current installed packages
    WARNING!!!! Package mariadb-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    WARNING!!!! Package mariadb-libs-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    WARNING!!!! Package mariadb-server-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    Trying to load custom packages from yum
    WARNING!!!! Package mariadb-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    WARNING!!!! Package mariadb-libs-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    WARNING!!!! Package mariadb-server-5.5.60-1.el7_5.cloudlinux.x86_64 was not downloaded
    Start download packages for new installation
    Loaded plugins: fastestmirror, rhnplugin
    Cleaning repos: PLESK_17_8_11-extras PLESK_17_PHP56 PLESK_17_PHP70 PLESK_17_PHP71 PLESK_17_PHP72 PLESK_17_PHP73 cl-mysql-meta cloudlinux-x86_64-server-7 plesk-migrator plesk-migrator-tp
    Cleaning up list of fastest mirrors
    Other repos take up 106 k of disk space (use --verbose for details)
    Execution command: repoquery --requires cl-MariaDB-meta error
    Traceback (most recent call last):
    File "/usr/share/lve/dbgovernor/mysqlgovernor.py", line 349, in <module>
    main(sys.argv[1:])
    File "/usr/share/lve/dbgovernor/mysqlgovernor.py", line 213, in main
    if manager.install(opts.install_beta, opts.yes, opts.wizard):
    File "/usr/share/lve/dbgovernor/modules/base.py", line 205, in install
    self._load_packages(beta)
    File "/usr/share/lve/dbgovernor/modules/base.py", line 557, in _load_packages
    self._new_packages = self._load_new_packages(beta)
    File "/usr/share/lve/dbgovernor/modules/base.py", line 755, in _load_new_packages
    packages += exec_command("repoquery --requires %s" % name)
    File "/usr/share/lve/dbgovernor/utilities.py", line 491, in exec_command
    raise RuntimeError("%s\n%s" % (out, err))
    RuntimeError:
    failure: repodata/repomd.xml from cl-mysql-meta: [Errno 256] No more mirrors to try.
    http://repo.cloudlinux.com/other/cl7.6/mysqlmeta/cl-mariadb-10.2/x86_64/repodata/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found

     

    So I tried to check why the repo link didn't work and if you go to that folder by surfing to it manually with a browser, then I realized that it doesn't exist for my Cloud Linux 7.6, please see below:

    What you get when you go to that URL:https://www.repo.cloudlinux.com/other/

    Parent Directory   -  
    [DIR] alt-python/ 11-Feb-2015 05:37 -  
    [DIR] cl5/ 24-Feb-2015 05:42 -  
    [DIR] cl6/ 12-Dec-2018 05:41 -  
    [DIR] cl6h/ 12-Dec-2018 05:41 -  
    [DIR] cl7.2/ 10-Dec-2018 10:28 -  
    [DIR] cl7/ 10-Dec-2018 10:28 -  
    [DIR] ea-php-for-centos/ 27-Feb-2017 03:30 -  
    [DIR] google-cloud/ 17-Jul-2017 01:41 -  
    [DIR] sclo/ 25-Sep-2017 03:18 -  

     

    So there is not folder for my version of CL7.6, so my question is how can I fix this?

     

    Should I edit repo manually and use the files for cl7.2?

     

    Could someone from Plesk review this, please?

     

    Thanks,

    Jorge

    0
    Comment actions Permalink
  • Avatar
    Tara

    On CloudLinux - /usr/share/lve/dbgovernor/db-select-mysql is deprecated and doesn't seem to work any more.  Should be using /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version mariadbXX

    1
    Comment actions Permalink
  • Avatar
    Denis Bykov

    @Jorge Salazar
    Thank you for noticing.

    @Tara
    Thank you for pointing in the right direction.
    Indeed, 'db-select-mysql' is fetching the wrong repository link now. I updated the article with the correct command.

    1
    Comment actions Permalink
  • Avatar
    oןןǝɹǝɥɔuɐԀ

    Hi, there used to be a video here guiding you through the process (as I keep getting stuck at point 4 - Plesk on CentOS 6), I wanted to watch the video again to refresh (I can't change the enabled=1 to 0 for some reason) then can't exit the screen when I think I have done, the video has been removed as I guess it was outdated?

    Are you planning on adding an updated video, updating from 5.1 to 5.5 worked as expected, just this next part, thanks in advance.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @oןןǝɹǝɥɔuɐԀ

    The below instruction will help to achieve your goal, it explains how to edit files using vi:

    https://support.plesk.com/hc/en-us/articles/360001084114-How-to-edit-file-using-vi-utility-on-Linux-

    > Are you planning on adding an updated video, updating from 5.1 to 5.5 worked as expected, just this next part, thanks in advance.

    Thank you for showing interest, I will forward your feedback to the person in charge.

     

     

    1
    Comment actions Permalink
  • Avatar
    oןןǝɹǝɥɔuɐԀ

    Hi @Ivan,

    Thank you so much, I learnt something today. Completed :)

    1
    Comment actions Permalink
  • Avatar
    Alisa Kasyanova

    @oןןǝɹǝɥɔuɐԀ
    Glad to know that it helped :)

    0
    Comment actions Permalink
  • Avatar
    Victor Fournier (Edited )

    Hi All,

     

    I upgraded MariaDB version to the latest (mysql  Ver 15.1 Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) on a plesk under Debian 9 but my sql version seems to stay at 5.5. What can I do to complete/upgrade mysql localhost to ensure the utilization of the 5.7 version ? (I made a link to verify it : http://fournierservices.dev/.test/scripts/check.php)

     

    Thank you so much for your help,

    Best regards,

    Victor

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin (Edited )

    Hi @Victor Fournier,

    Based on the provided information:

    # mysql -V

    mysql Ver 15.1 Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

    you performed an upgrade to MariaDB 10.3

    As far as I can see, the local MySQL server was upgraded successfully 

    Keep also in mind that Plesk supports MariaDB 10.3 in upcoming Plesk 17.9 only:

    MariaDB 10.3 support in Plesk

    The same information is available in the Notes section in this article:

    MariaDB 10.3 is not currently supported. Support for this version will be added in the upcoming release Plesk Onyx 17.9
    0
    Comment actions Permalink
  • Avatar
    Victor Fournier

    Hi @Nikita Nikushkin,

    Thank you for your answer and your help, I didn't notice that it was not yet supported in Plesk. Therefore, it's not possible to make the upgrade for MySQL 5.5 to 5.7 for client side until the full adoption of the 10.3 version ?

    If I downgrade to the 10.2, will it be possible ? The update from 5.5 to 5.7 is automatic or some commands should be run ? I didn't find any clue on the MariaDB website.

     

    Best Regards

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin

    Hi @Victor Fournier,

    > Thank you for your answer and your help, I didn't notice that it was not yet supported in Plesk. Therefore, it's not possible to make the upgrade for MySQL 5.5 to 5.7 for client side until the full adoption of the 10.3 version ?

    MySQL upgrade from 5.5 to 5.6/5.7 is possible by using steps from this article, as well as MariaDB upgrade from 5.5 to 10.0/10.1/10.2

    However, it is not possible to upgrade MariaDB to MySQL or vice versa as they are different products

    > If I downgrade to the 10.2, will it be possible ? The update from 5.5 to 5.7 is automatic or some commands should be run ? I didn't find any clue on the MariaDB website.

    MariaDB downgrade is not supported be Plesk and this procedure can break Plesk working capacity

    Also, the official MariaDB website tells that downgrading MariaDB is not supported as well:

    "Downgrading MariaDB is not supported. The only reliable way to downgrade is to restore from a full backup made before upgrading, and start the old version of MariaDB.

    Some people have reported successfully downgrading, but there are many possible things that can go wrong, and downgrading is not tested in any way by the MariaDB developers."

    In this article, it was strongly recommended to create a server snapshot/full server backup.

    So, if you have one, restore the server from it and perform the upgrade of MariaDB to the supported version one more time. It is the best way

    If you have no server backup, you can try to do the following at your own risk:

    1. Create a full server backup/snapshot
    2. Stop MariaDB service
    3. Remove MariaDB packages
    4. Disable MariaDB 10.3 repository
    5. Install the same MariaDB version as it was before the upgrade procedure
    6. Stop MariaDB service
    7. Free up the current "/var/lib/mysql" folder and move databases dumps to it. By default, they have to located in the "/var/lib/mysql_backup" folder
    8. Start MariaDB service
    9. Perform the upgrade of MariaDB again to the supported version by Plesk if it is required

    0
    Comment actions Permalink
  • Avatar
    Jorge Salazar

    Hi @Denis Bykov,

     

    Any updates about how I can update MySQL 5.5 to MariaDB10.2 for Cloud Linux 7.6?

     

    Regards,

    Jorge

    0
    Comment actions Permalink
  • Avatar
    Nick Plekhov

    Hello @Jorge Salazar,

    As I can see the issue is caused by incorrect repository settings. As the installation is invoked by mysqlgovernor.py, which is part of CloudLinux assets I suggest you contacting CloudLinux support directly for further help.

    0
    Comment actions Permalink
  • Avatar
    Jan Bludau
    1. cp -a /var/lib/mysql/ /var/lib/mysql_backup

    for this command provide "-v"

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

    on lage Database you would be glad to see the output of copying and not a window where nothing happen....

    Plesk 18.11.x is MariaDB 10.3 compatible, works without Problems.

    ---- SNIP ----

    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:

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

    6.3. Save the changes and close the file.

     

    --- END OF SNIP ---

    1
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Jan,

    Thank you for the valuable notice!

    The article will be updated by its author soon.

    1
    Comment actions Permalink
  • Avatar
    Jan Bludau (Edited )

    Update  Plesk Onyx 17.8.11 Update Nr. 54 to Mariadb 10.4 from 10.3

    1. rpm -q --whatprovides mysql-server

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

      # rpm -e --nodeps `rpm -q --whatprovides mysql-server`

    3. Configure MariaDB repository: open the Setting MariaDB repositories page, select your OS distro, release and a desired MariaDB version. Once done, the configuration that should be added to the /etc/yum.repos.d/MariaDB.repo file will appear.

      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:

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

      6.3. Save the changes and close the file.

     

     --> new between the next step in the guide

    # yum -y update

    # yum install MariaDB-client MariaDB-server

    if you receive a conflict with "galera-25.3.26-1" because you had installed mariadb 10.3 

    # rpm -e galera-25.3.26-1.rhel7.el7.centos.x86_64 ... 

    # yum install MariaDB-client MariaDB-server

    --> Now follow the normal guide... 

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

    ....

    # service mariadb restart

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin

    Hi @Jan Bludau.

    Thank you for the provided instructions! Suppose, other users can found them useful

    However, keep in mind that MariaDB 10.4 is not supported by Plesk yet and, thus, all actions are performed at your own risk

    1
    Comment actions Permalink
  • Avatar
    Jan Bludau

    i've read the changelog nothing spezial there ... ok it was risky but its my development and test-server where i did it... mariabdb 10.4 works very well.

    Some advantages are:

    DoS Protection
    Bruteforce Detection

    Plesk should support the newest version officially.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Jan,

    I have corrected the link to change log in this article, it should be for Plesk Obsidian:
    https://docs.plesk.com/release-notes/obsidian/change-log/

    There is the following record from the 8th of May:

    "Updated MariaDB to version 10.3.14."

    Glad to hear that version 10.4 worked fine for you.

    Product optimization for version 10.4 will need some additional time, with no ETA for now.

    0
    Comment actions Permalink
  • Avatar
    Rashid Qureshi

    I am getting this message:

     

    Package 1:mariadb-server-5.5.60-1.el7_5.x86_64 already installed and latest version.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles