Binary Logging must be enabled for MySQL server

Question

Im trying to run a CDC task using AWS DMS from our Beta DB to our Dev DB and Im getting the following error:

```
Binary Logging must be enabled for MySQL server; Errors in MySQL server binary logging configuration. Follow all prerequisites for 'MySQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html or'MySQL as a target in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html ; Failed while preparing stream component 'st_0_core-beta'.; Cannot initialize subtask; Stream component 'st_0_core-beta' terminated [1020418]  (replicationtask.c:2888)
```

I have enabled the binlog_format to set to ROW and Im using the writer cluster endpoints for both the beta and dev DB. Is there any other parameter I need to change/set please?

Accepted Answer

Great thanks. Also, I was using the reader instance and not the clusters writer, I think that was the problem.

Answer

Hi, @marc-eprop

You can check other parameters from the following documents.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.AmazonManaged

Other parameters such as binlog_row_image and binlog_checksum are also mentioned here.

Binary Logging must be enabled for MySQL server

Relevant questions

Migrating from RDS MariaDB 10.2 to Aurora MySQL 5.6

Can we configure separate binary logging (binlog) on Aurora MySQL's Read Replica instance?

Migrate MySQL 8 to Aurora MySQL 8

Do source filters speed up DMS from AWS RDS to S3?

How to enable Logical Replication for existing Aurora PG 13 Cluster?

DMS CDC for SQL Server - Replication

MySQL binary Logging must use ROW format error

DMS CDC Verification

Binary Logging must be enabled for MySQL server

Please teach best CDC（Change Data Capture）tool in AWS