reference deployment

Modular architecture for Amazon Aurora PostgreSQL

Deploy an Amazon Aurora PostgreSQL database on the AWS Cloud with high availability and failover support

This Quick Start automatically deploys a modular, highly available environment for Amazon Aurora PostgreSQL on the Amazon Web Services (AWS) Cloud.

Aurora is a fully managed relational database engine that’s compatible with MySQL and PostgreSQL. The code, tools, and applications you use today with your existing PostgreSQL databases can be used with Aurora. With some workloads, Aurora can deliver up to three times the throughput of PostgreSQL without requiring changes to most of your existing applications. Aurora is part of the Amazon Relational Database Service (Amazon RDS) and takes advantage of Amazon RDS features for database management and administration.  

This Quick Start is for users who are looking for a repeatable, customizable reference deployment for Aurora PostgreSQL. You can also use the Quick Start as a building block to set up your own automated deployments. The Quick Start includes an AWS CloudFormation template that builds only the Aurora database components. This template is designed to plug into your existing AWS CloudFormation templates as a drop-in PostgreSQL database replacement.

portworx logo

This Quick Start was developed by AWS solutions architects and database specialists.

  •  What you'll build
  •  How to deploy
  •  Cost and licenses
  •  What you'll build
  • Use this Quick Start to automatically set up the following Aurora environment on AWS:

    • A highly available virtual private cloud (VPC) architecture that spans two Availability Zones. The VPC is configured with public and private subnets according to AWS best practices, to provide you with your own virtual network on AWS.*
    • In the public subnets:
      • Managed network address translation (NAT) gateways to allow outbound internet access for resources in the private subnets.*
      • A Linux bastion host in an Auto Scaling group to allow inbound Secure Shell (SSH) access to Amazon Elastic Compute Cloud (Amazon EC2) instances in the private subnets.*
    • In the private subnets, an Aurora DB cluster that includes two DB readers and one DB writer.
    • An encryption key using AWS Key Management Service (AWS KMS). The Quick Start uses the key to enable encryption at rest for the Aurora DB cluster.
    • An Amazon CloudWatch alarm to monitor the CPU on the bastion host and send an Amazon Simple Notification Service (Amazon SNS) notification when the alarm is triggered.

    *  The template that deploys the Quick Start into an existing VPC skips the components marked by asterisks and prompts you for your existing VPC configuration.

  •  How to deploy
  • To deploy the Aurora PostgreSQL environment in your AWS account, follow the instructions in the deployment guide. The deployment process takes about 25 minutes and includes these steps:

    1. If you don't already have an AWS account, sign up at https://aws.amazon.com, and sign in to your account. Choose the AWS Region where you want to deploy the Quick Start, selecting from AWS Regions that support Aurora with PostgreSQL compatibility.
    2. Launch the Quick Start, choosing from the following options:
    3. Test the deployment and confirm that the PostgreSQL database is accepting connections.
     
    To customize your deployment, you can configure your VPC, bastion host, and database settings, and optionally set database tags.
  •  Cost and licenses
  • You are responsible for the cost of the AWS services used while running this Quick Start reference deployment. There is no additional cost for using the Quick Start.

    The AWS CloudFormation templates for this Quick Start include configuration parameters that you can customize. Some of these settings, such as database instance type, will affect the cost of deployment. For cost estimates, see the pricing pages for each AWS service you will be using. Prices are subject to change.

    Tip     After you deploy the Quick Start, we recommend that you enable the AWS Cost and Usage Report to track costs associated with the Quick Start. This report delivers billing metrics to an Amazon Simple Storage Service (Amazon S3) bucket in your account. It provides cost estimates based on usage throughout each month, and finalizes the data at the end of the month. For more information about the report, see the AWS documentation.