Stay organized with collections
Save and categorize content based on your preferences.
The following sections cover how to configure CDC for a self-managed MySQL database.
These instructions also work for databases such as MariaDB, Percona Server for
MySQL or Alibaba Cloud PolarDB.
Verify the configuration and retention period of the binary log
Confirm that the binary log is configured correctly by entering the following MySQL command:
SHOWGLOBALVARIABLESLIKE'%binlog_format%';
Verify that the value for the binlog_format variable is set to ROW.
Confirm that the row format for the binary log is set to FULL by entering the following MySQL command:
SHOWGLOBALVARIABLESLIKE'binlog_row_image';
Verify that the slave updates option for the binary log is set to ON by entering the following MySQL command:
SHOWGLOBALVARIABLESLIKE'log_slave_updates';
Verify that the retention period of the binary log is set to 7 days by entering the following MySQL command:
SHOWGLOBALVARIABLESLIKE'expire_logs_days';
Create a Datastream user
To create a Datastream user, enter the following MySQL commands: