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

Database Security Best Practices: Encryption, Access Control, and Auditing

Secure your MySQL and PostgreSQL databases — TLS, at-rest encryption, role-based access, and audit logging

PostgreSQL12 minOct 19, 2022
Read

Setting Up High Availability for Percona Monitoring and Management (PMM)

Running a single PMM server is a single point of failure for your database monitoring. Here's how to set up PMM in an HA configuration with failover and shared storage.

PostgreSQL9 minOct 18, 2022
Read

PgBouncer: The Complete PostgreSQL Connection Pooling Guide

PgBouncer multiplexes thousands of application connections onto a small pool of real PostgreSQL server connections — reducing connection overhead without any application code changes.

PostgreSQL10 minOct 18, 2022
Read

MySQL InnoDB Locking: Deadlocks, Gap Locks, and Next-Key Locks Explained

A deep dive into InnoDB locking — record locks, gap locks, next-key locks, how READ COMMITTED eliminates gap locks, diagnosing deadlocks with SHOW ENGINE INNODB STATUS and performance_schema, and prevention patterns.

MySQL14 minOct 12, 2022
Read

Save Space on MySQL Data with Column Compression: InnoDB Page Compression and ROW_FORMAT

MySQL InnoDB supports multiple compression strategies — from ROW_FORMAT=COMPRESSED to transparent page compression using punch holes. Choosing the right approach can cut storage by 40-70% for text-heavy workloads.

MySQL16 minOct 6, 2022
Read

Troubleshooting MySQL Issues: Daily Queries Every DBA Should Know

Essential MySQL diagnostic queries every DBA needs. Quickly identify slow queries, lock contention, replication lag, memory issues, and connection problems.

MySQL7 minOct 4, 2022
Read

Redis Use Cases: Caching, Rate Limiting, Pub/Sub, Queues, and Session Storage

A practical guide to Redis use cases in production — cache-aside pattern, sliding window rate limiting, Pub/Sub vs Streams, BRPOP queues with delayed job scheduling, and session storage with persistence configuration.

Redis12 minOct 4, 2022
Read

Apache Kafka for Database Engineers: A Practical Introduction

Understand Kafka from a database perspective — partitions, offsets, consumer groups, and durability guarantees

Kafka11 minSep 28, 2022
Read

Database Connection Pooling: PgBouncer, ProxySQL, and HikariCP Compared

A comprehensive guide to database connection pooling — comparing PgBouncer, ProxySQL, and HikariCP with configuration examples, pool mode trade-offs, and production sizing recommendations.

PostgreSQL12 minSep 27, 2022
Read

MySQL Replication Filters: Selective Replication for Specific Databases and Tables

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.

MySQL8 minSep 24, 2022
Read

DynamoDB Cost Optimization: A Comprehensive Guide

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.

AWS15 minSep 20, 2022
Read

MySQL Connection Limits and Max Connections: Tuning for Scale

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

MySQL11 minSep 20, 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