The JusDB Database Engineering Blog

A production guide to Amazon Aurora PostgreSQL — the shared storage architecture, fast failover mechanics, Aurora Serverless v2 ACU scaling, Global Database, Parallel Query, and an honest comparison against standard RDS.

Use Spark with JDBC to read from and write to relational databases — partition strategies, predicate pushdown, and write modes

Master MySQL index data structures and optimization strategies. Learn B+ tree internals, index selection, covering indexes, and real-world performance case studies.

A production guide to AWS RDS Proxy — how it works, when to use it, IAM authentication setup, and the connection pool sizing rules that prevent Lambda-induced database overload.

A production guide to TimescaleDB — hypertable setup, automatic chunk management, columnar compression policies, retention policies, continuous aggregates with time_bucket(), and comparison against InfluxDB and Prometheus.

Achieve microsecond latencies at scale with Aerospike. Learn hybrid memory architecture, strong consistency, cross-datacenter replication, and use cases for AdTech and fraud detection.

Master Redis performance tuning with expert tips on memory optimization, connection pooling, data structures, and caching strategies for high-traffic apps.

PgBouncer multiplexes thousands of application connections onto a small pool of real PostgreSQL server connections — reducing connection overhead without any application code changes.

A deep dive into InnoDB locking — record locks, gap locks, next-key locks, how READ COMMITTED eliminates gap locks, diagnosing deadlocks with SHOW ENGINE INNODB STATUS and performance_schema, and prevention patterns.

MySQL InnoDB supports multiple compression strategies — from ROW_FORMAT=COMPRESSED to transparent page compression using punch holes. Choosing the right approach can cut storage by 40-70% for text-heavy workloads.

Deploy PgBouncer in transaction mode for high-concurrency PostgreSQL workloads — config, monitoring, and tuning

A practical guide to Redis use cases in production — cache-aside pattern, sliding window rate limiting, Pub/Sub vs Streams, BRPOP queues with delayed job scheduling, and session storage with persistence configuration.