> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Set up AWS RDS MySQL & Aurora (MySQL-compatible)

> How to set up AWS RDS MySQL or Aurora as a source for RisingWave.

We will use a standard class AWS RDS MySQL instance without Multi-AZ deployment for illustration, but the process will be similar for Aurora.

1. Turn on binary logging and choose a non-zero value for the **Retention period**.

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/32PTodGr5zqa37oO/images/ret-period.png?fit=max&auto=format&n=32PTodGr5zqa37oO&q=85&s=750b30d6cc15f040b770cedeca66abaa" width="1520" height="968" data-path="images/ret-period.png" />
</Frame>

2. Create a parameter group for MySQL instances. We created a parameter group named MySQL-CDC for the instance that runs MySQL 5.7.x.

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/WbP1tBXrlrW-TXIi/images/parameter-group.png?fit=max&auto=format&n=WbP1tBXrlrW-TXIi&q=85&s=731097374c4820b3640f4803b8705da0" width="2016" height="1006" data-path="images/parameter-group.png" />
</Frame>

3. Click the MySQL-CDC parameter group to edit the values of **binlog\_format** to **ROW** and **binlog\_row\_image** to **full**.

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/eqqtg34aUutkXCuz/images/binlog-format.png?fit=max&auto=format&n=eqqtg34aUutkXCuz&q=85&s=f3f8b6f3445bd8cf188a0eef89096120" width="1580" height="144" data-path="images/binlog-format.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/eqqtg34aUutkXCuz/images/binlog-row.png?fit=max&auto=format&n=eqqtg34aUutkXCuz&q=85&s=e4c30e8e025cb3e5c499239e72f488ac" width="1540" height="104" data-path="images/binlog-row.png" />
</Frame>

4. Modify your RDS instance and apply the modified parameter group to your database.

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/WbP1tBXrlrW-TXIi/images/modify-RDS.png?fit=max&auto=format&n=WbP1tBXrlrW-TXIi&q=85&s=56f3ff3acd4da7e674897c559a48068a" width="2156" height="362" data-path="images/modify-RDS.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/eqqtg34aUutkXCuz/images/apply-to-database.png?fit=max&auto=format&n=eqqtg34aUutkXCuz&q=85&s=4852dd5bc5a6176b25daf97dbca3e638" width="1376" height="596" data-path="images/apply-to-database.png" />
</Frame>

5. Click **Continue** and choose **Apply immediately**. Finally, click **Modify DB instance** to save the changes. Remember to reboot your MySQL instance.

<Frame>
  <img src="https://mintcdn.com/risingwavelabs/32PTodGr5zqa37oO/images/save-changes.png?fit=max&auto=format&n=32PTodGr5zqa37oO&q=85&s=5fdde6db3aa282fe01ce11c1b52ce150" width="1524" height="578" data-path="images/save-changes.png" />
</Frame>

6. Ensure your MySQL users can access the tables and replications.