Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.
42 articles
Showing 12 of 42 articles
MongoDB's mongosync utility enables continuous, real-time synchronization between two MongoDB clusters — simplifying live migrations, multi-cloud replication, and DR setups.
Apply GitOps principles to database changes — PR-based schema reviews, automated migrations, and rollback strategies
A production guide to zero-downtime database migrations — why ALTER TABLE causes downtime, the Expand-Contract pattern, safe migration patterns for PostgreSQL and MySQL, and tooling with Flyway, Liquibase, pt-osc, and gh-ost.
Use pg_upgrade to migrate between PostgreSQL major versions — upgrade strategies, pre-checks, and rollback plans
A production guide to AWS Database Migration Service — replication instance sizing, endpoint configuration, Full Load vs CDC vs Full Load+CDC modes, performance tuning, and DMS vs Debezium vs pglogical.
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.
mysqlpump adds parallel backup support to MySQL's logical dump toolset — enabling multi-threaded exports that can be 3-5x faster than mysqldump for large databases.
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
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed