The JusDB Database Engineering Blog

A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.

Configure PostgreSQL logical replication for selective table sync, zero-downtime upgrades, and multi-tenant setups

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

RTO and RPO drive backup decisions. This guide covers mysqldump, XtraBackup, pgBackRest, WAL archiving, S3 object lock, and the 3-2-1-1-0 backup rule.

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

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

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.

A deep dive into InnoDB locking — record locks, gap locks, next-key locks, how READ COMMITTED eliminates gap locks, diagnosing deadlocks with SHOW ENGINE INNODB STATUS and performance_schema, and prevention patterns.

MySQL InnoDB supports multiple compression strategies — from ROW_FORMAT=COMPRESSED to transparent page compression using punch holes. Choosing the right approach can cut storage by 40-70% for text-heavy workloads.

Essential MySQL diagnostic queries every DBA needs. Quickly identify slow queries, lock contention, replication lag, memory issues, and connection problems.