The JusDB Database Engineering Blog

Optimize AWS RDS PostgreSQL costs without sacrificing performance. Learn instance sizing, storage class selection, backup strategies, and Multi-AZ optimization.

Monitor MySQL and PostgreSQL with Prometheus, Grafana, and PMM. Covers mysqld_exporter, postgres_exporter, alert rules, and production dashboard configuration.

Secure your MySQL and PostgreSQL databases — TLS, at-rest encryption, role-based access, and audit logging

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.

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

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.

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.