A global e-commerce analytics company is modernizing a legacy inventory management platform to resolve architectural technical debt during its migration to Google Cloud. The system relies on an on-premises 8 TB transactional PostgreSQL database with heavy read and write traffic. The legacy architecture suffers from significant tech debt, including hardcoded IP addresses embedded across legacy components and unversioned database schemas. The company requires a migration strategy that supports continuous data replication to achieve near-zero downtime (under 15 minutes cutover) while decoupling application components from hardcoded database IP endpoints without modifying the legacy core code. Which migration architecture should the cloud architect recommend?
- Utilize Database Migration Service (DMS) to establish continuous change data capture (CDC) replication from the legacy PostgreSQL database to Cloud SQL for PostgreSQL, and implement Private Service Connect alongside Cloud DNS private zone entries to abstract endpoint IP addresses prior to cutover.Cevap
- BMigrate the legacy PostgreSQL database to Cloud Spanner by configuring custom batch export pipelines to continuously stream transactional logs until the planned cutover window.
- COrder a Google Cloud Transfer Appliance to capture an offline snapshot of the 8 TB PostgreSQL database, ship the appliance to Google Cloud, and restore the database instance into Cloud SQL during the maintenance window.
- DContainerize the legacy PostgreSQL database engine and deploy it onto Google Kubernetes Engine (GKE) using StatefulSets with host networking to preserve existing IP address mappings.