The JusDB Database Engineering Blog

Learn how JusDB optimized a TimescaleDB cluster ingesting billions of IoT readings monthly, achieving 10× faster writes and 65% storage reduction.

Build a data-driven capacity planning process using historical metrics, growth trends, and resource modeling

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

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.

Analyze real-world database schema designs from companies like Netflix, Uber, and Airbnb. Learn practical patterns for e-commerce, social media, and IoT applications.

Use Azure Cosmos DB for globally distributed workloads — consistency levels, partitioning, and API choices

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.

Tune Redis from measured latency and memory behavior: bound command work, fix big and hot keys, choose eviction intentionally, and test persistence.

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

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.

A comprehensive guide to database connection pooling — comparing PgBouncer, ProxySQL, and HikariCP with configuration examples, pool mode trade-offs, and production sizing recommendations.

Understand MySQL max_connections, thread caching, and connection pool sizing to handle high-concurrency workloads