Soru

Zorluk: ZorDesigning Migration Plans and Data Transfer Strategies

An automotive telematics enterprise needs to migrate 1.8 Petabytes of static binary log files and an active 4 TB MySQL transactional database from an on-premises data center to Google Cloud. The company has a 1 Gbps Dedicated Interconnect link available, but network policy caps migration bandwidth usage at 500 Mbps. The business mandates that the overall data transfer must complete within 30 days, and the transactional database cutover must incur minimal downtime. Which data transfer and migration strategy should a Cloud Architect recommend to meet these requirements?

  1. Order multiple Google Cloud Transfer Appliance devices to perform an offline bulk migration of the 1.8 PB binary logs, and use Database Migration Service with continuous replication over the Dedicated Interconnect for the 4 TB MySQL database.Cevap
  2. B
    Configure Storage Transfer Service to stream both the 1.8 PB binary log files and database backups directly into Cloud Storage over the Dedicated Interconnect link.
  3. C
    Establish a high-throughput HA VPN tunnel over the public internet to migrate the 1.8 PB log files via gsutil parallel composite uploads while using Database Migration Service for the database.
  4. D
    Export both the 1.8 PB binary logs and a full mysqldump of the transactional database onto Transfer Appliance devices, then migrate the database to Cloud Spanner upon arrival to eliminate continuous online replication needs.

Cevap

Order multiple Google Cloud Transfer Appliance devices to perform an offline bulk migration of the 1.8 PB binary logs, and use Database Migration Service with continuous replication over the Dedicated Interconnect for the 4 TB MySQL database.
The correct solution accurately separates the migration path based on data characteristics and constraints. Transferring 1.8 PB over a 500 Mbps network cap requires over 300 days. Using Transfer Appliance for offline transfer allows the 1.8 PB of binary logs to be securely ingested within the 30-day window. Meanwhile, the 4 TB active MySQL database can easily be transferred online over the Dedicated Interconnect link using Database Migration Service with continuous replication to achieve a near-zero downtime cutover.

Adım Adım Çözüm

1
Calculate network throughput capacity for the static dataset
Maximum network transfer rate = 500 Mbps=62.5 MB/s5.4 TB/day500 \text{ Mbps} = 62.5 \text{ MB/s} \approx 5.4 \text{ TB/day}. Transferring 1,800 TB over this link takes 1,8005.4333 days\frac{1,800}{5.4} \approx 333 \text{ days}, exceeding the 30-day limit.
Determines whether an online network transfer or offline physical appliance is required for the petabyte-scale static data.
2
Select the offline migration mechanism for unstructured binary logs
Deploy multiple Google Cloud Transfer Appliance units (e.g., 300 TB or 40 TB models) to ingest and physically ship the 1.8 PB dataset.
Transfer Appliance enables petabyte-scale data ingestion within days, adhering to the 30-day deadline without saturating network connections.
3
Select the online migration mechanism for the active MySQL transactional database
Use Database Migration Service (DMS) with continuous Change Data Capture (CDC) replication over the private Dedicated Interconnect.
A 4 TB database can easily sync over the 500 Mbps connection (4 TB÷5.4 TB/day18 hours4 \text{ TB} \div 5.4 \text{ TB/day} \approx 18 \text{ hours} initial load), and continuous replication ensures near-zero downtime cutover.

Anahtar Kavram

Selecting optimal Google Cloud migration tools based on dataset scale, available network throughput, and cutover downtime constraints.
Tahmini Süre:2m 30s
Bu soruyu puanla