The JusDB Database Engineering Blog

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

MySQL's ecosystem includes three main logical backup tools — mysqldump, mysqlpump, and mydumper. Each has distinct performance characteristics, parallelism support, and compatibility trade-offs.