Amazon RDS for MySQL/ Aurora CDC Reader configuration. #

Using MySQL binary logs, the DBConvert Streams platform can retrieve data from Amazon RDS for MySQL/ Aurora. These logs contain records of data change events on the MySQL server. Whenever an INSERT, UPDATE, or DELETE event is written to the binary logs, MySQL Reader captures them immediately and passes them to the DBS event hub.

Create Amazon RDS for MySQL database. #

Note: You can disregard this step if you have already created a database.

To create an Amazon RDS for MySQL database, please follow these steps:

1. Go to the Amazon RDS console.
2. Click the Create database button.
3. Select MySQL as the database type and choose the desired version.

4. Configure parameters in the settings section, including DB Instance identifier, Credential settings, instance type and storage.
5. (Optional) In the Connectivity section, select Connect to an EC2 compute resource and choose an existing EC2 instance to connect to the database. This step can help you automatically connect DBConvert Services running on EC2 with MySQL without allowlisting them on the database side.

6. Ensure that automatic backups are activated for at least one day for the binary log to capture data modifications.

7. Review configuration and click the Create database button to create your Amazon RDS for MySQL database.

Set up MySQL Binary logs for Replication. #

To enable MySQL Binary Log (Binlog) replication, you must configure some parameters.

1. Open the Amazon RDS console.
2. Create new parameter group.

3. Click Edit parameters. Update the values of the parameters as follows:

4. Click Save changes.
5. Select your database, then click the Modify button.
6. Scroll down to the Additional configuration section and select recently created parameter group as the DB parameter group.

7. In the Databases panel, select Reboot from the Actions drop-down to restart your Amazon RDS MySQL instance for the changes to take effect.

Discover further details regarding the complete set of properties applicable to the MySQL Reader by visiting the following source: MySQL Reader properties.