There's a lot of generalizations being made in that article. In my experience with MySQL, it's just not as good as other production-grade SQL alternatives like Microsoft SQL Server, PostgreSQL, or Oracle. I'd classify this a MySQL + big data problem before I'd call it a SQL-as-a-whole + big data problem.
It could also be that Facebook's architecture sucks, or they have built up a lot of technical debt in the process of scaling so fast and hiring an army of engineers. I mean, StackOverlow serves 800 HTTP request **per second* */ 95 million page views per month with *2 (yes two) *SQL Server machines. Also, saying that relational databases are a thing of the past pretty ridiculous. Most of the problems we're trying to solve fit the relational model very well. I think you'll find that most people are using NoSQL databases for caches, queuing, etc. I don't get the corollary to MV databases, because I think that'd be the last tool I'd pick for scaling a site like Facebook, but have to agree with the point that if the MV vendors want to ride on the NoSQL wave there has to be better APIs. I looked into creating a Ruby adapter for UniData. After about an hour I wanted to kill myself. And even if the APIs get better, why would anyone pick something like U2, which is expensive, closed source, and has a tiny ecosystem versus any of the dozens of free, open source, popular alternatives? I can't think of anything that U2 would bring to the table over MongoDB, Redis, et. al. I apologize for sounding so negative -- I'm actually rooting for MV databases. I just believe that the MV vendors are still focusing on serving the customers who are locked in and ignoring what's happening everywhere else. -Rob On Tue, Jul 12, 2011 at 4:45 PM, Daniel McGrath <dmcgr...@rocketsoftware.com > wrote: > "Mongo DB is Web Scale" > > Warning: Contains occasional course language. > > http://www.xtranormal.com/watch/6995033/mongo-db-is-web-scale > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen > Sent: Tuesday, July 12, 2011 2:24 PM > To: 'U2 Users List' > Subject: Re: [U2] Interesting article > > Distributed autosharding cloud based environment - i can recommend Mongo DB > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno > Sent: 12 July 2011 20:47 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Interesting article > > > From: Bill Haskett > > I wonder if this implies that those who U2 are all database "gurus"? > > :-) > > I get the humor but... > I need to create a distributed cloud-based MV environment, obviously > smaller than Facebook but using the same concept of "shards" for distributed > storage and computing. So far most of the Pick people I talk to have no > idea what I'm talking about let alone how to implement it with MV. We're > not gurus if we don't speak the same language as the rest of the world. > > As to "old SQL", there is a revolution going on out there and I'm wondering > if other MV people have seen this: Look at the data storage for Android, > Google App Engine, AmazonDB, etc. All of these platforms and others are > using name/value pairs with some relational functionality, but they're not > using SQL. Once again we're missing a whole new generation of data hungry > applications. > > While there are still new methods of data storage and retrieval being > created all the time, the MV market needs to define a consistent web service > / REST API for data access and rule execution, accessible from any client. > (That's easy, I have done this many times for various projects and for most > MV platforms.) > >From there, professionals in this community can position as > experts to provide applications, DBMS support services, rules in BASIC, > hosting, and mentoring for a new generation of people who might like to use > BASIC for rules rather than Java, Ruby, Go, or whatever else they're just > starting to learn. > > Yeah... as if... > > Tony Gravagno > Nebula Research and Development > TG@ remove.pleaseNebula-RnD.com > remove.pleaseNebula-RnD.com/blog > Visit PickWiki.com! Contribute! > http://Twitter.com/TonyGravagno > > > > > From:Symeon Breen > > > Some on here will be interested in this. I esp like Gigaom's > quote > > > > "old SQL (as he calls it) is good for nothing" and needs to be "sent > > to the home for retired software." > > After all, he explained, SQL was created decades ago before the web, > > mobile devices and sensors forever changed how and how often databases > > are accessed. > > > > > <http://www.eweekeurope.co.uk/news/facebook-needs-major-rewrite-w > arns-database-guru-33864> > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 10.0.1390 / Virus Database: 1516/3760 - Release Date: 07/12/11 > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users