Hacker News new | ask | show | jobs
by motarddba 852 days ago
TL;DR: you need to study both to get your best (performance-)results. These "serverless" or multi-server (and attempting multi-location) databases may well be the next wave of databases. CRDB and YB: They both take a postgres (or wire compatible ;-) front-end and Rocks-db storage behind that. Both also seem to prefer DBaaS rather than DIY-deployment. Last summer, I did brief few weeks of testing of both. For curiosity, not for performance. Both seem easy to deploy on servers or as containers/pods etc.. For Efficiency (performance), Especially for Yugabyte, you Need to Know a little about their sharding. If doing default initial deploy, just dump + ingest (?) will generally give you un-favorable storage for any smalll-ish table. Mainly bcse YB seems to assume you need Everything Sharded Everywhere (their storage mechanism seems to favour single-large-table models). Resilience wise, both are good, but again, you should know a little about their engineering to get Good Benefits. In all cases, bcse the "distributed" nature: Latency is probably going to be your Main Enemy.