The JusDB Database Engineering Blog

Running a single PMM server is a single point of failure for your database monitoring. Here's how to set up PMM in an HA configuration with failover and shared storage.

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

Deploy PMM to get deep MySQL and PostgreSQL visibility — query analytics, dashboards, and alerting in one tool

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.

Master PostgreSQL VACUUM and autovacuum configuration for optimal database health. Learn dead tuple management, bloat prevention, and vacuum optimization strategies.

PgBouncer is the most widely deployed PostgreSQL connection pooler — lightweight, battle-tested, and straightforward to configure. Here's how to get it running in production.

PgPool-II provides connection pooling, read/write splitting, and automatic failover for PostgreSQL — but its extensive configuration can be overwhelming. Here's a practical guide to getting PgPool-II running in production.