Fast cross-region disaster recovery and low-latency global reads

with Amazon Aurora Global Database

In this tutorial, you will learn how to create an Amazon Aurora Global Database deployment that spans multiple AWS Regions and replicates your data with little to no impact on performance. Aurora Global Database provides disaster recovery from Region-wide outages and enables low-latency global reads.

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

An Aurora Global Database consists of a primary AWS Region —where your data is mastered— and multiple read-only secondary AWS Regions where the data is replicated. Your writes go to the primary database, but you can read from any Region and benefit from low latency.

This tutorial will use Amazon Aurora with MySQL compatibility for illustration. However, the concepts and steps are the same for Aurora with PostgreSQL compatibility. The tutorial is not within the free tier, but it will cost you less than $2 provided you follow the steps in the tutorial and terminate your resources at the end of the tutorial.

Prerequisites

An Amazon Aurora DB cluster consists of one or more DB instances and a cluster volume that manages the data for those DB instances. An Aurora cluster volume is a virtual database storage volume that spans multiple Availability Zones, with each Availability Zone having two copies of the DB cluster data. Two types of DB instances make up an Aurora DB cluster: a Primary DB instance, which supports read and write operations, and an Aurora Replica, which connects to the same storage volume as the primary DB instance and supports read only operations. Each Aurora DB cluster can have up to 15 Aurora Replicas located across the three Availability Zones. Aurora automatically fails over to an Aurora Replica in case the primary DB instance becomes unavailable.

In this tutorial, you will create an Aurora Global Database with a primary cluster in one Region and a secondary cluster in a different Region. Which Regions to use is up to you. In an Aurora Global Database, you will deploy your application to read and write from a primary cluster and configure applications to use secondary clusters for low latency reads or disaster recovery purposes. For example, if your Aurora Global Database will have a primary cluster in US East (N. Virginia) and a secondary cluster in Europe (Paris), you could have an Application instance in US East (N. Virginia) and another one for reads in Europe (Paris).

Also, if you want to save time, for each of those Regions you can create a Security Group allowing incoming connections from your instances. For example, you can create a security group with an inbound rule allowing TCP connections on port 3306 (for MySQL) or 5432 (for PostgreSQL) from the security group of your instances.

Finally, in order to test your Aurora Global Database (see Step 7), you will need a MySQL or PostgreSQL client. If your application instances are running on Amazon Linux, installing a MySQL client can be as simple as running sudo yum install mysql (for MySQL) or sudo amazon-linux-extras install postgresql10 vim epel and sudo yum install -y postgresql-server postgresql-devel (for PosgreSQL) , but the exact command depends on the OS you are running. If you are running Windows, you can download MySQL workbench or pgAdmin instead.

About this Tutorial
Time 10 minutes                                           
Cost Less than $1
Use Case Databases
Products Amazon Aurora, Amazon RDS
Audience Database administrators, Developers
Level Intermediate
Last Updated July 8, 2020

Step 1: Accessing the Amazon RDS console

1.1 — Open a browser and navigate to Amazon RDS console. If you already have an AWS account, login to the console. Otherwise, create a new AWS account to get started.

1.2 — On the top right corner, select the region where you want to launch the primary Aurora DB cluster. For the purposes of this tutorial, we will use US East (N. Virginia) as the primary region and Europe (Paris) as the secondary region.

Already have an account? Log in to your account

1.3 — Click on “Create database” in the Amazon Aurora window.

Step 2: Engine options

2.1 — On Choose a database creation method, select Standard Create.

2.2 — On Engine type, select “Amazon Aurora”.

2.3 — On Edition, select “Amazon Aurora with MySQL compatibility” or PostgreSQL compatibility based on your interest.

2.4 — On Version, select the most recent MySQL or PostgreSQL version supported by Aurora Global Database.

For Aurora Global Database availability for specific MySQL or PostgreSQL versions or Region, see working with Amazon Aurora Global Database.

2.5 — On Templates, choose Dev/Test.

Step 3: Primary region settings

3.1 — For the Global database identifier, type “global-database-1”.

3.2 — For the Credentials Settings, leave the master username as-is. Type a master password and keep a note of it. We suggest entering a password that you can remember for later use.

3.3 — For the DB instance size, select a large instance (ending with r5.large, or a similar instance size from a newer generation if available).

3.4 — For Availability & durability, choose “Don't create an Aurora Replica”.

Note that having an Aurora Replica is recommended for production environments, as it allows you to scale reads and it gives you automatic failovers within the same Region as your primary database. In this tutorial we are not adding an Aurora Replica just to keep the exercise simple.

 

Step 4: Connectivity

4.1 — Select VPC where you want to create the database. We will use the default VPC created for each Region in your account.

Note that once created, a database can't be migrated to a different VPC.

4.2 — Click on “Additional connectivity configuration”.

4.3 — Select the default value for Subnet group.

4.4 — On Publicly accessible, select “No”.

This means you will have to connect to the database from an EC2 instance within the same VPC.

4.5 — On VPC security group, select “Create new”. If you happen to have a security group that allows incoming TCP connections on port 3306 for MySQL or 5432 for PostgreSQL, you can choose it instead.

4.6 — In New VPC security group name, type “global-database-sg”.

4.7 — Leave the default value for Database port.

Step 5: Additional configuration

5.1 — Choose Password Authentication for Database Authentication options.

5.2 — Under Additional configuration section, leave the default values for Database options, Encryption, Backup, Monitoring, Log exports, Maintenance except the Deletion Protection. For Deletion protection, uncheck the Enable deletion protection option as you may want to terminate the instance at the end of the tutorial.

5.3 — Click on “Create database”. It will take a few minutes to create.

Step 6: Add a secondary region

The process of creating an Aurora Global Database is quite simple. Now, that you have a primary cluster, you just need to add a cluster in a secondary Region, and then it becomes an Aurora Global Database with two Regions. Your existing DB cluster will become the primary DB cluster in the new Aurora Global Database.  

6.1 — Go to RDS Console in US East (N.Virginia). Select “global-database-1”.

6.2 — Click on “Actions > Add a Region”. When you add a Region to the cluster, this becomes a primary cluster in an Aurora Global Database.

6.3 — Type Global database identifier as “global-database”

6.4 — Choose the Secondary Region as EU (Paris)

6.4 — repeat steps 3.3 to 5.3 for the secondary Region.

The creation process will take about ~20 minutes. Once the secondary cluster becomes available, proceed to Step 7.

Note: If you see error such as “The specified KMS key [arn:aws:kms:<AWS Region>:<AWS Account>:key/alias/aws/rds] does not exist, etc, Please retry the Step 6. This error happens when you create a secondary cluster first time in that AWS Region.

Step 7: Test your Aurora Global Database

7.1 — Make sure you are in US East (N. Virginia) Region. Click on your primary cluster “global-database-1”.

7.2 — Copy the Writer endpoint.

Open two terminal windows, log into your EC2 instances in the primary and secondary Regions, and use the mysql or PostgreSQL command line client to connect to the databases.

You can now create a database, create a table and write some records. Everything you write to the primary region will be replicated to the secondary region.

7.3 — Connect to your primary aurora cluster in US East (N. Virginia):

For MySQL:

$ mysql -h <Primary Cluster Writer Endpoint> -P 3306 -u admin -p

When prompted for a password, enter the password you saved in the step 3.2.

7.4 — Create a database

mysql> CREATE database tutorial;
Query OK, 1 row affected (0.01 sec)

At this point, you can use the tutorial database, create tables and add some records.
use tutorial;

7.5 — Create a test table and write some data. For example:

create table employee (emp_no bigint, name varchar(50));
insert into employee values (1, 'John');
insert into employee values (2, 'Sam');
commit;
select * from employee;

For PostgreSQL:

$ psql -h <Primary Cluster Writer Endpoint> -d postgres -p 5432 -U admin

When prompted for a password, enter password you saved in the step 3.2.

Repeat the SQL commands from step 7.5.

7.6 — Go to the secondary region Europe (Paris).

7.7 — Click on your secondary cluster.

7.8 — Copy the Reader endpoint.

7.9 — Connect to your secondary cluster in Europe (Paris):

For MySQL:

$ mysql -h <Secondary Reader Endpoint> -P 3306 -u admin -p

When prompted for a password, enter password you saved in the step 3.2.

7.10 — Read some data:

For MySQL:

mysql> USE tutorial;
mysql> select * from employee;

For PostgreSQL:

$ psql -h <Secondary Reader Endpoint> -d postgres -p 5432 -U admin
postgres=> select * from employee;

Now you can verify that the primary database has been replicated to the secondary database.

Step 8: Failover to a secondary region

While a default Aurora cluster gives you failover capabilities within the Region, Aurora Global Database allows you to failover to a secondary cluster in a different Region. It means your database will survive even in the unlikely event of a regional degradation or outage.

Performing a failover for an Aurora Global Database involves detaching the secondary cluster from the original global database and promoting as a stand-alone Regional cluster with full read-write capabilities.

You can manually perform a failover by following the instructions below.

8.1 — Stop writing to the primary cluster.

8.2 — Make sure you are in Europe (Paris) Region. Select the secondary cluster.

8.3 — Click on “Actions > Remove from Global”.

8.4 — Confirm by clicking on “Remove and promote”.

8.5 — Configure your applications to write to the newly promoted cluster using the Cluster Endpoint.

Note: After failover, the newly promoted cluster in Europe (Paris) Region becomes a Regional aurora cluster. Once promoted you cannot add the new DB cluster back to the old Aurora Global Database as a secondary region. If you want to fail back to original region US-East (N. Virginia) or add a secondary cluster in different AWS Region, you need to repeat the steps 6 to 8 by creating a new Aurora Global Database with the newly promoted cluster as the primary cluster. See Failover for Aurora Global Database.

Step 9: Cleanup

To finish this tutorial, you will need to delete your Aurora Global Database. You can keep it around, but be aware that you will incur charges.

In order to delete your Aurora Global Database, go to the RDS Dashboard and follow these instructions in each Region:

9.1 — Select “Databases” on the left pane in US East (N. Virginia) Region.

This will show you a list of all your Aurora DB clusters.

9.2 — Select a global database instance.

 

9.3 — Before deleting an instance, you need to remove it from Global. Click on “Actions > Remove from Global”.

9.4 — Confirm by clicking on “Remove from global”.

9.5 — Click on “Actions > Delete”.

Note – You cannot delete the instance if the Enable deletion protection option is checked. You need to modify the cluster and disable this setting before deleting.

9.6 — You will be asked if you want to create a final snapshot. That's usually a good idea for real data, but it's not necessary for this tutorial. Choose the option “I acknowledge.” and Confirm by typing, “delete me” and click “Delete”.

The status of your cluster will change to “Deleting”.

9.7 — Repeat the above steps to remove the Aurora Cluster in in Europe (Paris) Region as well.

Congratulations

You have created an Aurora Global Database with replication across regions. You have learned how to scale reads to other regions in order to benefit from lower latency, and you have performed a failover to a secondary region.

Was this tutorial helpful?

Thank you
Please let us know what you liked.
Sorry to disappoint you
Is something out-of-date, confusing or inaccurate? Please help us improve this tutorial by providing feedback.