Examkin

Soru

Zorluk: OrtaDatabase Migration and Schema Conversion using DMS and SCT

A company is migrating an on-premises MySQL database to an Amazon Aurora PostgreSQL-Compatible Edition DB cluster using AWS Database Migration Service (AWS DMS) and the AWS Schema Conversion Tool (AWS SCT). The migration strategy requires a full load followed by continuous replication (Change Data Capture) to minimize application downtime. After the AWS DMS task completes the full load phase successfully, the replication task fails to capture any ongoing inserts or updates from the source MySQL database.

Which of the following database configurations must be modified on the source MySQL database to allow AWS DMS to successfully perform Change Data Capture?

  1. A
    Enable supplemental logging at the database level and configure the source database to write full image rows to the redo log.
  2. Configure the binary log format (binlog_format) to ROW and set the binary log retention period to a non-zero value on the source MySQL database.Cevap
  3. C
    Convert the database migration to an offline replatforming strategy using pg_dump and pg_restore directly from the source to the target DB cluster.
  4. D
    Enable Aurora Auto Scaling on the target Aurora cluster to provision additional Read Replicas to handle the replication load.

Cevap

Configure the binary log format (binlog_format) to ROW and set the binary log retention period to a non-zero value on the source MySQL database.
For AWS DMS to perform Change Data Capture (CDC) on a source MySQL database, binary logging must be enabled, the binary log format must be set to ROW, and the binlog retention period must be set to a value greater than zero. This allows the DMS replication task to read the row-level changes from the binary logs.

Adım Adım Çözüm

1
Analyze the failure stage and the source database engine.
The source database is MySQL, the target is Aurora PostgreSQL, and the full load succeeded but CDC failed. This indicates the issue lies in the source change logging configuration.
AWS DMS requires specific database logging configurations on the source engine to read transaction logs for CDC.
2
Identify the required CDC configuration for a MySQL source database.
MySQL requires row-based binary logging (binlog_format = ROW) and a non-zero log retention period.
Without ROW-based binary logging, DMS cannot capture row-level transactional changes, and without log retention, logs might be purged before DMS can read them.
3
Select the option that matches this configuration change and satisfies the low-downtime requirement.
Configuring row-based binary logging on the source MySQL database allows the DMS task to resume CDC and minimize downtime.
This configuration directly addresses the root cause of the CDC replication failure on MySQL.

Anahtar Kavram

AWS DMS CDC prerequisites for MySQL source databases
Bu soruyu puanla

Konular

Database Migration and Schema Conversion using DMS and SCT

Bu konudan daha fazla soru