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

Follow

Comments

224 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

Please sign in to leave a comment.

Have more questions? Submit a request