database-replication
Installation
SKILL.md
Database Replication
Use this skill when
- Adding read replicas for scale
- Understanding lag and consistency implications
- Promoting/falling back replicas
- Multi-region replication
Do not use this skill when
- Single-node apps
- Application-level caching decisions (use backend-caching)
Instructions
- Route reads that tolerate lag to replicas; keep writes and strict reads on primary.
- Measure replication lag and alert on it.
- Handle read-after-write consistency explicitly for user actions.
- Plan replica promotion and failover with testable runbooks.
- Consider logical vs physical replication trade-offs (rowsets, conflicts).
- Document the consistency model consumers can rely on.