Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1645
  • Last Modified:

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?
0
ccbergman
Asked:
ccbergman
4 Solutions
 
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
 
NickUpsonSenior Network 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now