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
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:
- Go to the Amazon RDS console.
- Click the
- Select MySQL as the database type and choose the desired version.
- Configure parameters in the
DB Instance identifier,
- (Optional) In the
Connect to an EC2 compute resourceand 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.
- Ensure that
automatic backupsare activated for at least one day for the binary log to capture data modifications.
- Review configuration and click the
Create databasebutton 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.
- Open the Amazon RDS console.
- Create new
Edit parameters. Update the values of the parameters as follows:
- Select your database, then click the
- Scroll down to the
Additional configurationsection and select recently created parameter group as the
DB parameter group.
- In the
Actionsdrop-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.