MySQL is to SQL like MongoDB to NoSQL

While a lot of people people have disagreed with this guy in the past, I find it very hard to disagree with him in most of his posts.<p>My exposure, as far as SQL goes, has been MsSQL, PostgreSQL and MySQL. With absolutely loads of MsSQL, and pretty hairy data structures at that (they have an aversion to the polyglot approach where I work) - SQL is one of the most enjoyable things that you can do once you get past the elementary &quot;SELECT WHERE&quot; (and stop using graphical development tools).<p>I have been saying what Markus said for a long time, MySQL is why RDBMS has a bad name and why the &quot;not using SQL&quot; movement exists. I really hope the MariaDB team spend their time where it is needed most (a join engine that doesn&#x27;t suck), if they haven&#x27;t already.<p>I mean, at the end of the day you have MySQL that can&#x27;t even do hash joins, and then you have PostgreSQL with GEQO: <a href="http://www.postgresql.org/docs/9.0/static/geqo-pg-intro.html" rel="nofollow">http:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;9.0&#x2F;static&#x2F;geqo-pg-intro.html</a>

I may be biased because I work on it, but I think TokuMX solves or will soon solve all of the &quot;big data scaling&quot; problems that exist in MongoDB.<p>There is definitely still room for polyglot strategies: Zookeeper is for tiny but crucially consistent data, Riak is for fancy distributed systems availability guarantees when you can afford a simple data model, and I believe Redis has value as a sophisticated programming model for things you can fit in RAM (but I actually have no Redis experience personally).<p>But in the past few months, I&#x27;ve grown to be really impressed with the document model, and the aggregation framework is getting more and more powerful with each release. I think that&#x27;s the important part of MongoDB (sharding&#x27;s a little messy and Riak seems to have their heads on straighter with that), and TokuMX takes that and sands off the rough edges you see with big data sets and concurrency, and I think that&#x27;s going to end up dominating MongoDB and being a really compelling point in the NoSQL space.

People like to give MongoDB shit, but is actually pretty fun to use. I wouldn&#x27;t use it as a &quot;big data platform.&quot; At scale I&#x27;d use Cassandra. For relational data I&#x27;d use postgresql. For memory caching, Redis. So when do I use MongoDB? For prototyping. Why? Because it&#x27;s fun to use.

At work we have an MS SQL Server instance managing ~1TB of data spread among various databases.<p>No one database is &gt; 200GB so it&#x27;s not &quot;web scale&quot; by any means but sometimes you need to pull out tricks like indexed&#x2F;materialised views.<p>I use Transact-SQL directly via ADO in C++ and ADO .NET in C# and indirectly via EF and NHibernate.<p>It&#x27;s easy to manage schema with SQL Server Data Tools and diagnosing a poorly performing query is straightforward with graphical execution plans.<p>Quite frankly, I don&#x27;t care that there are alternative RDBMS&#x27; or alternatives to traditional RDBMS.<p>But ... I keep hearing about problem after problem with MySQL. What&#x27;s the trick to using it successfully? Is the barrier to entry too low, and problems are from legions of rank amateurs? i.e. is it as simple as constructing your schema thoughtfully, with tables that are &quot;well-it&#x27;s-almost-3NF&quot; and making some educated guesses about which indexes might be needed in advance?

MySQL is also generally poorly &quot;designed&quot;. MySQL is to a database as PHP is to a programming language.

<a href="http://www.xaprb.com/blog/2013/10/01/mysql-isnt-limited-to-nested-loop-joins/" rel="nofollow">http:&#x2F;&#x2F;www.xaprb.com&#x2F;blog&#x2F;2013&#x2F;10&#x2F;01&#x2F;mysql-isnt-limited-to-n...</a>

Why is it that when it comes to databases no one is unbiased?<p>I cannot find any reliable articles on the web concerning database engines that I look at and trust the author. It&#x27;s even more difficult considering I am far from a pro with databases but quite simply I won&#x27;t use any MS products and so I&#x27;ve used MySQL for smaller projects. I&#x27;ve started using MongoDB a lot more lately and regardless of what people (mostly people who&#x27;ve never used it I would imagine) say about it I love it.

Comparing apples to oranges really, but I suppose it&#x27;s more accurate if you take into account all the people who are (or could be using) a relational database without much issue and then switching over.<p>The article is right though, I&#x27;ve heard scaling MongoDB into the hundreds of gigs to terabytes is an absolute nightmare for the operation team, the software is actually very cool when dealing with reasonably sized data that has an elastic structure.<p>There are other &quot;NoSQL&quot; databases out there that pay more attention to scale, like HBase. My HBase cluster is just over a TB compressed, consistently churning 6k requests a second, without an issue.

&gt; &quot;In my eyes, MySQL has done great harm to SQL because many of the problems people associate with SQL are in fact just MySQL problems&quot;<p>That&#x27;s a very strong and subjective statement. If any, resources heavy databases like Oracle or PostgreSQL, had brought more users to NoSQL than MySQL. That&#x27;s doesn&#x27;t there is something wrong with those databases, only that they weren&#x27;t the right tool for the job is some cases.<p>Also &quot;MySQL problems&quot; are most of the time due to poor usage, not to the database system itself, actually when used properly MySQL&#x2F;MyISAM is a great tool

I think a lot of the NoSQL hate comes from people who don&#x27;t understand the use-case, and don&#x27;t build High Availability&#x2F;Low Latency systems. A lot of the things I work on require pre-summarized data to provide fast response times at scale (aggregating normalized data would be too slow) and a NoSQL DB (not necessarily Mongo, I prefer Couchbase for most things) with a simple but flexible data model that gives more control to the developer Just Makes Sense.

You would think someone who claims to be an expert on databases would have a clue about his industry.<p>MongoDB is a document database and is as different from almost every other NoSQL database as it is from every SQL database. It very much stands alone and requires your domain model to be structured in a particular way. To say that it &quot;represents&quot; NoSQL is ridiculous. And to act like a guide on how to scale MongoDB to store 100GB is a problem is also ridiculous. I can create domain models that almost every SQL database would struggle with that MongoDB could breeze through and vice versa.<p>And seriously anyone claims Cassandra or Riak are misspent adventures are simply delusional. They are solving real world problems in particular around horizontal scaling today that could never be done as cheaply or easily as before. A master-master cluster that costs nothing, scales linearly and can be managed by a developer. Would love to know what product existed years ago that could do that.<p>Likewise I take exception with the criticism of MySQL. It is an easy to use, manage and install and has the best tooling bar none. It does what it is intended to do perfectly. Some people who deal exclusively with ORM layers will never see the imperfections and just see the ease of use.

If the article assertion is true, then what is the Postgresql of NoSQL? In OSS RDBMSs, Postgresql quickly rose to the position of best designed, less quirky contender (albeit waay slower than MySQL in the past).<p>Is there a NoSQL equivalent?

So then does this mean that PostgreSQL is to SQL like CouchDB is to NoSQL?

I can tell you from experience that joins are also slow in Oracle Database Enterprise Edition. Joins are slow.<p>A nicely normalized relational data model has many advantages, but speed is not one of them.

Maybe that explains why Oracle is pushing MySQL, then. See? Open Source DB bad, must get the real thing from Oracle!<p>Or just use PostgreSQL :-)

No it&#x27;s not . Mongo sucks. MYSQL is a great tool.