Index of every page on this site: llms.txt
All skills
proyecto26 avatar

/consistency-coordination

@228d57d
Run it yourself

This skill should be used when the user asks about the "CAP theorem", "PACELC", a "consistency model", "eventual vs strong consistency", "read-your-writes", "causal consistency", "quorum" or "R+W>N", "consensus", "Raft / Paxos", "leader election", "consistent hashing", a "distributed transaction", "2PC", or "saga". Use it whenever a design has multiple copies of data or coordinating nodes and a decision hinges on what a reader is guaranteed to see during replication lag, a network partition, or a node failure — even if the user doesn't say "consistency".

Use this Skill: https://skilld.dev/gh/proyecto26/system-design-skills/consistency-coordination

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencesprovidersgcp.md

≈566 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Consistency & coordination — GCP

Only the managed pieces that change the generic recipe. For anything not listed, the generic recipe (self-hosted etcd/ZooKeeper, Cassandra, etc.) is the answer.

Service mapping

  • Cloud Spanner — the decision-changing service: a horizontally-sharded SQL database offering external consistency (the strongest practical guarantee — linearizable and globally serializable transactions) across regions. It achieves this with TrueTime (GPS + atomic-clock bounded clock uncertainty) plus Paxos per shard. Reach for Spanner when you genuinely need global strong consistency with SQL and are willing to pay for it; it removes the usual "you can't have strong consistency across regions cheaply" constraint — at a real cost.
  • Firestore / Datastore — strongly consistent reads and queries within a region; multi-region modes add availability. Document model, not tunable-per-query like Cassandra.
  • Bigtable — single-cluster strong consistency; replicated/multi-cluster routing becomes eventually consistent across clusters. Consistent-hashing-style range/row-key sharding (mind hot row-key ranges).
  • No managed ZooKeeper/etcd primitive — GKE runs etcd for Kubernetes' own control plane; for app-level coordination, run etcd/ZooKeeper yourself or use Spanner/ Firestore transactions as the coordination point.

Limits / things that bite (verify against current docs)

  • Spanner's external consistency is not free: writes incur a commit-wait tied to TrueTime uncertainty and cross-region Paxos round trips — budget the added write latency; price scales with node/processing units.
  • Bigtable multi-cluster replication is eventually consistent; don't assume a write in cluster A is instantly visible in cluster B.
  • Firestore has per-document and transaction contention limits (hot documents throttle).

Pitfalls

  • Reaching for Spanner when regional strong consistency (Firestore/Cloud SQL) or eventual consistency would meet the requirement — paying for global serializability no one asked for (YAGNI).
  • Assuming Bigtable cross-cluster reads are strongly consistent.
  • Ignoring Spanner commit-wait latency in a tight write-path budget.

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts24d3 checks · Risk SAFE
  • Gen Agent Trust Hub24d

    The skill provides instructional content and architectural guidelines for distributed systems (consistency models, coordination, consensus). No security risks, executable code, or malicious patterns were detected.

  • Socket24d

    No alerts

  • Snyk24d

    Risk: LOW · No issues

Signed by skilld at 228d57d. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 3 weeks ago.

Activeupdated 4 weeks ago

README badge

README badge for proyecto26/system-design-skills/consistency-coordination