How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Follow

Comments

230 comments

  • Avatar
    Renan Moreira

    maartenv thanks for notifying us, article will be fixed

    0
    Comment actions Permalink
  • Avatar
    Javier Cota

    The upgrade script link is broken for CentOS 7

     

    [root@srvr ~]# wget https://plesk.zendesk.com/hc/article_attachments/360022419980/mariadb-10.5-upgrade.sh && chmod +x mariadb-10.5-upgrade.sh
    --2022-03-08 21:18:39--  https://plesk.zendesk.com/hc/article_attachments/360022419980/mariadb-10.5-upgrade.sh
    Resolving plesk.zendesk.com (plesk.zendesk.com)... 104.16.51.111, 104.16.53.111
    Connecting to plesk.zendesk.com (plesk.zendesk.com)|104.16.51.111|:443... connected.
    HTTP request sent, awaiting response... 404 Not Found
    2022-03-08 21:18:40 ERROR 404: Not Found.

    Can someone please provide the updated link?

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello Javier Cota,

    The link was updated. Thank you for bringing it to our attention!

    0
    Comment actions Permalink
  • Avatar
    Maximilian Wilke

    I would recommend to add a:

    yum clean all

    to the script to prevent problems with old yum cache.

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello Maximilian Wilke,

    Thank you! Both automatic and manual solutions for Centos 7 were updated accordingly.

    0
    Comment actions Permalink
  • Avatar
    maartenv

    Can you please update the article and explain how to add MariaDB to the WatchDog service? What are the commands to start MariaDB again using WatchDog?

    0
    Comment actions Permalink
  • Avatar
    giuseppe amodio

    Regarding Centos 7 instructions are uncorrect as it's not possibile to install automatically the upgrade as Superuser while it's needed to be root to execute the script.

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello giuseppe amodio,

    Thank you for your comment. I've re-tested the script on a test server. It is possible to execute it as Superuser using the 'sudo ./c7-mariadb-10.5-upgrade.sh' command. 
    So the following statement from the article is correct:

    To start an upgrade of MySQL/MariaDB, connect to a server via SSH as root/superuser and follow the instructions for your operating system:

     

    0
    Comment actions Permalink
  • Avatar
    Daniel West

    It should be noted that in /etc/yum.conf there is an exclusion by default for MariaDB.

    `exclude=MariaDB*`

    You should comment this out so the yum install will work and then add the exclusion again after.

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello Daniel West,

    During the Plesk installation, no excludes are added to the `/etc/yum.conf` configuration file from the Plesk side by default. The '/etc/yum.conf ' file may be modified by the server provider/hosting provider. Still, thank you for noticing. This information can be helpful.

    0
    Comment actions Permalink
  • Avatar
    Peter Debik

    If I remember correctly, the "exclude=MariaDB" resulted from a situation where an automatic update updated MariaDB to a version that failed with certain database attributes and was shortly revoked after publication. At that time the advice was to exclude MariaDB from automatic updates (from Yum respectively). So indeed, this is an "extra" user-driven configuration that is not the MariaDB or Yum default.

    0
    Comment actions Permalink
  • Avatar
    Carlos Lopez

    Hello,

    What do I need to change to upgrade to 10.6 on CentOs 7?

    Thanks in advance.

    0
    Comment actions Permalink
  • Avatar
    Malaka Udawatta

    Tried to upgrade using the Automatic method but MariaDB failed to start after the upgrade. Then followed the following article to fix the corruption.

    https://support.plesk.com/hc/en-us/articles/213939865-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-databases-on-Plesk-for-Linux-

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello Carlos Lopez,

    To update to MariaDB 10.6 on Centos 7 you will need to apply the Manual Solution for Centos 7. In step 6 it will be required to open the Setting MariaDB repositories page, select your OS distro, release, and desired MariaDB version, and place the provided output to the `/etc/yum.repos.d/MariaDB.repo` file as per steps 6.1 and 6.2.

     

    0
    Comment actions Permalink
  • Avatar
    antonio dolce

    Hello all,

    I need to upgrade only MariaDB. Is this possible or have I to upgrade MySQL too?

    THX

    tony

    0
    Comment actions Permalink
  • Avatar
    Gilbeto Salazar

    I have upgraded from version 5.1 to 5.5 and it went very well.

    Now I am trying to update from 5.5 to 5.7, when I finish all the steps this is the message I get.

    This installation of MySQL is already upgraded to 5.5.55, use --force if you still need to run mysql_upgrade

    I've got:
    OS: CentOS 6.10 (Final)
    Product: Plesk Obsidian 18.0.31

    someone who can help me

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello antonio dolce,

    This article describes several scenarios for different OSes and MySQL/MariaDB versions. You may use only the one that is suitable in your case and omit the others.

    0
    Comment actions Permalink
  • Avatar
    ratepersqft .com

    Thank you Plesk team,

    We followed all the instruction from section - Plesk on Ubuntu 18.04, for upgrading mariadb to 10.3.

    and we succeeded in one shot without a single error,

    just in one place we stuck, that we wanted to upgrade to mariadb 10.4, but when I added the repository, it said that current i386 structure don't support 10.4 mariadb, but later I added repository for mariadb 10.3,, but still it was showing i386 error.

    later I moved to "/etc/apt/sources.list" and commented the mariadb10.4 line  and continued the previous process of installation, and it installed the latest mariadb10.3 smoothly

     

    Regards Ganesh

     

    0
    Comment actions Permalink
  • Avatar
    maartenv

    Can you please update the list of MariaDB versions? The current list contains versions that are no longer supported by the vendor (end-of-life):

    https://endoflife.date/mariadb

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello maartenv,

    The article contains the list of outdated MariaDB versions for better searching, so the servers with EOLed MariaDB versions can also be upgraded. However, thank you for providing the link. It can be helpful for others. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request