Which databases are supported by this skill?

This skill is specifically designed to manage replication and high availability for PostgreSQL and MySQL databases.

How does it handle replication lag?

The skill allows you to set specific thresholds (e.g., 5 seconds). If replication delay exceeds this limit, it can trigger alerts or automated management actions.

Can this skill help with disaster recovery?

Yes, by configuring master-slave replication and automatic failover, the skill helps ensure your data remains available during a primary node failure.

What is the difference between physical and logical replication in this context?

The skill supports physical replication for exact block-level copies and logical replication for more flexible, granular data streaming between different database versions or architectures.

Database Replication Manager

Name: Database Replication Manager
Author: intent-solutions-io

byintent-solutions-io

0•

데이터베이스 관리

Automates the setup and management of database replication, failover, and high availability configurations for PostgreSQL and MySQL.

The Database Replication Manager skill empowers Claude to handle complex database administration tasks by automating the deployment of master-slave topologies, configuring automatic failover mechanisms, and managing read scaling. It simplifies both physical and logical replication strategies, providing a streamlined interface for monitoring replication lag and ensuring data consistency across distributed environments. Whether you are building a disaster recovery plan or scaling read performance, this skill provides the necessary domain-specific guidance and automation to maintain a robust database infrastructure.

주요 기능

01Configurable automatic failover for high availability

020 GitHub stars

03Automated master-slave replication setup

04Real-time replication lag monitoring and alerting

05Support for both physical and logical replication strategies

06Read scaling implementation via replica distribution

사용 사례

01Setting up a highly available PostgreSQL cluster with automatic failover

02Implementing read scaling for MySQL to handle high traffic volumes

03Monitoring database health and alerting on replication synchronization delays

주요 기능

01Configurable automatic failover for high availability

020 GitHub stars

03Automated master-slave replication setup

04Real-time replication lag monitoring and alerting

05Support for both physical and logical replication strategies

06Read scaling implementation via replica distribution

사용 사례

01Setting up a highly available PostgreSQL cluster with automatic failover

02Implementing read scaling for MySQL to handle high traffic volumes

03Monitoring database health and alerting on replication synchronization delays