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

Follow

Comments

44 comments

  • Avatar
    Cogeco Peer 1 Frontline

    Can you please make  sure that the step "mysql_upgrade" is added after upgrading / starting MySQL on the CentOS 7 instructions? 

    This checks and fixes any system tables

    Thank You

  • Avatar
    Ivan Postnikov

    Hello @Cogeco Peer 1 Frontline,

    I have reviewed the article, "mysql_upgrade" is already added to be executed after upgrading Database server and starting it.

     

  • Avatar
    Signor Rossi

     Upgraded to MariaDB 10.3 on Plesk 17.8.11 on CentOS 7.5 successfully.

  • Avatar
    Ivan Postnikov

    Hello @Ivan, glad to hear that the instruction has helped. However, MariaDB 10.2 and 10.3 are not yet officially supported by Plesk.

  • Avatar
    Learning Curve

    We followed the instructions provided on here and upgraded MariaDB 10.1 to MariaDB 10.2 on Ubuntu 18.04.1 running Plesk 17.8.11 #19 where MariaDB 10.2 is now officially supported. It worked first time, perfectly, with no issues.

  • Avatar
    Alexandr Tumanov

    @Learning Curve, great!

  • Avatar
    Bruno Schrotter (Edited )

    Hello Ivan!

    I have Plesk Onyx Version 17.8.11 Update #19 on a CentOS Linux 7.5.1804 (Core) with a MySQL (Maria DB I belief) ver.5.5.60. on a dedicated server.

    I have a script that requires MySQL ver. 5.6, and error flags with [No MySQL available] when I tried to install it just to see.

    The script developer tells me to move to a server with Cpanel, and that is out of the question, as I have used Plesk since version 7 or 8 I believe. I cannot get a refund either, as this is not a script failure, and I'm not going to write off $800 either, and there's no other script with what I need anyway.

    I have currently 2 servers with Plesk licenses, and I can experiment with one not so important.
    However, my time is on a tremendous squeeze, so I would like to start out with something that works without trying to experiment with version after version.

    Should I try to install the latest MariaDB 10.3, or is it possible to install a MySQL 5.6 as required, and a better option. I would appreciate your opinion. Thank you kindly!

  • Avatar
    Kevin Hudson

    I am running the latest version of Plesk Onyx for Linux 17.8.11 with CentOS 7.5.1804 and I want to Upgrade the MySQL Server from 5.5 to 5.7.

    For software specific reasons, I do not want to Upgrade to MariaDB 10.X. Does anyone know if the instructions above for CentOS 6 will work for CentOS 7.5?

  • Avatar
    Alexandr Redikultsev

    Hi @Bruno Schrotter!

    As MariaDB is a replacement for MySQL, upgrade it to MariaDB 10.1 (that is equal to MySQL 5.6). Just follow the instructions for CentOS 7, it should work as expected.

  • Avatar
    Alexandr Redikultsev (Edited )

    Hi @Kevin Hudson!

    Instructions for CentOS 6 will not work as CentOS 6 has MySQL by default.

    What you need to do in order to achieve your goal is to replace MariaDB with MySQL 5.5 and then upgrade MySQL 5.5 to MySQL 5.7. Replacement might have some issues with compatibility.

    I was not able to find the repo for MySQL 5.5 for CentOS 7, however if you find one, something like this should do the trick for you:

    1. Stop MariaDB:

    # service mariadb stop

    2. Remove it:

    # rpm -e --nodeps mariadb-server

    3. Add your custom repo with mysql 5.5.

    4. Install packages from this repo:

    # yum install mysql-server mysql-community-server

    5. Then, start the service, run mysql_upgrade:

    # service mysqld start
    # mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

    6. Refresh server components:

    # plesk sbin packagemng -sdf

    Note that you might want to install packages manually on step 4 in case you will not be able to find the repo on step 3. 

     

    Please, keep in mind that this instructions were not tested and I suggest to create a snapshot of the server as well as the backup of MySQL databases before doing so.

  • Avatar
    Bruno Schrotter

    Thanks @Alexandr Redikultsev!
    I very much appreciate your kind response and suggestion.

  • Avatar
    Alexandr Redikultsev

    You are welcome, @Bruno Schrotter!

  • Avatar
    Markus Wernecke

    Thank You very much Plesk Support Team ! ! ! It worked easy and successful like in the tutorial. Three days ago I reinitialized my 1und1 dedicated server with new Ubuntu 18.04.1 with Plesk 17.8.11 and MariaDB 10.1.36.

    NOW MariaDB 10.2.18 - PLESK is awesome 'n' great - Greets

  • Avatar
    Alisa Kasyanova

    @Markus Wernecke

    Good to know that the article helped! Enjoy your Plesk :)

Please sign in to leave a comment.

Have more questions? Submit a request