Is it possible to replace MariaDB 5.5, 10.X with MySQL 5.6, 5.7 on a Plesk server

Follow

Comments

4 comments

  • Avatar
    Anton Maslov

    Hello Josh,

    >MariaDB 10.2 is *not* a drop-in replacement for MySQL 5.7

    This is mentioned on MariaDB website itself: MariaDB versions function as a "drop-in replacement" for the equivalent MySQL version

    But you are also right, there are some differences listed on their site. Plesk installs MariaDB because it is a default one for CentOS 7 for example. To replace it with MySQL 5.7 you may follow their official documentation

    0
    Comment actions Permalink
  • Avatar
    Josh Jensen

    The issue though is MariaDB 10.2 is *not* a drop-in replacement for MySQL 5.7. There are numerous missing features related to json (i.e. json_objectagg) that are present in mysql version 5.7, but not in MariaDB 10.2. So the question still remains (which your docs did not actually answer here) how do I upgrade MariaDB 10.2 to MySQL 5.7 in place so that there is not data loss?

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello cacarr

    First of all, I would recommend updating MariaDB to 10.2 using the instruction for your OS from here: https://support.plesk.com/hc/en-us/articles/213403429

    Af for replacing itself, I see no official replacement instruction in the official documentation for Ubuntu (for YUM-based only): https://dev.mysql.com/doc/refman/5.7/en/replace-third-party-yum.html

     

    As I can see from the comment in another article, you've chosen to install MySQL before Plesk itself.

    0
    Comment actions Permalink
  • Avatar
    cacarr

    I have Plesk Obsidian on Ubuntu 18.04 with, unfortunately, MariaDB 10.1

    I need to replace MariaDB with MySQL 5.6 or 5.7 -- in my case, MariaDB is not a drop-in replacement, owing to some incompatibility with a WP migration tool I'm using. 

    If someone could point me in the right direction, I would appreciate it.  

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request