Hacker News new | ask | show | jobs
by einhverfr 5335 days ago
Ok, let me rephrase.

MySQL has a niche too. It's somewhere between that of a NoSQL database and that of a real RDBMS. MySQL does well for single app databases (as NoSQL does), but where the relational data then needs to be fed through other database systems for multi-app access.
1 comments
tptacek 5335 days ago
It seems to do well for all of Facebook too, doesn't it?

I know Facebook seems banal because we interact with it in some way several times a week, but is your head wrapped around how huge that thing is?

link
chalst 5335 days ago
If Facebook are so happy with MySQL, why did they develop Cassandra?

Derek Harris puts the larger point about Facebook's trouble with MySQL: "By and large, [MySQL] does [for Facebook] what it’s designed to do, which is to keep up with the myriad status updates and other data that populate users’ profiles. Rather, [the problem is] that Facebook had to expend so much money and so many man-hours to get there."

http://gigaom.com/cloud/is-stonebraker-right-why-sql-isnt-th...

link
einhverfr 5335 days ago
It's not about the size of the database or deployment. It's about the number of applications interacting across the same relational interface. The fact that applications can turn off strict mode is a big blow in this area. You can't be sure your data is "obviously correct" to paraphrase a different HN post.

One of my customers logs certain web data into a MySQL database and loads/processes it in a PostgreSQL database every day. The data is then accessed in Pg by at least three different applications.

That's reasonable, btw.

link