Cassandra Database
Inspired by System Design Solutions: When to use Cassandra and when not to
Cassandra is masterless.
Cassandra has no Database ACID support.
Bias towards Availability.
When to choose Cassandra
- Write heavy
- Zero downtime needed (in traditional master/slave, there is a small downtime if master is down for the failover to happen)
When not to
Sources
- System Design Solutions: When to use Cassandra and when not to inspired this note
Referenced by
- How to choose a databaseEstablished
PostgreSQL. Strengths: transactions, joins, constraints, flexible queries. Weaknesses: horizontal scale/sharding complexity, not ideal for huge analytical scans. DynamoDB. Strengths: massive scale, predictable low-latency key access, operational simplicity. Weaknesses: access-pattern-driven modelling, limited relational…