MariaDB 10.3 support in Plesk

Follow

Comments

21 comments

  • Avatar
    Roman Bendik

    That's exactly how you can know when support 10.3?

    I made an upgrade MariaDB according to your guide, but there was no information that the latest version does not support.

     

    1
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Roman,

    There is no exact ETA but work on the implementation is in progress.

    Here you may find the software versions compatible with Plesk.

    1
    Comment actions Permalink
  • Avatar
    Michael

    That's good to know but is there a plugin or something that moves existing installations from 5.x to 10.x? I am starting to get a few warnings from various wordpress themes or plugins because of the older Mariadb that came with my original Plesk 17 installation. I looked at the instructions for moving my sites to 10X from 5X but they are a bit onerous. Also is there a way for Plesk to run multiple versions of Mariadb? Don't know if its feasible with CentOS but being able to run multiple versions of Mariadb would be nice allowing newer installations to take advantage of later iterations and not be stuck at whatever came with the original installation. Just a thought. Thanks.

    0
    Comment actions Permalink
  • Avatar
    Daria Gavrilova

    Hello @Michael,

    Let me address your questions one by one:

    > That's good to know but is there a plugin or something that moves existing installations from 5.x to 10.x?
    There is no way to move existing installations to the newer MySQL version, but upgrade it only.
    More information on this matter can be found here: How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux?

    > Also is there a way for Plesk to run multiple versions of Mariadb?
    Currently using multiple MySQL versions on local Plesk server is not implemented yet.
    Thus I can suggest you to take part in our product improvement by referring to the following link: Multiple MySQL Versions configureable over Panel

    As a workaround, Plesk Onyx with Docker provides possibility to install different MySQL versions as Docker containers, this would allow to connect MySQL servers from Docker containers as remote Database server in Plesk.
    Here you may find more information on this matter:

    1
    Comment actions Permalink
  • Avatar
    Michael

    Hi @Daria Gavrilova,

    Thanks for your suggestions. I checked out the "How to upgrade....on Linux?" link and it was so full of caveats and warnings as well as a person or so that felt the instructions didn't work for them 100%. I'll make a recommendation to the Plesk team and the WP Toolkit team to kind of look at this issue as it relates to their products. I will revisit this when Plesk Obsidian/CentOS 8 is available then I'll move forward with something. Some of us wear a few different hats and when you're just trying to implement a new site or feature, having to address your entire infrastructure to do it is a detour. Plesk is so feature rich and the focus on devs and Docker makes complete sense however even as a dev sometimes you need the shortest route to the desired outcome, even if you can roll your own. One idea is that the Wordpress Toolkit can maybe just roll out an entire installation(s) on Docker which keeps control and maintenance centralized but increases. Thanks again.

    0
    Comment actions Permalink
  • Avatar
    Daria Gavrilova

    Hello @Michael,

    Thank you for your valuable feedback.
    We really appreciate it!

    > One idea is that the Wordpress Toolkit can maybe just roll out an entire installation(s) on Docker which keeps control and maintenance centralized but increases.
    To make our customers ideas alive ones, we have the User Voice portal, where you may suggest a new feature/product improvement and our developers will check it.
    The top-ranked suggestions are likely to be included in the next versions of Plesk.

    0
    Comment actions Permalink
  • Avatar
    Putnins Nils

    I'm currently running Plesk Obsidian Version 18.0.16 on a Dedicated Server, but the MariaDB is still Server version: 10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04. How is it possible to upgrade MariaDB to 10.3?

    0
    Comment actions Permalink
  • Avatar
    Nikita Nikushkin

    Hello @Putnins Nils

    You can try to perform an upgrade by using similar steps from this article (do not forget to change the repository to MariaDB 10.3):

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

    However, keep in mind that Obsidian is not in the stable tier yet, thus, all actions are performed at your own risk

    0
    Comment actions Permalink
  • Avatar
    Multimedia Pool (Edited )

    Hi, last week I made the official upgrade to Obsidian 18.0.19 (Ionos). Until today no upgrade to MariaDB 10.3 suggested/performed by Plesk. Do I have to do it by my own or does PLESK release an official upgrade over Updates/Upgrades and/or CLI? Greets

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    @Markus,

    Plesk uses MySQL server provided from default OS repositories. MariaDB 10.3 is not a default one. It is needed to upgrade it manually, please follow this aritcle, but make sure following instructions you are replacing 10.2 to 10.3 everywhere.

    0
    Comment actions Permalink
  • Avatar
    Multimedia Pool (Edited )

    Hi Anton,

    that's why I love PLESK and PLESK SUPPORT TEAM + FORUM so much. Again here on Ubuntu 18.04.3 / Obsidian, like on Onyx to 10.2 last year, the todays upgrade to 10.3 upgrade worked like a charm. Thanks a lot. On MariaDB.org they classified MariaDB 10.3 as Old and suggest 10.4.

    Is it possible to update to 10.4?

    I know that PLESK SUPPORT is publishing Obsidian doesn't support MariaDB 10.4. But perhaps it was only until last weeks RTM upgrade. Perhaps it is possible now after releasing the official Obsidian RTM version?

    0
    Comment actions Permalink
  • Avatar
    Lev Iurev

    @Marcus,

    We do not recommend the upgrade to MariaDB 10.4 until we officially define that we support it. Currently Plesk does not support MariaDB 10.4

    0
    Comment actions Permalink
  • Avatar
    Emmanuel Corwin Flossie

    Is there a plan for the auto-upgrade feature which is currently integrated for the Windows version, also coming to Linux in the future?

    I would love to see this feature integrated. As a non system admin, this is one area I currently struggle with.

    0
    Comment actions Permalink
  • Avatar
    Leonid Gukhman

    @Emmanuel Corwin Flossie

    Could you clarify what auto-upgrade is meant?

    0
    Comment actions Permalink
  • Avatar
    Emmanuel Corwin Flossie

    @Leonid Gukhman

    For example with PHP, you can upgrade to new versions with the Plesk UI. No advanced system knowledge is required.

    However with mariadb, to upgrade from 10.1 to 10.x you need to follow lots of advanced system steps and need system knowledge to upgrade. Because I noticed it is now possible in MariaDB to easily update (based on the update notes for Obsidian) I thought this would also come to Linux bases Plesk. So was wondering if in the future this would come linux.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Emmanuel,

    Thank you for the clarification.

    Plesk by design installs MySQL server version, which is supplied by OS vendor. Currently, there're no plans to change this approach.

    The steps to perform manual MySQL upgrade are documented in details in this article: https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux-

    This administrative operation may be done by our Professional team on a paid basis: https://www.plesk.com/professional-services/administrative-services/

    0
    Comment actions Permalink
  • Avatar
    Emmanuel Corwin Flossie

    Hi Ivan, thank you very much for the reply and definitely will look into the pro service. Thanks :)

    0
    Comment actions Permalink
  • Avatar
    Robert

    On Obsidian I`m getting this error now?

    2019-11-08 06:25:46 INFO: updating packages: mysql-common libmariadb3 unattended-upgrades python3-gdbm
    2019-11-08 06:25:46 ERROR: Failed to fetch http://mirrors.coreix.net/mariadb/repo/10.3/ubuntu/pool/main/m/mariadb-10.3/libmariadb3_10.3.19+maria~bionic_amd64.deb 404 Not Found 

    0
    Comment actions Permalink
  • Avatar
    Anzhelika Khapaknysh (Edited )

    @Robert,

    This package was removed from repositories by MariaDB as it caused bug https://jira.mariadb.org/browse/MDEV-20987.

    0
    Comment actions Permalink
  • Avatar
    Robert

    So what now? i just followed the update guide.

     

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Robert,

    > On Obsidian I`m getting this error now?

    Generally, this instruction is independent from Plesk version.

    > So what now? i just followed the update guide.

    The issue is fixed on the MariaDB side. Following the instruction once again should go fine now.

    Check this article for more information:

    https://support.plesk.com/hc/en-us/articles/360010401659-MariaDB-does-not-start-after-update-on-November-the-5th-Assertion-failure-in-file

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request