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

Follow

Comments

12 comments

  • Avatar
    Wyk Parish (Edited )

    On Plesk Version 18.0.49 Update #2, Ubuntu 18.04, and upgrading MariaDB from 10.1 to 10.6.1.  The instructions here didn't work for me as is. Here are the changes in hopes it will help others in my scenario:

    1. In Step 1, I had to be the root user (ie. "sudo -s").  Otherwise I would get a "Permission denied" error trying to access the password file.
    2. In Step 6, the mariadb-server wouldn't restart with the error mentioned in this article.  However, the "/etc/my.cnf" file mentioned in that article did not exist on my system. Instead I made the edit to the "/etc/mysql/my.cnf" file  (ie. changing the line "bind-address = ::ffff:127.0.0.1" to "bind-address = 127.0.0.1"). Then restarting the mariadb-server succeeded and the rest of the instructions seemed to go as planned.
    0
    Comment actions Permalink
  • Avatar
    HaiSoft User

    According to Plesk Changelog, MariaDB 10.11 is supported since Plesk Obsidian 18.0.52, right ?

    1
    Comment actions Permalink
  • Avatar
    Kelvin Oliveira

    Is there any procedure like this but for Windows?

    1
    Comment actions Permalink
  • Avatar
    Sam Hawkins

    Has anybody got any steps for AlmaLinux?

    0
    Comment actions Permalink
  • Avatar
    Julian Bonpland Mignaquy

    Sam Hawkins Hi!

    Please go for Plesk on CentOS 7 / RHEL 7.

    0
    Comment actions Permalink
  • Avatar
    Andy Morgan (Edited )

    Hi Julian, we're using Plesk Obsidian v18.0.54 on CentOS 7, and the current MySQL version is MariaDB 5.5.68 

    only for upgrading default MariaDB 5.5 to the MariaDB 10.5 version

    Since I cannot afford to mess anything up, I want to be crystal clear what you mean by "default" 5.5. Is this only 5.5.0? Would our 5.5.68 qualify for the Automatic Method above, or is Manual mode necessary? What's the likelihood of this failing and what would one do at that point? Reinstall 5.5.68 manually and import from backup?

    Thanks. I think twice before running significant command lines that could cost me many hours of precious time.

    0
    Comment actions Permalink
  • Avatar
    Julian Bonpland Mignaquy

    Please go for the Manual Method, in case you hit any error you will know where it is.

    Since you are running 5.5 first upgrade to 10.5 and then repeat the procedure to 10.6 if you wish.

    0
    Comment actions Permalink
  • Avatar
    Dimitrios Matsoukas

    there were many many useful comments on this article over the years but disappeared

    Could you bring back?

    0
    Comment actions Permalink
  • Avatar
    Joe Berry

    We had a bit of an issue on Ubuntu 18.04:

    root@x:~# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.4
    # [info] Checking for script prerequisites.
    # [warning] Found existing file at /etc/apt/sources.list.d/mariadb.list. Moving to /etc/apt/sources.list.d/mariadb.list.old_6
    # [info] MariaDB Server version 10.4 is valid
    # [info] Repository file successfully written to /etc/apt/sources.list.d/mariadb.list
    # [info] Adding trusted package signing keys...
    # [info] Running apt-get update...
    E: The repository 'https://dlm.mariadb.com/repo/maxscale/latest/apt bionic Release' does not have a Release file.
    # [error] Failed to add trusted package signing keys

     

    To fix this, we updated the repository file /etc/apt/sources.list.d/mariadb.list with an updated download URL for MariaDB, from their website https://mariadb.org/download/?t=repo-config. From this link, you will also be able to choose a version of MariaDB which is currently available to download, as 10.2 is no longer available even though it is specified in this article.

    # MariaDB 10.4 repository list - created 2023-08-30 13:03 UTC
    # https://mariadb.org/download/
    # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
    # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.4/ubuntu bionic main
    deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mariadb.gb.ssimn.org/repo/10.4/ubuntu bionic main
    # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mariadb.gb.ssimn.org/repo/10.4/ubuntu bionic main

    Note that by copying this you will be using a UK Mirror Server to download the distribution. 

    Then running apt-get update and apt-get install mariadb-server should work. 

    0
    Comment actions Permalink
  • Avatar
    Unnamed User

    Hai, i need tutorial for Almalinux 8.8 

    0
    Comment actions Permalink
  • Avatar
    Julian Bonpland Mignaquy

    Hi Unnamed User, i used the instructions for Centos 8. I have updated the title with Almalinux 8. As for step 5 you can select the OS RHEL 8. (Almalinux is based on RHEL 8)

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request