3 ms·
next time try cockroachdb instead of postgres.
by _tkzm 7y ago
next time try cockroachdb instead of postgres.
- stevewodil 7y agoPerhaps you could elaborate further on this to add to the discussion
- _tkzm 7y agowhen you hit scaling issues with standard postgres. cdb has the same wire format so no code change would be needed. for mysql alternative, there is tidb but that one is not a single binary so i never used it.
- williamdclt 7y agoAn explanation of why would be nice
- zahrc 7y agoI’ve never heard of cockroachdb, what are the advantages of it and why is it preferable to Postgres?
- vvern 7y agoA primary advantage is horizontal scalability. If you need more capacity, just add more nodes. Additionally it offers better fault tolerance and zero-downtime online upgrades. For more advanced use cases it can be deployed in a geo-replicated topology and configured with partitioning for low latency transactions when confined to a single region while proving strong consistency and a single logical database globally. Disclaimer: I work on cockroach.