Database Evaluation: MariaDB vs. MySQL vs. PostgreSQL

I have been performing internet searches on information regarding databases MariaDB, MySQL, and PostgreSQL for our next generation database.  Anybody have comments and/or experience on the subject?
ccbergmanAsked:
Who is Participating?
 
dpearsonCommented:
Obviously the choose of DB depends a lot on your intended usage but I'd say in general:

a) MySQL beats PostgreSQL almost always for a production db.
    Reason?  MySQL has a *massive* install base and hundreds of thousands of successful projects.  PostgreSQL is "purer" from a SQL standpoint but it has nothing like the sort of following or install base to point to indicating its ability to handle whatever is thrown at it.
    This also means that when you wish to hire talented DBAs to work on the database you are drawing from a much larger pool, so you can get better talent for the same dollars.

b) MySQL vs MariaDB I can't personally comment on.  I'm not personally aware of anyone using Maria.  If you are interested in essentially patched versions of MySQL I'd suggest instead having a serious look at Percona:
http://www.percona.com/software/percona-server

Those guys are well respected in the MySQL space and they are offering something similar to Maria - a variation on MySQL with various stable patches and performance improvements built in.  I know a bunch of companies using the Percona build instead of generic MySQL and having good success.

Hope that helps,

Doug
0
 
Nick UpsonPrincipal Operations EngineerCommented:
did you consider firebird, I know of several projects that have moved to it from mysql
0
 
awking00Commented:
What was your past generation database?
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
ccbergmanAuthor Commented:
Our current database is MS SQL.
0
 
gheistCommented:
It depends on how MS-SQL specific your SQL code is.
Only PostgreSQL will allow to define operands and functions for e.g. running oracle-only SQL statements.
But others are options if your SQL works right away,.
0
 
ccbergmanAuthor Commented:
Thank you.  Every bit of information from users helps me piece together the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.