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
MySQL Binlog to Kafka: Building a CDC Pipeline
Build a MySQL CDC pipeline using binlog and Kafka — Debezium, Maxwell, or Canal — trade-offs and production setup
Azure Cosmos DB: Multi-Model Database for Global Distribution
Use Azure Cosmos DB for globally distributed workloads — consistency levels, partitioning, and API choices
AWS RDS MySQL Cost Optimization
Reduce AWS RDS MySQL costs by 40-60% with proven optimization strategies. Learn Reserved Instance planning, right-sizing, storage optimization, and read replica strategies.
Database Sharding Strategies: Hash, Range, Directory, and When to Use Each
A practical guide to database sharding strategies — hash sharding, range sharding, directory-based sharding — with trade-offs, resharding complexity, and decision criteria for MySQL and PostgreSQL.
Aerospike Explained: The Complete Guide to Real-Time NoSQL at Scale
Achieve microsecond latencies at scale with Aerospike. Learn hybrid memory architecture, strong consistency, cross-datacenter replication, and use cases for AdTech and fraud detection.
PostgreSQL Replication: Streaming Replication, Logical Replication, and Synchronous Standby Setup
A complete guide to PostgreSQL replication — streaming replication setup, logical replication for selective table sync, synchronous standby configuration, monitoring replication lag, and failover with Patroni.
MySQL Full-Text Search: FULLTEXT Indexes, MATCH AGAINST, and Boolean Mode
A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.
PostgreSQL Logical Replication: Setup, Use Cases, and Limitations
Configure PostgreSQL logical replication for selective table sync, zero-downtime upgrades, and multi-tenant setups
AWS RDS PostgreSQL Cost Optimization
Optimize AWS RDS PostgreSQL costs without sacrificing performance. Learn instance sizing, storage class selection, backup strategies, and Multi-AZ optimization.
Database Backup Strategies: RTO, RPO, and Recovery Planning
RTO and RPO drive backup decisions. This guide covers mysqldump, XtraBackup, pgBackRest, WAL archiving, S3 object lock, and the 3-2-1-1-0 backup rule.
Database Monitoring with Prometheus, Grafana, and PMM
Monitor MySQL and PostgreSQL with Prometheus, Grafana, and PMM. Covers mysqld_exporter, postgres_exporter, alert rules, and production dashboard configuration.
Redis Performance Tuning for High-Traffic Applications
Tune Redis from measured latency and memory behavior: bound command work, fix big and hot keys, choose eviction intentionally, and test persistence.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed