The JusDB Database Engineering Blog

Implement schema change management with versioning, peer review, and automated validation for safe deployments

Migrate from DynamoDB to Aerospike for better cost-performance at scale. Real case study showing 60% cost reduction with improved latency and throughput.

PostgreSQL PITR lets you recover your database to any point in time — down to the second — by replaying WAL segments on top of a base backup. Here's how to set it up correctly.

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.

A production guide to online MySQL schema changes — when to use pt-online-schema-change vs gh-ost vs MySQL 8.0 INSTANT DDL, configuration parameters, the cutover mechanism, and a step-by-step safety playbook.

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows

Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms

Performing online schema changes on MySQL tables with triggers is a known pain point — pt-osc creates conflicting triggers, and gh-ost has its own limitations. Here are the safe approaches.

Use Percona XtraBackup to take hot physical backups of MySQL InnoDB — setup, verification, and restore steps

Implement zero-downtime database migrations with versioning strategies. Learn about Flyway, Liquibase, schema evolution patterns, and rollback strategies.

Evaluate PlanetScale for MySQL workloads — Vitess-based branching, non-blocking schema changes, and pricing

Choose a current MySQL logical backup tool from measured recovery needs, and migrate legacy mysqlpump jobs and archives without risking production data.