MongoDB is the New MySQL

Re:MongoDB is the New MySQL by Joakal on Wednesday July 06, 2011 @05:29PM (#2735965)

If you don't have need for relational integrity, then MySQL is a liability. MongoDB does not have relational integrity which is one of the reasons why it's faster.

eg Real-time analytics

If you need a pre-planned schema from database over making one on the fly (even accidentally), then MySQL is better as MongoDB is schema-less.

eg Rapidly changing input

If you are worried about Oracle's acquisition of Sun and MySQL (Switching to Postgre is the closest alternative though).

MySQL sharding is hard, MongoDB can automate it to a certain extent (MySQL requires third party tools I believe).

eg Distributing large datasets

Note: Other databases, eg Cassandra can also automate 'sharding' for example.

[ Parent | on HN ]

Re:MongoDB is the New MySQL by stonemetal on Wednesday July 06, 2011 @07:28PM (#2736445)

If you don't have need for relational integrity, then MySQL is a liability. MongoDB does not have relational integrity which is one of the reasons why it's faster.

When did Mysql have relational integrity?

[ Parent | on HN ]

Re:MongoDB is the New MySQL by Joakal on Wednesday July 06, 2011 @07:33PM (#2736460)

For a long time: http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-key...

[ Parent | on HN ]

Re:MongoDB is the New MySQL by stonemetal on Saturday July 09, 2011 @10:00AM (#2745589)

Yes, but it is easily disabled.

[ Parent | on HN ]

Re:MongoDB is the New MySQL by unicornporn on Wednesday July 06, 2011 @06:38PM (#2736280)

Isn't MariaDB an even closer alternative than Postgre?

[ Parent | on HN ]

Re:MongoDB is the New MySQL by Joakal on Wednesday July 06, 2011 @07:35PM (#2736464)

I had to look up MariaDB, that's true in the codebase sense from the gist of it. Postgre is more popular than MariaDB I suppose.

[ Parent | on HN ]

Re:MongoDB is the New MySQL by fhars on Thursday July 07, 2011 @02:11AM (#2737419)

There is no such thing as "postgre".

[ Parent | on HN ]