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

Follow

Comments

245 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
  • Avatar
    M SZ (Edited )

    I am on Debian 10.12 with Plesk 18.0.45 and recently updated MariaDB to 10.5 as per this guide.

    All went well.

    Only thing that I get recently an error notification from the System updates tool.
    It states that the repository has no longer a release file...

    Reason: 2022-08-16 06:25:19 INFO: pum is called with arguments: ['--list', '--repo-info', '--json']
    2022-08-16 06:25:21 ERROR: E:The repository 'https://mirror.docker.ru/mariadb/repo/10.5/debian buster Release' no longer has a Release file.
    2022-08-16 06:25:21 ERROR: Exited with returncode 1.

    Does this guide need an update accordingly or is it just a temporary repository fluke?

     

    Edit/Additon: In general wouldnt it be preferable to use links to official repositories?

    Form here: https://mariadb.org/download/?t=repo-config&d=Debian+10+"buster"&v=10.5

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello M SZ,

    The error may appear when non-standard repositories are used. The solution from the following article will be helpful in this case: https://support.plesk.com/hc/en-us/articles/360002961854.

    It is always preferable to use official repositories.

    1
    Comment actions Permalink
  • Avatar
    M SZ

    Anastasia Zyrianova thanks for your response and glad that we agree.

    I wrote my comment / question because the example in your guide in this specific article uses a non-official repository:

     https://mirror.docker.ru/mariadb/repo/10.x/debian buster main'

    Therefore my suggestion to change this guide/article here and also use official repos going forward.

    0
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova

    Hello M SZ,

    The article was updated.

    1
    Comment actions Permalink
  • Avatar
    Robert Krölls

    Update Guide for ubuntu 22.04 and latest supported Mariadb version

    -1
    Comment actions Permalink
  • Avatar
    Anastasia Zyrianova (Edited )

    Hello Robert Krölls,

    The latest supported version of MariaDB, for now, is MariaDB 10.6: https://docs.plesk.com/release-notes/obsidian/software-requirements/#s4. Ubuntu 22.04 comes with MariaDB 10.6 so no upgrade path is currently available for this OS.

    0
    Comment actions Permalink
  • Avatar
    CVISNET

    Upgrade from MariaDB 5.5 to 10.5 using the Automatic method is working on my end.

    Currently installed:
     - Plesk Obsidian Version 18.0.46
     - CentOS Linux 7.9.2009 (Core)

    0
    Comment actions Permalink
  • Avatar
    Jecalderon

    Has anyone experience trouble migrating from Ubuntu to Debian.

    experimented issues with migration MySQL db to MariaDB ? some
    website do not run.

    0
    Comment actions Permalink
  • Avatar
    Thomas Hellwig

    Please add:

    0
    Comment actions Permalink
  • Avatar
    Patrick McLaughlin (Edited )

    There's a step missing when upgrading from MariaDB:10.5 to MariaDB:10.6 on CentOS 7

    After Step 8, the service will fail to start.

    THE CAUSE: MariaDB 10.6 does not allow to bind both ::1 and 127.0.0.1 via the setting bind-address = ::ffff:127.0.0.1 in the file /etc/my.cnf.

    THE FIX: https://support.plesk.com/hc/en-us/articles/5180170766738-Unable-to-start-MariaDB-10-6-on-a-Plesk-server-Bind-on-TCP-IP-port-Got-error-22-Invalid-argument

    After editing your my.cnf file and restarting mariadb service, proceed to Step 10 and finish installation.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request