How do I troubleshoot binary logging errors that I received when using AWS DMS with Aurora MySQL as the source?
I have an Amazon Aurora DB instance that is running MySQL and binary logging is enabled. I'm using the Aurora DB instance as the source for an AWS Database Migration Service (AWS DMS) task, and I received an error. How do I troubleshoot and resolve this error?
If binary logging isn't enabled or you're connected to the reader instance, then you see a log entry similar to the following:
[SOURCE_CAPTURE ]I: System var 'log_bin' = 'OFF'
[SOURCE_CAPTURE ]E: Error Code  : Binary Logging must be enabled for MySQL server  (mysql_endpoint_capture.c:366)
If you're connected to the reader instance, first identify the writer instance, and then connect to the writer instance with AWS DMS. It's a best practice to connect to the cluster endpoint because the cluster endpoint points to the current writer of the cluster at all times.
Then, connect to the source Aurora cluster writer node by using the cluster endpoint to confirm that binary logging is enabled:
mysql> show global variables like "log_bin";
| Variable_name | Value |
| log_bin | OFF |