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.
Set the binary log retention period
Enter the following MySQL command:
call mysql.rds_set_configuration('binlog retention hours', 168);
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;
What's next
- Learn more about how Datastream works with MySQL sources.