We migrated from AWS to GCP with minimal downtime

说明与用途

团队将 PostgreSQL 从 AWS 迁移到 GCP，使用逻辑复制和快照实现最小停机时间。

问题

The team needed to move a production PostgreSQL database from AWS to GCP while keeping downtime to a minimum.

结果

The migration completed with less than 2 minutes of downtime, maintaining the 5 % SLA and preserving all data and configurations.

工作流

• 1. Created a Cloud SQL PostgreSQL 12 instance with identical configuration to the AWS RDS instance.
• 2. Enabled logical replication on the AWS RDS instance and set up a replication slot.
• 3. Configured the Cloud SQL instance as a subscriber to the replication slot.
• 4. Monitored replication lag and ensured it stayed below 1 s.
• 5. Performed a final data sync by taking a snapshot of the AWS RDS instance and restoring it to Cloud SQL.
• 6. Updated DNS and load balancer to point to the GCP instance.
• 7. Decommissioned the AWS RDS instance after verifying application stability.

证据

We migrated from AWS to GCP with minimal downtime

来源

The database was hosted on Amazon RDS PostgreSQL 12.6, with a 1.5 TB data volume and a 30 GB WAL archive.

来源

We performed a final data sync by taking a snapshot of the AWS RDS instance and restoring it to Cloud SQL.

来源