9.0: Prerequisites

This lab requires the following lab modules to be completed first:

For this portion of the lab, you need to create the VPC, networking and Amazon Cloud9 resources in a 2nd AWS region. If you are running these labs as part of a formal workshop using Event Engine, we will use us-east-1 (N. Virginia) region for the setup, due to some security policy restrictions in place for the other regions. If you are running this lab in your own AWS account, you can choose any region where Aurora Global database is supported.

Link Description
Launch Stack Use this link to provision networking resources in the secondary AWS region for Aurora Global Database

CloudFormation Stack Setup Instructions

  1. Click the Launch Stack button above.

  2. Ensure the correct AWS region is selected in the top right corner.

Before proceeding switch your region to us-east-1 if you are running this lab as part of a formal workshop using Event Engine

  1. Make sure CreateInstance parameter is set to false to disable Aurora PostgreSQL cluster creation and isSecondary parameter is set to “Yes”. Leave rest of the parameters at their default value.
quick-create
  1. Scroll to the bottom, check both boxes and click Create stack.
Create Stack

Note that we are not creating another Amazon Aurora PostgreSQL cluster but just the networking resources and Cloud9 to support the secondary region for our Aurora PostgreSQL Global Database.

It should take 10 minutes for all the stack creation to be complete. Once complete, click on the stack name with description “Amazon Aurora PostgreSQL Labs Stackset”. Click on the Outputs tab on the right and click on the Cloud9URL https address in “Value” column.

Console
Console

In the Cloud9 IDE, use Cloud9’s Window menu and select New Terminal.

Console

Then, in the new terminal, paste and run the below commands to install PostgreSQL client and some other utilities:

# Install required tools for PostgreSQL
sudo yum install -y jq
sudo yum install -y postgresql96-contrib postgresql96 sysbench