Examkin

Question

Difficulty: MediumDatabase Migration and Schema Conversion using DMS and SCT

A retail company is planning to migrate its self-managed MySQL database running on an on-premises server to an Amazon Aurora PostgreSQL-Compatible Edition DB cluster. The solutions architect needs to configure the source MySQL database to support ongoing replication (Change Data Capture) using AWS Database Migration Service (DMS). Which configurations must be applied to the source MySQL database to enable AWS DMS CDC? (Select two.)

  1. Enable binary logging on the source MySQL instance by setting the log_bin configuration parameter.Answer
  2. Set the binlog_format parameter to ROW to record row-level changes.Answer
  3. C
    Enable supplemental logging at the database level and table level for all replicated tables.
  4. D
    Set the wal_level parameter to logical and create a logical replication slot.
  5. E
    Ensure the SQL Server Agent service is running and configure the database for the Full Recovery model.

Answer

The correct configurations are to enable binary logging on the source MySQL instance by setting the log_bin parameter, and to set the binlog_format parameter to ROW.
To support Change Data Capture (CDC) from a MySQL source database, AWS Database Migration Service (DMS) reads the MySQL binary logs. Therefore, binary logging must be enabled on the source database using the log_bin parameter. Additionally, the binary log format (binlog_format) must be set to ROW to ensure that row-level modifications are written to the binary logs in a structured format that AWS DMS can interpret.

Step-by-Step Solution

1
Identify the source database engine and the replication requirements.
The source database is MySQL and requires Change Data Capture (CDC) for ongoing replication.
AWS DMS requires different log-based configuration settings depending on the source database engine type.
2
Determine the required binary logging settings for MySQL CDC in AWS DMS.
Binary logging must be enabled using the log_bin parameter, and the binlog_format must be set to ROW.
AWS DMS parses MySQL's binary logs in row-level format to replicate changes to the target database.
3
Filter out configurations belonging to other database engines.
Supplemental logging is for Oracle, wal_level is for PostgreSQL, and SQL Server Agent/Full Recovery is for Microsoft SQL Server.
Applying prerequisites for the wrong database engine will not enable CDC on the MySQL source.

Key Concept

Configuring source database log settings (such as binary logs for MySQL) is a mandatory prerequisite for AWS DMS to perform Change Data Capture (CDC) replication.
Rate this question

Topics

Database Migration and Schema Conversion using DMS and SCT

More questions from this topic