3 ms·
So, maybe you can clarify something for me. Stonebraker cites Greenplum / Vertica / etc as examples of sql dbs that scale out. But all the ones he mentions ar
by jbellis 17y ago
So, maybe you can clarify something for me.
Stonebraker cites Greenplum / Vertica / etc as examples of sql dbs that scale out. But all the ones he mentions are data warehouses that measure time from load to queriability in minutes. Not ms like the OLTP-focused nosql distributed systems.
And of course systems like RAC or pgcluster rely on a SAN, so that's not really playing the same game either.
Am I missing something? Feels like Stonebraker is cheating a little to make his point to me.
- zaphar 17y agono your not missing anything. And I can speak from experience that RAC doesn't even help. We are in the progress of migrating from a RAC system to a NoSql system. RAC doesn't scale either.
- ntoshev 17y agoCould you give more detail about what are you doing?
- zaphar 17y agoSuffice to say that RAC has been nothing but trouble since we moved to it from DB2 for scale reasons. Rather than pay a consultant tons of money to help us get it stable after less than a year on it we are now migrating off to a non-relational solution. I can't give more detail than that really. Maybe later I'll be able to get permission to post a blog post about it.
- gaius 17y agoIf you are scaling without a single image (which RAC gives you) then that's not playing the game either. Sharding is just re-implementing parallel query and partition elimination which you get out of the box with the major RDBMSs, and sacrificing the ability to do joins across shards (which you CAN do with real RDBMSs). Also OLTP without ACID isn't playing either.
- jasonwatkinspdx 17y agoVertica's load performance is quite impressive actually. Teradata also has installations doing high volume OLTP, not just OLAP.