5 ms·
I'd love to hear from someone who has implemented this in production. Seems like really cool tech, but haven't had a chance to use it on a project yet.
by baconomatic 9y ago
I'd love to hear from someone who has implemented this in production. Seems like really cool tech, but haven't had a chance to use it on a project yet.
- smnscu 9y agoWorks great, just a tad slow. Hopefully this improves things. Deploying with Kubernetes is pretty seamless as well.
- welder 9y agoUsing it in production currently with dual-write and dual-read to compare perf. I'll do a write-up showing how Cockroach performs to Citus and Cassandra for my use case.
- some_account 9y agoPlease do, that would be a very popular read I think.
- qeternity 9y agoWe use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
- arjunnarayan 9y agoCockroachDB is not (yet) ready for use on OLAP-style workloads. Our performance work has focused on OLTP workloads so far. That said, we do great on OLTP joins (which is a stressed in the TPC-C workload).
- manigandham 9y agoYou're not going to get better performance for OLAP than MemSQL's columnstore and in-memory rowstore for reference tables to join. Citus is great if you want the Postgres interface but is still using standard rowstore tables. CockroachDB is similar with rowstore performance but with added distributed consensus overhead. They are both much better for OLTP and sharding. CockroachDB also provides easy high-availability and replication.
- qeternity 9y agoYeah this is what we do. Citus is our single source of truth and powers a few interactive apps and admin panels. These sync hourly to our Memsql cluster which is cstore + ref tables and works amazingly.
- ams6110 9y agoMemSQL is one of those "ask for a quote" products. What are some rule of thumb estimates for what it costs?
- ddorian43 9y ago$25K/year/box from previous comments
- manigandham 9y agoLicensed by total RAM of all nodes. $25k/year minimum license now, but you should still talk to them if you're a small company. Regardless of price, I highly recommend the product as one of the most polished data warehouses available for on-prem/self-managed operations.
- shaklee3 9y agokdb+?
- manigandham 9y agoSure, but it's far more expensive and not as generally usable as the mysql-flavored MemSQL for common data warehouse scenarios. Performance will be similar but there are differences in functionality like kdb's asof joins that can't really be compared. kdb+ is much better for numeric/financial analysis apps, especially when used with the integrated query language and interpreter environment.
- shaklee3 9y agoThe statement was that you will not get better performance than memsql, not about which is cheaper.
- xstartup 9y agoWe use clickhouse cluster with 1000 nodes and 50000 GB clickstream data.
- no1youknowz 9y agoI'm using MemSQL's columnstore myself and the performance is nothing short of amazing. I migrated from Citus DB to it for OLAP workloads. But for what reasons are you using Citus as well? Would like to know if I am missing something or hear another perspective. Can you explain your use case? Thanks
- baconomatic 9y agoPlease do!
- didip 9y agoPlease post your write-up on HN! I would love to read CockroachDB performing in real world.