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?

marc-eprop · Accepted Answer

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

iwasa · 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 content