Home
fairdb-backup-manager
jeremylongshore/claude-code-plugins-plus
Use when you need to work with backup and recovery.This skill provides backup automation and disaster recovery with comprehensive guidance and automation.Trigger with phrases like "create backups", "automate backups",or "implement disaster recovery".
...Expand allAbout fairdb-backup-manager
The fairdb-backup-manager skill automates and streamlines backup and disaster recovery processes for systems using the fairdb database. It provides a comprehensive solution for managing backups, automating regular backup schedules, and ensuring data recovery in case of failures or disasters. This skill is specifically designed to help system administrators and developers ensure that backup tasks are handled efficiently, reducing manual effort and minimizing the risk of data loss during outages or unexpected events.
FAQ
How do I use the fairdb-backup-manager skill?
To use the fairdb-backup-manager skill, trigger it with commands like 'create backups', 'automate backups', or 'implement disaster recovery'. Ensure that you have the necessary permissions and configuration set up before starting.
What tools does fairdb-backup-manager support?
The fairdb-backup-manager skill supports the following tools: Read, Write, Edit, Grep, Glob, Bash (with tar, rsync, and AWS S3 support). These tools enable you to manage backup tasks and data recovery processes effectively.
Are there any prerequisites for using this skill?
Yes, you need to have the required credentials and permissions for the operations. Additionally, understanding system architecture, access to relevant documentation, and a staging environment for testing are essential prerequisites.
Can this skill be used in production environments?
Yes, the skill can be used in production, but it's advised to first test it in a non-production environment. Thorough testing, monitoring, and validation should be performed before deployment.
What happens if there are permission or access issues?
If there are permission issues, ensure that credentials are correct and have the necessary access rights. Request elevated access if needed, and implement least-privilege access principles for automated tasks.
FairDB Backup Manager
Overview
Automate backup and recovery operations for FairDB database instances. Generate backup scripts, configure retention policies, schedule automated backups to local storage or S3, and produce tested restore procedures with integrity verification.
Prerequisites
- FairDB instance running and accessible with admin credentials
tarandrsyncinstalled for file-level backups- AWS CLI configured with
s3:PutObjectands3:GetObjectpermissions (if using S3 as backup target) - Sufficient storage at backup destination (2-3x database size for rotation)
- Cron or systemd timer access for scheduling
- Test environment available for restore verification
Instructions
- Assess the FairDB instance: identify data directory location, database size, and write throughput
- Select backup method: logical dump for portability, filesystem snapshot for speed, or continuous archiving for minimal RPO
- Generate backup script with lock acquisition, data export, compression (
tar czf), and checksum generation - Configure S3 upload with server-side encryption (
aws s3 cp --sse aws:kms) for off-site copies - Set up retention policy: keep hourly backups for 24 hours, daily for 7 days, weekly for 4 weeks, monthly for 12 months
- Create cleanup script to purge expired backups according to retention schedule
- Schedule backups via cron with proper logging to
/var/log/fairdb-backup.log - Generate restore procedure: download from S3, verify checksum, decompress, and import with validation query
- Test restore procedure in a staging environment and document the time-to-recovery
Output
- Backup shell script with logging, locking, compression, and S3 upload
- Restore shell script with checksum verification and data validation
- Cron schedule entries or systemd timer units
- Retention cleanup script
- S3 lifecycle policy configuration for long-term archive tiering
Error Handling
| Error | Cause | Solution |
|---|---|---|
Backup lock acquisition failed | Another backup or maintenance process is running | Check for stale lock files; implement timeout-based lock with flock |
tar: Cannot open: No space left on device | Local backup destination full | Run retention cleanup; check disk usage with df -h; increase volume size |
aws s3 cp: upload failed | Network issue or expired AWS credentials | Retry with --retry 3; refresh credentials; check S3 bucket permissions |
Restore failed: checksum mismatch | Backup file corrupted during transfer or storage | Re-download from S3; verify S3 object integrity; use a different backup copy |
Database inconsistent after restore | Backup taken during active write without lock | Ensure backup script acquires a consistent snapshot lock before export |
Examples
- "Create an automated nightly backup for the FairDB production instance, compressed and uploaded to S3 with KMS encryption and 30-day retention."
- "Generate a restore runbook that pulls the latest backup from S3, verifies integrity, and restores to a staging instance for validation."
- "Set up backup monitoring that alerts via Slack if a backup job fails or if no successful backup exists within the last 25 hours."
Resources
- AWS S3 CLI: https://docs.aws.amazon.com/cli/latest/reference/s3/
- rsync documentation: https://rsync.samba.org/documentation.html
- Backup automation patterns: https://www.veeam.com/blog/321-backup-rule.html
- Linux cron scheduling: https://crontab.guru/
Install fairdb-backup-manager
Download and extract the skill files to your .claude/skills/ directory.
Download ZIPClone the repository and copy the skill files to your project.
git clone https://github.com/jeremylongshore/claude-code-plugins-plus-skills/blob/main/plugins/devops/fairdb-operations-kit/skills/fairdb-backup-manager/SKILL.md # Copy SKILL.md to your .claude/skills/ directory
Copy
