DBS-C01 · Question #288
A company's database specialist is migrating a production Amazon RDS for MySQL database to Amazon Aurora MySQL. The source database is configured for Multi-AZ. The company's production team wants to v
The correct answer is A. Enable automatic backups on the source database C. Enable binary logging. Set the binlog format parameter to ROW on the source database. E. Use the source primary database as the source endpoint for the DMS task. Configure the task as. To migrate a production Amazon RDS for MySQL Multi-AZ database to Amazon Aurora MySQL using AWS DMS for validation before cutover, enable automatic backups, set binary logging to ROW format, and use the primary database as the DMS source endpoint.
Question
A company's database specialist is migrating a production Amazon RDS for MySQL database to Amazon Aurora MySQL. The source database is configured for Multi-AZ. The company's production team wants to validate the target database before switching the associated application over to use the new database endpoint. The database specialist plans to use AWS Database Migration Service (AWS DMS) for the migration. Which steps should the database specialist perform to meet the production team's requirement? (Choose three.)
Options
- AEnable automatic backups on the source database
- BDisable automatic backups on the source database
- CEnable binary logging. Set the binlog format parameter to ROW on the source database.
- DEnable binary logging. Set the binlog_format parameter to MIXED on the source database
- EUse the source primary database as the source endpoint for the DMS task. Configure the task as
- FUse the source secondary database as the source endpoint for the DMS task. Configure the task
How the community answered
(33 responses)- A64% (21)
- B9% (3)
- D21% (7)
- F6% (2)
Why each option
To migrate a production Amazon RDS for MySQL Multi-AZ database to Amazon Aurora MySQL using AWS DMS for validation before cutover, enable automatic backups, set binary logging to ROW format, and use the primary database as the DMS source endpoint.
Enabling automatic backups on the source RDS database is a critical best practice to ensure data recovery and safety during any migration process, even though it doesn't directly enable DMS.
Disabling automatic backups on a production database before or during a migration is a poor practice that increases the risk of data loss.
AWS DMS requires binary logging to be enabled on the MySQL source database to capture change data for continuous replication, and setting the `binlog_format` parameter to `ROW` is generally recommended for data consistency and integrity during replication tasks.
While binary logging is essential, setting the `binlog_format` to `ROW` (as in option C) is generally the preferred and more robust choice for AWS DMS replication tasks to ensure data accuracy compared to `MIXED`.
When using AWS DMS with an Amazon RDS Multi-AZ source, the DMS task must use the primary database instance as its source endpoint to capture all writes and replicate them to the target.
AWS DMS tasks are configured to connect to the primary instance of an RDS Multi-AZ deployment to capture changes, not the secondary (standby) instance.
Concept tested: AWS DMS prerequisites for homogeneous MySQL migration
Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html
Topics
Community Discussion
No community discussion yet for this question.