Overview

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Amazon Aurora is one of the hosted database engines available within the Amazon Relational Database Service (RDS) offering.

This article provides the step by step instructions on how to deploy ScaleArc for AWS Aurora instances.

Information

Deploying ScaleArc for AWS Aurora databases is a three-step process as outlined below:

1. Deploy RDS Instance
2. Installing ScaleArc
3. Adding Amazon Aurora Instances to ScaleArc

Deploy RDS Instance

Follow the steps below to provision and deploy an Aurora AWS RDS instance.

Note that access to an AWS account with full user permissions for EC2 and RDS is required before proceeding with these steps:

1. Log into AWS IAM portal: https://signin.aws.amazon.com
   • Click - RDS

2. Before provisioning the Aurora instance, ScaleArc requires parameters for max_connect_errors to be set to 999999 and max_connections to be set to 10000 as a requirement to create the Aurora cluster later.  Configure these parameters by clicking on Parameter Groups.

3. Click on Create Parameter Group

4. Provide the Parameter Group Family and Group Name and click Create. In this case, we are using Aurora 5.6.

5. Select the new parameter group and Click on Edit Parameters

6. Add the following values for max_connect_errors and max_connections and click on Save Changes

7. Navigate to RDS Dashboard and click on Launch an Aurora DB Instance

8. Specify DB Details - This is where you can decide what size VM instance to deploy, multi-AZ (Availability zone) launch for a replica, and configure the logical cluster name and the master user.
   • For testing purposes, the below settings are sufficient. Enter and click on Next Step.

9. Configure Advanced Settings - This is where you can specify the network and security settings.  For DB parameter setting, choose the parameter group created above. 
   • For testing purposes, the below VPC and security groups are sufficient --> Launch DB Instance

10. Navigate the RDS console by following these steps: 
    • Click RDS master instance
    • Instance Actions
    • Create Aurora Replica

Each database endpoint has its own DNS name.  The instance with the Writer role is the instance that is accessed from the Aurora cluster endpoint. 

Installing ScaleArc

Install ScaleArc on AWS using either the AMI (Amazon Machine Image) or from the AWS marketplace public image as described in Installing ScaleArc on AWS. Proceed to the next step if you are adding Aurora instances to an existing ScaleArc instance.

Adding Amazon Aurora Instances to ScaleArc

Finally, you can now add Amazon Aurora instances to ScaleArc by following the steps described in Adding Amazon Aurora Instances.