1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 MariaDB 10

Discussion in 'XenForo Questions and Support' started by xmlxp, Jun 7, 2016.

  1. xmlxp

    xmlxp Active Member

    Hi All

    I am moving to a new dedicated server but I found out it comes with MariaDB not Mysql.

    Whats the difference between MariaDB and MySql in terms of:
    1. backup and restore command lines
    2. optimization
    3. my.cnf file settings

    is the same exactly and I can just copy/paste my.cnf content of mysql to matiadb? ( both servers almost the same hardware)

    Does it worth it to move from MySql to MariaDB?
  2. Slavik

    Slavik XenForo Moderator Staff Member


    More optimized out the box

  3. xmlxp

    xmlxp Active Member

    Thank you slavik

    is there any known issues between MariaDB10 and xenforo script and all its add-ons?
  4. Mike

    Mike XenForo Developer Staff Member

    We have customers running MariaDB without issue.
  5. Tracy Perry

    Tracy Perry Well-Known Member

    If you don't have to have a cPanel setup, then I'd recommend installing CentOS on your server and using @eva2000's CentMin install. It will install nginx (high performance HTTP server), mariaDB, your PHP processor and PostFix for you. Setting the domains up is very easy with it.

    Screen Shot 2016-06-10 at 1.46.56 AM.png
    eva2000 and BobbyWibowo like this.
  6. BobbyWibowo

    BobbyWibowo Well-Known Member

    +1 to Tracy Perry's suggestion. Another Centmin Mod user here and I've had no issue running XenForo with MariaDB for months.
    eva2000 likes this.
  7. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    so Cpanel Updated today and they suggest moving to MariaDB, now I have Percona Server installed, Installed that manually. so I'm not sure if cpanel will upgrade it properly though. I don't want my data being corrupted. and is MariaDB any better then Persona Server??

    Screen Shot 2017-02-01 at 1.34.05 am.jpg
  8. Brent W

    Brent W Well-Known Member

    I would stick with Percona personally. We only use MariaDB 10.1 because of its use in CentminMod.
  9. XxUnkn0wnxX

    XxUnkn0wnxX Active Member

    I would only upgrade if MariaDB had higher speed as in faster requests, better performance anything to help improve overall site speed and load times...

    or even when updating/installing add-ones as I know rebuilding templates is all SQL queries and wish there was something to improve overall query speed..

Share This Page