CockroachDB Interactive, D3-Powered Simulations

Re:CockroachDB Interactive, D3-Powered Simulations by erikrothoff on Friday February 23, 2018 @03:55AM (#16445087)

We currently host our "monolithic" MySQL database on a fairly large VPS on Linode. At least on Linode, to increase storage space you need to double the capacity of the server, thus doubling the cost for each scale up. The idea of simple scaling horizontally is one I've dreamt of for a long time. However it just seems that the problem is not the monolithicness, it's the cost of storage. If we were to use CockroachDB with redundancy the cost would be equivalent to just using Amazon Aurora, which is fully managed!

That being said I'm very excited about CockroachDB. Cassandra did not live up to the hype for me because of the complexity and now that DataStax has split up with Apache in a weird way, it feels like a less appealing option.

[ Parent | on HN ]

Re:CockroachDB Interactive, D3-Powered Simulations by dx034 on Friday February 23, 2018 @04:54AM (#16445315)

Would be great to have cloud VPS without RAID for exactly those cases where redundancy is handled a level above. Could probably be offered much cheaper than current VPS.

[ Parent | on HN ]

Re:CockroachDB Interactive, D3-Powered Simulations by bsg75 on Friday February 23, 2018 @12:44PM (#16447895)

> Cassandra did not live up to the hype for me because of the complexity

Which complexity are you referring to, specifically where CRDB has a better approach?

Interested as we are evaluating both.

[ Parent | on HN ]

Re:CockroachDB Interactive, D3-Powered Simulations by cube2222 on Friday February 23, 2018 @03:51PM (#16449503)

CRDB and Cassandra are to totally different databases.

CockroachDB is full SQL ACID database. With transactions, consistent indexes, joins. It's also strongly consistent overall.

Cassandra is really just a key-value store, with a hierarchy of sorting keys as part of the key, so that you can do range scans with good performance (and various access patterns). Indexes are asynchronously updated (as far as I know). No transactions nor joins. Its consistency is varying (configurable).

[ Parent | on HN ]

Re:CockroachDB Interactive, D3-Powered Simulations by erikrothoff on Thursday March 01, 2018 @04:40AM (#16490733)

Turns out for Cassandra to work properly you need double the storage space that you max want available, otherwise it can't vacuum properly. So if you want to be able to store 1 TB, you need 2 TB, and if you go over 1 TB, it's not guaranteed to be able to vacuum at all.

Also, Apache Cassandra and DataStax Cassandra did a hard split recently, so the docs are no longer in sync, making it a lot harder to search for stuff if you're using Apache Cassandra.

Also, patch versions of Cassandra are not guaranteed to be binary compatible (sstables), [so upgrading from 3.0.5 to 3.0.9](https://gist.github.com/shyamsalimkumar/49a61e5bc6f403d20c55...)? Expect a long migration.

[ Parent | on HN ]