From role-database
High availability and replication topologies across all database engines. Synchronous/asynchronous/semi-synchronous replication, primary-secondary, multi-primary, quorum-based. PostgreSQL streaming/logical replication, MySQL GTID/Group Replication, MongoDB replica sets, Redis Sentinel/Cluster, Cassandra multi-DC. Consensus protocols (Raft, Paxos, Gossip). Failover automation, split-brain prevention. Use when designing HA architectures, configuring replication, or troubleshooting failover.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
Load from `references/` based on what's needed:
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Audits ECC Tools repo for cost burns from runaway PR creation, quota bypasses, premium-model leakage, duplicate jobs, and GitHub App spikes.
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.