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?