Does this skill include support for specific databases?

Yes, it includes specific implementation examples for PostgreSQL, such as measuring replication lag using pg_last_xact_replay_timestamp.

How does this skill handle database transactions?

It provides logic to ensure that once a transaction begins, all subsequent queries—including reads—are routed to the primary node to maintain ACID guarantees and data integrity.

What is the 'sticky master' strategy?

It is a technique where an application continues reading from the primary database for a short window (e.g., 5 seconds) after a write operation to ensure the user sees their own changes before they have fully propagated to replicas.

Can these patterns be integrated into modern PHP frameworks?

Absolutely. While the examples use standard PDO, the logic is designed to be easily integrated into Doctrine DBAL, Eloquent, or custom framework database layers.

Database Replication & Sharding Knowledge

Name: Database Replication & Sharding Knowledge
Author: dykyi-roman

bydykyi-roman

•

Database Management

Implements scalable database architectures in PHP through application-level read/write splitting and replica lag management.

This skill provides Claude with a comprehensive knowledge base and implementation patterns for scaling PHP applications using database replication and sharding. It equips developers with standardized patterns for connection wrappers, automated query routing between primary and replica nodes, and sophisticated strategies for handling replication lag—such as 'sticky master' and lag-aware routing—ensuring data consistency while maximizing read throughput in high-traffic environments.

Key Features

0147 GitHub stars

02Sticky master strategies to ensure read-your-writes consistency

03Lag-aware routing based on real-time replica performance metrics

04Application-level read/write query splitting patterns

05Transaction-aware routing to maintain ACID compliance

06Standardized connection wrapper patterns for PHP PDO

Use Cases

01Auditing existing database connections for scaling bottlenecks and optimization

02Designing high-availability systems with strong consistency requirements despite replication lag

03Implementing master-slave (primary-replica) architecture in legacy PHP applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code replication-sharding-knowledge

For use in Claude.ai and ChatGPT

Download Skill