Get the most out of your Centmin Mod LEMP stack
Become a Member

Is MariaDB the best solution for huge databases?

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, Jan 30, 2016.

  1. pamamolf

    pamamolf Well-Known Member

    2,491
    229
    63
    May 31, 2014
    Ratings:
    +390
    Local Time:
    12:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hi

    Is MariaDB the best solution for huge databases or is there any other software that can perform better with huge data like 500GB database for example?

    Thanks :)
     
  2. pamamolf

    pamamolf Well-Known Member

    2,491
    229
    63
    May 31, 2014
    Ratings:
    +390
    Local Time:
    12:58 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    What about MongoDB or Hadoop?
     
  3. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,574
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,756
    Local Time:
    7:58 AM
    Nginx 1.13.x
    MariaDB 5.5
    It's not just the database software used but how you use it, configure it and optimise it.

    MariaDB 10.1, Percona 5.6/5.7 and Oracle MySQL 5.7 all have the potential to handle large databases extremely well. It all depends on how you configure it and what hardware you pair it up with that matters. Just using MariaDB 10.1, Percona 5.6/5.7 or Oracle MySQL 5.7 won't magically improve your performance without knowing how to properly optimise and tune your database configurations (assuming you've already had the database queries are optimised too).

    Private paying clients I have worked with large databases, had anywhere from 50-400% improved performance just from me optimising and tuning their MySQL settings and that's on either MariaDB, Percona or Oracle MySQL servers :)

    For instance for the average size server that is derived from Centmin Mod Survey 2016 survey, I would say most folks won't notice much difference if they were using MariaDB 5.5 or 10.0 or 10.1 with out of box default pre-optimised base default settings.
     
    • Informative Informative x 1
  4. RoldanLT

    RoldanLT Well-Known Member

    3,828
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    5:58 AM
    1.11
    10.2
    Be sure to use fast SSD setup server.
    MYSQL/MariaDB relies mostly on CPU and SSD :).

    and your fine using default centminmod config.
    I even lower the innodb buffer pool and increase SSD in/out config always.
     
    • Like Like x 1