Examkin

Question

Difficulty: MediumDatabase Migration and Schema Conversion using DMS and SCT

A solutions architect is planning the migration of an on-premises MySQL database to an Amazon Aurora MySQL-Compatible Edition DB cluster. The migration must minimize application downtime, so the architect decides to use AWS Database Migration Service (AWS DMS) with a Full Load plus Ongoing Replication (CDC) task. The source database is highly active. During testing, the CDC replication task fails shortly after starting because updates and deletes on the source cannot be fully resolved by the replication task. Which configuration must be applied to the source MySQL database to resolve this issue and support continuous replication?

  1. Configure the source database to use ROW-based binary logging format and set the binary log row image parameter (binlog_row_image) to FULL.Answer
  2. B
    Configure the source database to use STATEMENT-based binary logging and set the binary log checksum parameter to CRC32.
  3. C
    Configure the source database to use MIXED-based binary logging and enable Global Transaction Identifiers (GTIDs) for replication.
  4. D
    Configure the source database to use ROW-based binary logging and call the mysql.rds_set_configuration procedure to set the binary log retention hours to 24.

Answer

Configure the source database to use ROW-based binary logging format and set the binary log row image parameter (binlog_row_image) to FULL.
Configuring the source MySQL database to use ROW-based binary logging format (`binlog_format = ROW`) and setting the binary log row image parameter (`binlog_row_image = FULL`) is a mandatory prerequisite for AWS DMS Change Data Capture (CDC) from a MySQL source. This ensures that the binary logs contain complete information about before and after states for update and delete events, allowing the DMS replication task to apply the changes to the target database.

Step-by-Step Solution

1
Analyze the failure mode of the AWS DMS CDC task.
The failure is related to updates and deletes on the source database not being fully resolvable by the replication task.
AWS DMS needs to capture both the before and after states of rows to replicate updates and deletes correctly.
2
Evaluate the database logging format requirements for AWS DMS CDC.
DMS requires ROW-based binary logging (`binlog_format = ROW`). STATEMENT or MIXED formats do not provide the necessary row-level changes.
This filters out options involving STATEMENT-based or MIXED-based logging.
3
Verify row image requirements and database environment constraints.
Setting `binlog_row_image = FULL` ensures that all columns are logged, which resolves issues with missing column data during updates. The on-premises constraint makes the RDS-specific procedure call invalid.
This confirms that row image configuration is the direct solution and eliminates the RDS-specific management procedure.

Key Concept

AWS DMS MySQL Source CDC Prerequisites
Rate this question

Topics

Database Migration and Schema Conversion using DMS and SCT

More questions from this topic