Examkin

Question

Difficulty: EasyDatabase Migration and Schema Conversion using DMS and SCT

A company is planning to migrate an on-premises MySQL database to an Amazon Aurora MySQL DB cluster using AWS Database Migration Service (DMS). The company requires the database to remain online during the migration, with all ongoing transactional changes continuously replicated to the target database. Which configuration must be enabled on the source database to meet this requirement?

  1. A
    Enable Multi-AZ replication on the target Amazon Aurora MySQL cluster.
  2. Enable binary logging (binlog) in ROW format on the source MySQL database.Answer
  3. C
    Run the AWS Schema Conversion Tool (SCT) to generate a database migration assessment report.
  4. D
    Configure the DMS task to use the 'Migrate existing data' (full-load) migration type only.

Answer

Enable binary logging (binlog) in ROW format on the source MySQL database.
To perform ongoing replication (Change Data Capture) from a MySQL database, AWS DMS must read the source database's binary logs. Therefore, enabling binary logging (binlog) in ROW format on the source MySQL database is a mandatory prerequisite.

Step-by-Step Solution

1
Identify the migration type and requirements.
The target migration is homogeneous (MySQL to Aurora MySQL) and requires continuous replication (Change Data Capture) to minimize downtime.
Understanding the migration pattern helps determine if schema conversion is needed and which replication settings are mandatory.
2
Determine the source database prerequisites for AWS DMS Change Data Capture (CDC).
AWS DMS requires access to the source database engine's transaction log (the binary log for MySQL) to read ongoing changes.
Without transaction log access, DMS cannot identify which records have changed since the initial full load began.
3
Select the correct option that satisfies the log requirements.
Enabling binary logging in ROW format on the source MySQL database enables DMS to capture and replicate row-level changes.
This is a mandatory configuration step for MySQL source databases when using AWS DMS for continuous replication.

Key Concept

AWS DMS Change Data Capture (CDC) prerequisites for MySQL source databases.
Rate this question

Topics

Database Migration and Schema Conversion using DMS and SCT

More questions from this topic