Restart your MySQL server so that the changes you made can take effect.
Create a Datastream user
To create a Datastream user, enter the following MySQL commands:
CREATE USER 'datastream'@'%' IDENTIFIED BY '[YOUR_PASSWORD]';
GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
FLUSH PRIVILEGES;
Configure an Amazon Aurora MySQL database
The following sections cover how to configure CDC for an Amazon Aurora MySQL database.
Create a parameter group
Launch your Amazon RDS Dashboard.
In the Navigation Drawer, click Parameter Groups, and then click Create Parameter Group. The Create Parameter Group page appears.
Use the following table to populate the fields of this page, and then click Create:
Field
Description
Parameter group family
Select the family that matches your database.
Type
Select DB Cluster Parameter Group.
Group name
Provide a name for the parameter group.
Description
Provide a description for the parameter group.
Select the checkbox to the left of your newly created parameter group, and then, under Parameter group actions, click Edit.
Change the value of the binlog_format parameter to ROW.
Click Save Changes.
Assign the parameter group to the database instance
Launch your Amazon RDS Dashboard.
In the Navigation Drawer, click Databases, and then select your database instance.
From the Instance Actions menu, select Modify. The Modify DB Instance dialog box appears.
In the Additional configuration section, select the database cluster parameter group that you created.
Set the Backup retention period to 7 days.
Click Continue.
In the Scheduling of Modifications pane, select the Apply immediately option.
Restart your MySQL server so that the changes you made can take effect.
Create a Datastream user
To create a Datastream user, enter the following MySQL commands:
CREATE USER 'datastream'@'%' IDENTIFIED BY '[YOUR_PASSWORD]';
GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
FLUSH PRIVILEGES;
To create a Datastream user, enter the following MySQL commands:
CREATE USER 'datastream'@'%' IDENTIFIED BY '[YOUR_PASSWORD]';
GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
FLUSH PRIVILEGES;
Configure a self-hosted MySQL database
The following sections cover how to configure CDC for a self-hosted MySQL database.
Verify the configuration and retention period of the binary log
Confirm that the binary log is configured correctly by entering the following MySQL command:
SHOW GLOBAL VARIABLES LIKE '%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:
SHOW GLOBAL VARIABLES LIKE 'binlog_row_image';
Verify that the slave updates option for the binary log is set to ON by entering the following MySQL command:
SHOW GLOBAL VARIABLES LIKE 'log_slave_updates';
Verify that the retention period of the binary log is set to 7 days by entering the following MySQL command:
SHOW GLOBAL VARIABLES LIKE 'expire_logs_days';
Create a Datastream user
To create a Datastream user, enter the following MySQL commands:
CREATE USER 'datastream'@'%' IDENTIFIED BY '[YOUR_PASSWORD]';
GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
FLUSH PRIVILEGES;