By using AWS re:Post, you agree to the Terms of Use
/Binary Logging must be enabled for MySQL server/

Binary Logging must be enabled for MySQL server

0

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?

asked 10 days ago2 views
2 Answers
0
Accepted Answer

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

answered 10 days ago
0

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.

answered 10 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions