← All services

Databases

PostgreSQL and MySQL: upgrades, backups, replication

Major version upgrades with little downtime, backups you have actually restored, replicas.

PostgreSQL 14 is now end of life. I upgrade with pg_upgrade or logical replication, set up streaming replicas, point-in-time backups with pgBackRest, and tune slow queries. MySQL and MariaDB too.

What you get

  • ✓Upgrade or replica done
  • ✓Backup with a tested restore
  • ✓Tuning notes

Tools: PostgreSQL, pgBackRest, MySQL, MariaDB, Redis

PostgreSQL and MySQL: upgrades, backups, replication | Vortik