Learn about Centmin Mod LEMP Stack today
Register Now

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,725
    243
    63
    May 31, 2014
    Ratings:
    +434
    Local Time:
    11:41 PM
    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,725
    243
    63
    May 31, 2014
    Ratings:
    +434
    Local Time:
    11:41 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    What about MongoDB or Hadoop?
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,193
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,143
    Local Time:
    6:41 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,901
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    4:41 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