4 ms·

I would love to go back to relational, but I can't get over the linear scaling and HA ease of Cassandra and I'm willing to write my applications to work around

I would love to go back to relational, but I can't get over the linear scaling and HA ease of Cassandra and I'm willing to write my applications to work around the data model limitations. Is there any open source SQL database (i.e. "newsql") that can linearly scale with Cassandra's ease right now? I look forward to CockroachDB but it isn't done yet.

lukaslalinsky 11y ago
There are some SQL databases build on top of HBase. HBase and the whole Hadoop ecosystem is not what I'd call easy, but once you are familiar with it, scaling it is relatively easy (probably still not as easy as Cassandra, thanks to the fact that Cassandra always hashes things and does not allow sorted range scans). I'm currently experimenting with Phoenix, because it's a relatively thin layer above HBase, but it doesn't provide many features that you expect in relational databases like transactions. SELECT support is quite complete, it can do JOINs, subqueries, etc. I have recently discovered Trafodion which looks like a much more complete relational database, but at the expense of no longer being just a HBase client. http://phoenix.apache.org/ http://phoenix.apache.org/ https://wiki.trafodion.org/wiki/index.php/Main_Page https://wiki.trafodion.org/wiki/index.php/Main_Page https://vimeo.com/128190098 https://vimeo.com/128190098
ericfrenkiel 11y ago
It's commercial, but MemSQL Community Edition scales horizontally. It's free and there are no capacity or scaling limits.
- ddorian43 11y ago
  Community edition doesn't have HA
ozgune 11y ago
(Disclaimer: I'm one of the authors of pg_shard.) pg_shard extends PostgreSQL without forking it, and it's worth a look: https://github.com/citusdata/pg_shard https://github.com/citusdata/pg_shard pg_shard v2.0 will target linear scaling and higher HA through metadata replication. If you have any questions or feedback for the project, we'd be happy to hear from you. If you're on AWS, you can already get linear scale and full HA. This post shows a proof-of-concept: https://goo.gl/3c2GYc https://goo.gl/3c2GYc

lukaslalinsky 11y ago

There are some SQL databases build on top of HBase. HBase and the whole Hadoop ecosystem is not what I'd call easy, but once you are familiar with it, scaling it is relatively easy (probably still not as easy as Cassandra, thanks to the fact that Cassandra always hashes things and does not allow sorted range scans). I'm currently experimenting with Phoenix, because it's a relatively thin layer above HBase, but it doesn't provide many features that you expect in relational databases like transactions. SELECT support is quite complete, it can do JOINs, subqueries, etc. I have recently discovered Trafodion which looks like a much more complete relational database, but at the expense of no longer being just a HBase client. http://phoenix.apache.org/ http://phoenix.apache.org/ https://wiki.trafodion.org/wiki/index.php/Main_Page https://wiki.trafodion.org/wiki/index.php/Main_Page https://vimeo.com/128190098 https://vimeo.com/128190098

ericfrenkiel 11y ago

It's commercial, but MemSQL Community Edition scales horizontally. It's free and there are no capacity or scaling limits.

ddorian43 11y ago
Community edition doesn't have HA

ozgune 11y ago

(Disclaimer: I'm one of the authors of pg_shard.) pg_shard extends PostgreSQL without forking it, and it's worth a look: https://github.com/citusdata/pg_shard https://github.com/citusdata/pg_shard pg_shard v2.0 will target linear scaling and higher HA through metadata replication. If you have any questions or feedback for the project, we'd be happy to hear from you. If you're on AWS, you can already get linear scale and full HA. This post shows a proof-of-concept: https://goo.gl/3c2GYc https://goo.gl/3c2GYc