From role-database
Guides replication and high availability topologies for PostgreSQL, MySQL, MongoDB, Redis, Cassandra including sync modes, failover, monitoring. Use for HA design, config, troubleshooting.
How this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:replication-haThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Load from `references/` based on what's needed:
Load from references/ based on what's needed:
Replication modes comparison (synchronous/semi-sync/async) with durability and latency tradeoffs. PostgreSQL: streaming replication config, logical replication publications/subscriptions, replication slot warnings. MySQL: GTID setup, semi-synchronous plugin config, Group Replication overview. MongoDB: write concern levels, read preference options, replica set architecture. Redis: Sentinel config (quorum, timeouts), Cluster mode hash slots overview. Cassandra: NetworkTopologyStrategy, LOCAL_QUORUM vs EACH_QUORUM vs LOCAL_ONE. Consensus protocols table (Raft, Paxos, Gossip, ISR). Load when: configuring replication for a specific engine or choosing a topology.
Failover types (automatic, manual, semi-automatic) and Patroni overview. Split-brain prevention techniques (quorum, STONITH, watchdog, min replica count). Topology reference (primary-secondary, multi-primary, quorum-based) with supported engines. Replication monitoring metrics table with alert thresholds for all engines. PostgreSQL replication lag queries (pg_stat_replication, pg_replication_slots). MySQL SHOW REPLICA STATUS key fields. Load when: setting up failover automation, monitoring replication health, or building incident runbooks.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseConfigures replication topologies for PostgreSQL, MySQL, and MongoDB including primary-replica setups, failover automation, lag monitoring, and multi-primary conflict resolution.
Explains CAP theorem (Consistency, Availability, Partition Tolerance) tradeoffs for distributed databases and replication strategies. Helps evaluate CP vs AP system choices and synchronous vs asynchronous replication.
Provides backup strategies and disaster recovery for PostgreSQL, MySQL, MongoDB, Redis with full/incremental/PITR options, verification scripts, and RPO/RTO planning. Use for implementing backups or troubleshooting recovery.