The JusDB Database Engineering Blog
Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.
Popular Searches
Featured Articles
Hand-picked by our editors
StarRocks Monitoring & Alerting: The Complete Production Guide
Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.
Latest Articles
Showing 12 of 404 articles
MySQL Replication Lag: Causes, Diagnosis, and Fixes
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.
Advanced Indexing Strategies for Database Scalability
Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.
Percona Monitoring and Management (PMM): Full Setup Guide
Deploy PMM to get deep MySQL and PostgreSQL visibility — query analytics, dashboards, and alerting in one tool
TiDB Explained: The Complete Guide to Distributed SQL and HTAP
Explore TiDB distributed SQL database for HTAP workloads. Learn TiKV/TiFlash architecture, MySQL compatibility, horizontal scaling, and deployment strategies.
MySQL EXPLAIN Explained: How to Read Query Plans and Fix Slow Queries
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.
MySQL Online Schema Change: pt-osc and gh-ost in Production
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.
MySQL GTID Replication: Complete Setup and Failover Guide
GTIDs eliminate manual binlog position tracking in MySQL replication. This guide covers enabling GTIDs, CHANGE MASTER TO MASTER_AUTO_POSITION, and failover.
ElastiCache for Redis vs Memcached: Choosing the Right AWS Cache
Choose between ElastiCache Redis and Memcached — data structures, persistence, replication, and cost considerations
Flyway: Database Migration Versioning Done Right
Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows
MySQL Slow Query Log: Enabling, Analyzing with pt-query-digest, and Fixing the Top Patterns
A production guide to MySQL slow query log — enabling with long_query_time and log_queries_not_using_indexes, analyzing with pt-query-digest, reading EXPLAIN output, and fixing full table scans and N+1 loops.
MySQL Connection Lifecycle: Complete Guide to Connection Management and Optimization
Optimize MySQL connection management for maximum throughput. Learn connection pooling with HikariCP, ProxySQL load balancing, and thread pool configuration.
Descending Indexes in MySQL 8.0: When and How to Use Them
MySQL 8.0 finally supports true descending indexes — eliminating the filesort that MySQL 5.7 required when sorting results in descending order. Here's how descending indexes work and when to add them.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed