sysdesign-consistency-cap

What problem does it solve?

This skill helps architecture teams decide how to handle distributed data consistency by forcing a clear CAP choice (CP vs AP) and mapping to canonical databases and coordination strategies.

Core Features & Use Cases

• CAP choice guidance: forces explicit CP vs AP decision for distributed data stores.
• Canonical technology mapping: suggests canonical databases per CAP class (CP: HBase/Mongo/Redis; AP: Cassandra/Dynamo) and recommended coordination techniques.
• Scalability strategy alignment: aligns coordination technique with cluster scale and availability objectives.
• Use Case: When architects debate Postgres vs Cassandra for a multi-region service, apply this skill to resolve the CAP and coordination approach.

Quick Start

Provide a CAP decision for a multi-region e-commerce orders dataset by selecting a CP or AP approach and selecting a coordinating technique.