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
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.
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.
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.
MySQL Galera Cluster: Setup, Tuning, and Common Pitfalls
Set up MySQL Galera Cluster for synchronous multi-master replication — configuration, split-brain avoidance, and monitoring
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.
PlanetScale: MySQL-Compatible Serverless Database with Schema Branching
Evaluate PlanetScale for MySQL workloads — Vitess-based branching, non-blocking schema changes, and pricing
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.
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.
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.
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.
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.
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed