The JusDB Database Engineering Blog

MySQL 8.4's audit log filter system lets you capture exactly the events your compliance framework requires — filtering by user, schema, event class, and severity to reduce audit log volume.

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.

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.

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.

Use pg_repack to reclaim PostgreSQL table bloat without the exclusive lock of VACUUM FULL. Covers installation, table vs index repack, disk space requirements, and throttling.

Size and tune the MySQL 8.4 InnoDB buffer pool from a complete memory budget, measured I/O and latency, safe resize tests, and restart warm-up behavior.

Enable and tune PostgreSQL parallel query for analytical workloads. Covers max_parallel_workers settings, PARALLEL SAFE functions, JIT compilation, and execution plan verification.

Manage Elasticsearch indexes with ILM policies, correct shard sizing, and force merge for historical indices. Covers hot/warm/delete phases and cluster health monitoring.

MySQL 8 introduced comprehensive password management — password validation policies, reuse history, expiration, and dual passwords for zero-downtime credential rotation.

Implement MySQL table partitioning with RANGE and HASH strategies. Covers instant partition drops for data lifecycle, partition pruning verification, and key gotchas.

PostgreSQL offers multiple index types for different access patterns — and choosing wrong means slow queries or wasted space. A comprehensive guide to indexing strategy, from type selection to monitoring and maintenance.