The JusDB Database Engineering Blog

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.

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

Migrate MySQL schema changes online with gh-ost using binlog streaming instead of triggers. Covers dynamic throttling via Unix socket, postpone-cut-over flag, and test-on-replica mode.

Perform zero-downtime MySQL schema changes with pt-online-schema-change. Covers how it works, throttle settings, max-load protection, and when to use gh-ost instead.

Monitor ETL pipelines with data freshness checks, row count reconciliation, dbt data quality tests, and Slack alerting. Detect silent failures before users do.

Configure PostgreSQL logical replication for selective table sync and zero-downtime major version upgrades. Covers publications, subscriptions, and replication slot monitoring.

MariaDB and MySQL have diverged significantly. This guide compares licensing, Galera vs Group Replication, thread pool, cloud support, and migration paths.

PostgreSQL disaster recovery requires more than just running pg_dump — it needs WAL archiving, PITR capability, regular restore testing, and clear RTO/RPO targets. Here's how to build it.

MySQL 8.0 end-of-life is April 2026. Plan your upgrade to MySQL 8.4 LTS now. Learn migration strategies, new features, and compatibility considerations.

Migrate from Redis to Valkey — compatibility, performance benchmarks, and what changes for operators

PostgreSQL 17 finally adds native incremental backup support — allowing subsequent backups to capture only changed blocks since the last full backup.

Downgrading MongoDB requires careful planning — setting the Feature Compatibility Version before replacing binaries, handling replica set members in sequence, and verifying data integrity throughout.