The JusDB Database Engineering Blog

Implement database CI/CD with Flyway migrations, GitHub Actions pipelines, pytest schema tests, and blue-green deployment patterns. Eliminate ad-hoc schema changes.

A practical guide to hardening PostgreSQL: configure SSL/TLS, tighten pg_hba.conf, implement least-privilege roles, enable row-level security, and set up audit logging.

PostgreSQL's logging system is powerful but requires careful configuration to be useful in production. Learn how to capture slow queries, connection events, and DDL changes without drowning in noise.

Upgrade PostgreSQL major versions with sub-second downtime using logical replication. Step-by-step guide covering schema copy, subscription setup, lag monitoring, and sequence resync.

Monitor InnoDB lock contention with performance_schema.data_locks, find blocking transactions, kill them safely, and prevent escalation with short transactions and proper timeouts.

Build a complete database observability stack with Prometheus metrics, slow query logs, and OpenTelemetry distributed traces. Includes alert rules for replication lag and cache hit rate.

Aerospike 7.0 delivers 1 million writes per second with sub-millisecond latency using its Hybrid Memory Storage architecture. Learn when Aerospike beats Redis and Cassandra, and how to configure it for production.

Execute MySQL schema migrations safely with the expand-contract pattern, batched backfills, backward-compatible changes, and migration tooling comparison (Flyway, Liquibase, gh-ost).

ClickHouse MergeTree is why ClickHouse queries 1 billion rows in 0.3 seconds. Learn how parts, merges, and sparse indexes work, and how to choose the ORDER BY key, secondary indexes, and MergeTree variants.

Understand why MySQL removed the query cache in 8.0 and what to use instead: application-level Redis caching, ProxySQL query cache, and pre-computed summary tables.

PostgreSQL 17 ships eager freezing and improved autovacuum prioritization, the most significant vacuum improvements in a decade. Learn how to tune autovacuum for high-write tables and prevent transaction ID wraparound.

Guide the PostgreSQL query planner with enable_xxx settings, pg_hint_plan extension, and extended statistics for correlated columns. Fix bad plans without rewriting queries.