Menu
Have a simple question here. I've a database with around 1 billion records, a server with 200GB of ram to handle it.
What do you suggest for best performances? Mysql 5, Mysql 6 or MariaDB?
927
The developers designed it as a drop-in replacement of MySQL. Since it was forked from MySQL, basically all of the structures MariaDB uses are the same.
When it comes to performing queries or replication, MariaDB is faster than MySQL. So if you need a high-performance relational database solution, MariaDB is a good choice. In addition, MariaDB also easily supports a high concurrent number of connections without much performance degradation.
Today, both databases are very popular and are used extensively by the developer community. MySQL is ranked second among the relational databases and second overall (Oracle database being first). MariaDB is behind - ninth among the relational databases and fourteenth overall.
About MariaDB Although MySQL is still an open source project, it is owned by Oracle, purveyors of their own enterprise software. Worries about the progress of MySQL as well as the status of MySQL as an open source project have prompted the migration to MariaDB.
MariaDB 5.3 should give you the best performance:
See http://kb.askmonty.org/en/what-is-mariadb-53 for a list of features.
178
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
