Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MariaDB/MySQL Datafile-level Compatibility

Discussion in 'Database Discussion' started by MajorLancelot, Jan 22, 2018.

Tags:
  1. MajorLancelot

    MajorLancelot Active Member

    Joined:
    Dec 17, 2014
    Messages:
    26
    Likes Received:
    4
    Trophy Points:
    78
    Location:
    Shinjuku-ku, Tokyo, Japan
    cPanel Access Level:
    Root Administrator
    MariaDB is on the path of gradually diverging from MySQL. One obvious example is the internal data dictionary currently under development for MySQL 8.

    This will be a major change to the way metadata is stored and used within the server, and MariaDB doesn’t have an equivalent feature. Implementing this feature could potentially mark the end of datafile-level compatibility between MySQL and MariaDB.

    Please, what is the plan going forward for cPanel customers who are currently using MariaDB via the MySQL/MariaDB upgrade feature?

    Thanks.
     
  2. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,659
    Likes Received:
    76
    Trophy Points:
    328
    cPanel Access Level:
    Root Administrator
    You probably want to wait for a better cPanel response to get a clearer picture of this.

    But it's my understanding that cPanel itself has moved away (or at least in the process of moving away) from depending on any MySQL/MariaDB structure for any of their internal systems (mostly moving to an sqlite3 solution).

    While I would probably agree that it would serve cPanel best to choose one or the other in terms of providing MySQL or MariaDB (I thought they were moving to MariaDB... but now may be moving back to MySQL?) I think the path they are going down is to provide both MariaDB and MySQL. How that will apply with interoperability, i.e. when transferring accounts from a MySQL server to a MariaDB server, I do not know. These are things that cPanel tends to not think about until some type of system has to be hurriedly put together.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello @MajorLancelot,

    We recently published a blog that includes some background information about why we decided to support MySQL 5.7:

    Being a Good Open Source Community Member: Why we hesitated on MySQL 5.7 | cPanel Blog

    Per that blog post:

    Feel free to review that blog post (there are a couple of comments at the bottom to review as well), and let us know if you have any additional questions.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice