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.

Should I move to maria DB ?

Discussion in 'Database Discussions' started by Sujoy Dhar, Jul 28, 2016.

Tags:
  1. Sujoy Dhar

    Sujoy Dhar Member

    Joined:
    Jul 24, 2016
    Messages:
    20
    Likes Received:
    5
    Trophy Points:
    3
    Location:
    India
    cPanel Access Level:
    Root Administrator
    I have seen that many peoples are mentioning that Marian DB is better than MSQL so should I move to Maria DB ?

    Does Wordpress supports it ?

    Also if new user from other server want to come to my new server with msql database then what I can do to make it maria db ?
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    Yes, You can upgrade your mysql version to MariaDB and yes WordPress support MariaDB so that you will not face any issues with the WordPress and MariaDB.
     
  3. Sujoy Dhar

    Sujoy Dhar Member

    Joined:
    Jul 24, 2016
    Messages:
    20
    Likes Received:
    5
    Trophy Points:
    3
    Location:
    India
    cPanel Access Level:
    Root Administrator
    What about the new client who are coming from other server with msql ?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,787
    Likes Received:
    665
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Yes, it's possible to import a MySQL database dump into MariaDB. MariaDB is referred to as a "Drop-In-Replacement" for MySQL. I've seen very few reports of error messages or website compatibility problems from users who have upgraded to MariaDB from MySQL. That said, it's important to read our documentation when switching to MariaDB, as there are some caveats (e.g. you can't switch back to MySQL after upgrading to MariaDB):

    MySQL or MariaDB Upgrade

    There's also some additional information you may find helpful at:

    https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

    Thank you.
     
  5. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    538
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Should you migrate to MariaDB? That's a question only you can answer. However, for the most part, I have yet to see a reason why not to migrate. It just works better, from my own experience.

    Won't notice a thing (assuming you meant MySQL). MariaDB is a drop in replacement for MySQL, meaning if it works with MySQL, it'll work with MariaDB.
     
  6. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, your new clients will not face any issue if they are coming with MySQL. MariaDB is much better than MySQL. You will definitely see the difference in performance of site.
     
Loading...

Share This Page