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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB/MySQL Datafile-level Compatibility

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

Tags:
  1. MajorLancelot

    MajorLancelot Member

    Joined:
    Dec 17, 2014
    Messages:
    17
    Likes Received:
    3
    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,547
    Likes Received:
    44
    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:
    41,502
    Likes Received:
    1,616
    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.
     
Loading...

Share This Page