3 ms·
sidenote : currently trying to get up to date with the best way to get distributed acid key value storage those days. Is coackroach the new standard ? I tried t
by bsaul 7y ago
sidenote : currently trying to get up to date with the best way to get distributed acid key value storage those days. Is coackroach the new standard ? I tried to find benchmarks comparing it to things like postgres for various use case but only found articles that read like ads.
- redis_mlc 7y ago> the best way to get distributed acid key value storage You will need to define "best way", "distributed" and "acid" based on your requirements. For most people, multi-master MySQL and Redis with vector clocks is a great combination. > Is coackroach the new standard No database less than 5 - 10 years old works in production, so no, it's not a standard. > I tried to find benchmarks comparing it to things like postgres for various use case Well, without more detailed requirements, good luck. Also comparing pg to distributed databases is ... like comparing apples and oranges. Source: experienced DBA.
- bsaul 7y agodistributed : able to scale horizontally, ideally over multiple availability zone, to ensure both performance and data safety. acid : able to perform bank account money transfert style transaction. last time i checked, pg was able to shard and work in multiple replication configuration, ensuring a good scalability story up to terabytes of active data.. Does multi master mysql enable row locking ?