The JusDB Database Engineering Blog

MySQL replication filters let you replicate only specific databases or tables — but misconfiguration can silently drop transactions. Here's how to use binlog-do-db, replicate-do-db, and replicate-do-table safely.

Cut DynamoDB costs by 50% or more with capacity mode optimization, TTL strategies, and smart data modeling. Learn on-demand vs provisioned capacity decision frameworks.

Understand MySQL max_connections, thread caching, and connection pool sizing to handle high-concurrency workloads

A comprehensive guide to MySQL replication lag — why it happens, why Seconds_Behind_Master lies, how to measure accurately with pt-heartbeat, and how to fix it with multi-threaded replication and LOGICAL_CLOCK parallelism.

Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.

Deploy PMM to get deep MySQL and PostgreSQL visibility — query analytics, dashboards, and alerting in one tool

MySQL's EXPLAIN command reveals exactly how the query optimizer plans to execute your SQL — which indexes it will use, how many rows it expects to examine, and where it may sort or create temporary tables.

Explore TiDB distributed SQL database for HTAP workloads. Learn TiKV/TiFlash architecture, MySQL compatibility, horizontal scaling, and deployment strategies.

A production guide to online MySQL schema changes — when to use pt-online-schema-change vs gh-ost vs MySQL 8.0 INSTANT DDL, configuration parameters, the cutover mechanism, and a step-by-step safety playbook.

GTIDs eliminate manual binlog position tracking in MySQL replication. This guide covers enabling GTIDs, CHANGE MASTER TO MASTER_AUTO_POSITION, and failover.

Choose between ElastiCache Redis and Memcached — data structures, persistence, replication, and cost considerations

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows