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

Airbyte: Open-Source ELT for Database Replication

Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms

11 minJul 14, 2022
Read

Mastering MySQL Group Replication: The Road to Fault-Tolerant Databases

Build fault-tolerant MySQL clusters with Group Replication. Learn multi-primary vs single-primary modes, conflict resolution, network partitioning handling, and failover strategies.

MySQL4 minJul 12, 2022
Read

PostgreSQL Performance Tuning: shared_buffers, work_mem, and Memory Configuration

A complete guide to PostgreSQL memory configuration and performance tuning, covering shared_buffers, work_mem, effective_cache_size, checkpoint tuning, and autovacuum settings that matter in production.

PostgreSQL12 minJul 12, 2022
Read

Integrating MySQL Maintenance with systemd: Services, Timers, and Scheduling

Most MySQL maintenance tasks still rely on cron, but systemd timers offer better logging, dependency management, and failure handling. Here's how to convert your MySQL maintenance scripts to systemd services.

MySQL8 minJul 10, 2022
Read

Data Types and Constraints Selection for Scalable Database Schemas

Optimize database performance by choosing the right data types and constraints. Learn about VARCHAR vs TEXT, INT sizes, ENUM optimization, and constraint best practices.

13 minJul 5, 2022
Read

Top 10 MySQL Configuration Mistakes That Kill Performance

Avoid these common MySQL configuration mistakes that cripple performance. Learn proper buffer pool sizing, connection limits, and InnoDB settings for production workloads.

MySQL3 minJun 21, 2022
Read

Online Schema Change for Tables with Triggers: pt-osc and gh-ost Workarounds

Performing online schema changes on MySQL tables with triggers is a known pain point — pt-osc creates conflicting triggers, and gh-ost has its own limitations. Here are the safe approaches.

MySQL10 minJun 14, 2022
Read

PostgreSQL VACUUM Tuning: A Comprehensive Guide

Master PostgreSQL VACUUM and autovacuum configuration for optimal database health. Learn dead tuple management, bloat prevention, and vacuum optimization strategies.

PostgreSQL6 minJun 7, 2022
Read

The Ultimate Guide to Choosing the Right Database for Your Application

Navigate the complex landscape of database technologies. Compare SQL vs NoSQL, OLTP vs OLAP, and learn decision frameworks for selecting the perfect database for your use case.

16 minMay 31, 2022
Read

DynamoDB Streams and Lambda: Event-Driven Database Patterns

Process DynamoDB Streams with Lambda for change data capture, cross-region replication, and event sourcing

AWS11 minMay 24, 2022
Read

XtraBackup: Physical MySQL Backups for Production

Use Percona XtraBackup to take hot physical backups of MySQL InnoDB — setup, verification, and restore steps

MySQL12 minMay 17, 2022
Read

MySQL Performance Optimization for AWS RDS

A comprehensive guide to optimizing AWS RDS MySQL performance through infrastructure tuning, parameter configuration, and query optimization

MySQL16 minMay 10, 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