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

Geospatial Data Handling Made Easy with MySQL 8.0

MySQL 8.0 significantly improved geospatial support with SRID-aware columns, spatial reference systems, and accurate geographic distance calculations. Here's how to use it in production.

MySQL9 minMay 4, 2022
Read

Securing Your MongoDB Cluster with TLS/SSL: A Complete Configuration Guide

Running MongoDB without TLS exposes your data to network interception and man-in-the-middle attacks. Here's how to configure TLS/SSL across your MongoDB replica set.

MongoDB9 minMay 2, 2022
Read

Schema Versioning and Migration Strategies for Scalable Databases

Implement zero-downtime database migrations with versioning strategies. Learn about Flyway, Liquibase, schema evolution patterns, and rollback strategies.

14 minApr 26, 2022
Read

MySQL Galera Cluster: Setup, Tuning, and Common Pitfalls

Set up MySQL Galera Cluster for synchronous multi-master replication — configuration, split-brain avoidance, and monitoring

MySQL13 minApr 18, 2022
Read

Partitioning and Sharding Techniques for Database Scalability

Master horizontal and vertical partitioning, plus database sharding strategies for handling billions of records. Learn partition pruning, shard key selection, and cross-shard query optimization.

10 minApr 12, 2022
Read

PlanetScale: MySQL-Compatible Serverless Database with Schema Branching

Evaluate PlanetScale for MySQL workloads — Vitess-based branching, non-blocking schema changes, and pricing

MySQL10 minApr 5, 2022
Read

MySQL Error Log Table Explained: Using performance_schema for Error Analysis

MySQL 8.0 exposes error logs through performance_schema.error_log — enabling SQL-based filtering by severity, component, and timestamp without grep-ing log files.

MySQL7 minMar 28, 2022
Read

mysqldump vs mysqlpump vs MyDumper: Current Guide

Choose a current MySQL logical backup tool from measured recovery needs, and migrate legacy mysqlpump jobs and archives without risking production data.

MySQL8 minMar 26, 2022
Read

MySQL InnoDB Cluster Explained: Complete Guide to High Availability

Deploy and operate MySQL InnoDB Cluster 8.4 safely with AdminAPI, Group Replication, Router, tested failover, and recoverable outage procedures.

MySQL6 minMar 22, 2022
Read

MySQL Tablespace Encryption (TDE): Encrypting Data at Rest

MySQL InnoDB tablespace encryption (TDE) encrypts data pages on disk without changing application code — using a two-tier keyring architecture that separates the master key from table keys.

MySQL9 minMar 22, 2022
Read

Database Schema Design Fundamentals for Scalability

Learn the fundamental principles of database schema design for building scalable applications. This guide covers entity relationships, primary keys, foreign keys, and normalization concepts essential for high-performance databases.

5 minMar 1, 2022
Read

ProxySQL Read/Write Splitting for MySQL Replication: Complete Setup Guide

ProxySQL's read/write splitting routes SELECT queries to replicas and writes to the primary automatically — but getting the configuration right requires understanding hostgroups, query rules, and lag-aware routing.

MySQL9 minFeb 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