data-replication-setup
Set up database replication for high availability and disaster recovery. Use when configuring master-slave replication, multi-master setups, or replication monitoring.
How do I install this agent skill?
npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill data-replication-setupIs this agent skill safe to install?
- Gen Agent Trust Hubpass
This skill provides setup guides and scripts for database replication, including administrative tasks and schema validation. It utilizes standard placeholder credentials and administrative commands for service management.
- Socketwarn
1 alert: gptAnomaly
- Snykpass
Risk: LOW · No issues
- Runlayerfail
1/1 file flagged
- ZeroLeakspass
Score: 93/100 · 2 sections analyzed
What does this agent skill do?
Data Replication Setup
Table of Contents
Overview
Configure database replication for disaster recovery, load distribution, and high availability. Covers master-slave, multi-master replication, and monitoring strategies.
When to Use
- High availability setup
- Disaster recovery planning
- Read replica configuration
- Multi-region replication
- Replication monitoring and maintenance
- Failover automation
- Cross-region backup strategies
Quick Start
PostgreSQL - Configure Primary Server:
-- On primary server: postgresql.conf
-- wal_level = replica
-- max_wal_senders = 10
-- wal_keep_size = 1GB
-- Create replication user
CREATE ROLE replication_user WITH REPLICATION ENCRYPTED PASSWORD 'secure_password';
-- Allow replication connections: pg_hba.conf
-- host replication replication_user standby_ip/32 md5
-- Enable WAL archiving for continuous backup
-- archive_mode = on
-- archive_command = 'test ! -f /archive/%f && cp %p /archive/%f'
Reference Guides
Detailed implementations in the references/ directory:
| Guide | Contents |
|---|---|
| Master-Slave (Primary-Standby) Setup | Master-Slave (Primary-Standby) Setup |
| Logical Replication | Logical Replication |
| Master-Slave Setup | Master-Slave Setup |
Best Practices
✅ DO
- Follow established patterns and conventions
- Write clean, maintainable code
- Add appropriate documentation
- Test thoroughly before deploying
❌ DON'T
- Skip testing or validation
- Ignore error handling
- Hard-code configuration values
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/aj-geddes/useful-ai-prompts/data-replication-setup">View data-replication-setup on skillZs</a>