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

# Aurora MySQL source for ELT & CDC

> Configure Aurora MySQL as a data source in Integrate.io ELT & CDC. Set up binary log replication from your Aurora MySQL database instances.

## Requirement

* Aurora  cluster connecting to WRITER endpoint

### Create DB Parameter Group 

On AWS console,  create a DB Parameter Group for your Aurora cluster. This allows you to create a collection of parameters you can later attach to your cluster. Click on Create Parameter Groups, name its group name and description as you like, and hit Save.

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-65.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=46f7fbda98cb9d7f9fc014c746d10138" alt="Creating a new DB Parameter Group in the AWS RDS console" width="1714" height="1228" data-path="images/cdc/sources/image-65.png" />
</Frame>

**Edit DB Parameter Group**

Select that DB Parameter group you made and edit the following parameters:

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-66.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=b6b7b8aac9b33c8964122378ca7a0baf" alt="Editing DB Parameter Group settings for Aurora MySQL binlog" width="2298" height="914" data-path="images/cdc/sources/image-66.png" />
</Frame>

<br />

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-67.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=0ee498df6d4de2274c781a8d93b43dcd" alt="DB Parameter Group parameter values after editing" width="2308" height="888" data-path="images/cdc/sources/image-67.png" />
</Frame>

### Create DB Cluster Parameter Group

Next step is to create a **DB Cluster Parameter Group** for your Aurora cluster. This allows you to create a collection of parameters you can later attach to your cluster. First click on **Parameter Groups** from the left pane, name its group name and description as you like, and hit **Save.**

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-68.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=5f61e701fab27c95afc3835243e11389" alt="Creating a new DB Cluster Parameter Group in the AWS RDS console" width="1804" height="1218" data-path="images/cdc/sources/image-68.png" />
</Frame>

### Edit DB Cluster Parameter Group

Select that DB Cluster Parameter Group you made and edit the following parameters:

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-69.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=9f6c30fb347b4b233e50d490249e4fdc" alt="Editing DB Cluster Parameter Group binlog settings" width="2304" height="884" data-path="images/cdc/sources/image-69.png" />
</Frame>

<br />

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-69.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=9f6c30fb347b4b233e50d490249e4fdc" alt="DB Cluster Parameter Group updated parameter values" width="2304" height="884" data-path="images/cdc/sources/image-69.png" />
</Frame>

<br />

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-71.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=2ad91452db0b42cafb1d3b104db79c81" alt="Additional DB Cluster Parameter Group configuration parameters" width="2276" height="758" data-path="images/cdc/sources/image-71.png" />
</Frame>

<br />

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-72.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=40dd72b57dd7e1808e8cedf12aca493b" alt="Saved DB Cluster Parameter Group configuration overview" width="1598" height="616" data-path="images/cdc/sources/image-72.png" />
</Frame>

### Configure The Instance

Attach the DB Parameter Group to your Aurora cluster. From the list of Aurora clusters, select the Aurora cluster you want to modify. Then click on **Modify**. You will need to change the DB Parameter Group and the DB Cluster Parameter Group to the one you just created. Finally, click the check box for **Apply Immediately**, confirm the changes, and **Modify**.

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-72.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=40dd72b57dd7e1808e8cedf12aca493b" alt="Modifying the Aurora cluster to attach the new parameter groups" width="1598" height="616" data-path="images/cdc/sources/image-72.png" />
</Frame>

<br />

<Frame>
  <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-73.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=021734e454c7a08e21f139694255f4fc" alt="Confirming parameter group changes with Apply Immediately selected" width="1654" height="536" data-path="images/cdc/sources/image-73.png" />
</Frame>

## Create user for Sync

On your sourceDB, create a sync user for Integrate.io by executing,

```sql theme={null}
CREATE USER 'flydata'@'%' IDENTIFIED BY '<your_password>';
```

Grant necessary privileges,

```sql theme={null}
GRANT SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT, LOCK TABLES ON *.* TO 'flydata'@'%';
FLUSH PRIVILEGES;
```

## Increase binlog retention

To increase the binlog retention of the DB cluster, use the mysql\_rds\_set\_configuration procedure. You can run the following command and sample parameters on the writer instance to retain the binlog files for 7 days:

```sql theme={null}
CALL mysql.rds_set_configuration('binlog retention hours', 168);
```