Amazon Aurora MySQL

Prerequisites

• The Amazon Aurora MySQL instance is running.

• The MySQL version is 5.5 or higher. You can choose the MySQL version while creating the instance.

• The database hostname and port number of the Amazon Aurora MySQL instance are available.

• Hevo’s IP addresses are whitelisted.

• The necessary privileges are granted to the database user.

• You are assigned the Team Collaborator or any administrator role except the Billing Administrator role in Hevo to create the Destination.

---

Retrieve the Hostname and Port Number (Optional)

Note: The Amazon Aurora MySQL hostnames start with your database name and end with rds.amazonaws.com. For example, mysql-rds-replica-1.xxxxxxxxx.rds.amazonaws.com.

1. In the left navigation pane of the Amazon RDS console, click Databases (or Instances if you are using an older version).

2. In the Databases section on the right, click the DB identifier of the Amazon Aurora MySQL instance. For example, database-1-instance-1 in the image below.

   

3. Click the Connectivity & security tab, and copy the values under Endpoint and Port. Use these values as the database host and database port respectively while configuring your Amazon Aurora MySQL Destination.

   

---

Whitelist Hevo’s IP Addresses

You need to whitelist the Hevo IP address(es) for your region to enable Hevo to connect to your Amazon Aurora MySQL database.

To do this:

1. Open the Amazon RDS console.

2. In the left navigation pane, click Databases (or Instances if you’re using an older version).

3. In the Databases section on the right, click the DB identifier of the Aurora MySQL instance to configure its security group. For example, database-1-instance-1 in the image below.

   

4. In the Connectivity & security tab, click the link text under Security, VPC security groups.

   

5. In the Actions drop-down at the top, select Edit inbound rules.

   

6. In the Edit inbound rules page:

   

   1. Click Add rule.

   2. Add the Hevo IP address(es) for your region to grant Hevo access to the Amazon Aurora MySQL instance.

   3. Click Save rules.

---

Create a Database User and Grant Privileges

1. Create a database user

Perform the following steps to create a user in your Amazon Aurora MySQL database:

1. Log in to your Amazon Aurora MySQL database instance as a root user using an SQL client tool.

2. Enter the following command:

   CREATE USER '<user_name>'@'%' IDENTIFIED BY '<strong password>';
   

   Note: Replace the placeholder values in the command above with your own.

2. Grant privileges to the user

The following table lists the privileges that Hevo requires to connect to and load data into your Amazon Aurora MySQL Destination:

Privilege Name	Allows Hevo to
ALTER	Edit database tables.
CREATE	Create databases and tables.
CREATE TEMPORARY TABLES	Create temporary tables.
DELETE	Delete rows from database tables.
DROP	Delete databases and tables.
INSERT	Insert rows into database tables.
SELECT	Select rows from database tables.
UPDATE	Update rows in database tables.

Perform the following steps to grant the required privileges to the user:

1. Log in to your Amazon Aurora MySQL database instance as a root user using an SQL client tool.

2. Enter the following command:

   GRANT ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, INSERT, SELECT, UPDATE ON *.* TO '<user_name>'@'%';
   

   Note: Replace the placeholder values in the command above with your own.

---