JusDB
Free DB Audit

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.

404 canonical articlesBrowse the complete archive

Popular Searches

Featured Articles

Hand-picked by our editors

Analytics & OLAP· Featured

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.

StarRocks14 minMar 24, 2026
Read

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.

MySQL13 minSep 15, 2022
Read

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.

5 minSep 13, 2022
Read

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

PostgreSQL11 minSep 6, 2022
Read

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.

TiDB4 minSep 6, 2022
Read

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.

MySQL11 minSep 6, 2022
Read

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.

MySQL12 minAug 23, 2022
Read

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.

MySQL9 minAug 11, 2022
Read

ElastiCache for Redis vs Memcached: Choosing the Right AWS Cache

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

Redis10 minAug 3, 2022
Read

Flyway: Database Migration Versioning Done Right

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

11 minJul 26, 2022
Read

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.

MySQL12 minJul 19, 2022
Read

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.

MySQL17 minJul 19, 2022
Read

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.

MySQL7 minJul 15, 2022
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed