Examkin

Soru

Zorluk: OrtaDatabase Migration and Schema Conversion using DMS and SCT

A company is migrating a production MySQL database running on an on-premises physical server to an Amazon Aurora PostgreSQL-Compatible Edition DB cluster. The migration must be completed with minimal downtime. A Solutions Architect plans to use the AWS Schema Conversion Tool (AWS SCT) and the AWS Database Migration Service (AWS DMS) with Change Data Capture (CDC). Which of the following actions must the Solutions Architect perform to ensure a successful migration with ongoing replication? (Select TWO.)

  1. Run the AWS Schema Conversion Tool (AWS SCT) to convert the MySQL database schema to PostgreSQL, apply the generated schema DDL to the target Aurora DB cluster, and then initiate the AWS DMS replication task.Cevap
  2. Enable binary logging on the source MySQL database, configure the binlog format to ROW, set the binlog retention period to at least 24 hours, and restart the database service before starting the AWS DMS task.Cevap
  3. C
    Configure the AWS DMS replication task with default settings to automatically convert MySQL-specific stored procedures, triggers, and secondary indexes on-the-fly during the data migration.
  4. D
    Start the AWS DMS task with CDC enabled without altering the source MySQL configuration, relying on AWS DMS to automatically enable supplemental logging on the source database engine.
  5. E
    Configure the AWS DMS source endpoint to run in full load and CDC mode using the default AWS-managed KMS key aws/rds to encrypt cross-account credentials and data transit.

Cevap

The Solutions Architect must run the AWS Schema Conversion Tool (AWS SCT) to convert the MySQL database schema to PostgreSQL, apply the schema to the target Aurora DB cluster, and enable binary logging on the source MySQL database with the ROW format and adequate binlog retention before starting the AWS DMS task.
For a successful heterogeneous database migration with minimal downtime, the target schema must first be created. The AWS Schema Conversion Tool (AWS SCT) is used to convert the source schema (MySQL) to the target schema (PostgreSQL) and apply it. For ongoing replication (CDC) to function, the source MySQL database must have binary logging enabled with a format of ROW, as AWS DMS reads these binary logs to replicate changes to the target database.

Adım Adım Çözüm

1
Perform schema conversion using AWS SCT.
The target Aurora PostgreSQL DB cluster schema is created with converted tables, indexes, stored procedures, and views.
AWS DMS does not perform heterogeneous schema conversion automatically; it only migrates data and creates basic tables.
2
Configure binary logging on the source MySQL database.
The source database writes change logs in ROW format with sufficient retention (e.g., 24 hours) for AWS DMS to read.
Change Data Capture (CDC) requires binary logging to be enabled on the source MySQL engine to capture ongoing updates.
3
Create and run the AWS DMS task in full load and CDC mode.
Data is migrated to Aurora PostgreSQL and kept in sync via ongoing replication with minimal downtime.
The combination of SCT schema application and DMS CDC replication achieves a near-zero downtime heterogeneous database migration.

Anahtar Kavram

Heterogeneous database migration requires schema conversion using AWS SCT first, followed by data replication using AWS DMS. Ongoing replication (CDC) requires appropriate transaction log configurations (like binary logging for MySQL or supplemental logging for Oracle) on the source database.
Bu soruyu puanla

Konular

Database Migration and Schema Conversion using DMS and SCT

Bu konudan daha fazla soru