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
Airbyte: Open-Source ELT for Database Replication
Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms
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.
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.
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.
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.
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.
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.
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.
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.
DynamoDB Streams and Lambda: Event-Driven Database Patterns
Process DynamoDB Streams with Lambda for change data capture, cross-region replication, and event sourcing
XtraBackup: Physical MySQL Backups for Production
Use Percona XtraBackup to take hot physical backups of MySQL InnoDB — setup, verification, and restore steps
MySQL Performance Optimization for AWS RDS
A comprehensive guide to optimizing AWS RDS MySQL performance through infrastructure tuning, parameter configuration, and query optimization
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed