reference deployment

Modular Architecture for Amazon Aurora PostgreSQL

A PostgreSQL database with high availability and failover support

This Partner Solution 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 Partner Solution is for users who are looking for a repeatable, customizable reference deployment for Aurora PostgreSQL. You can also use the Partner Solution as a building block to set up your own automated deployments. The Partner Solution 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 Partner Solution was developed by AWS.


AWS Service Catalog administrators can add this architecture to their own catalog.  

  •  What you'll build
  • Use this Partner Solution 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 Partner Solution 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 Partner Solution 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 Partner Solution, selecting from AWS Regions that support Aurora with PostgreSQL compatibility.
    2. Launch the Partner Solution, 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.

    Amazon may share user-deployment information with the AWS Partner that collaborated with AWS on this solution.  

  •  Costs and licenses
  • You are responsible for the cost of the AWS services and any third-party licenses used while running this Partner Solution reference deployment. There is no additional cost for using this Partner Solution.

    The AWS CloudFormation templates for this Partner Solution include configuration parameters that you can customize. Some of the settings, such as instance type, affect the cost of deployment. For cost estimates, see the pricing pages for each AWS service you use. Prices are subject to change.

    Tip: After you deploy the Partner Solution, create AWS Cost and Usage Reports to deliver billing metrics to an S3 bucket in your account. These reports provide cost estimates based on usage throughout each month and aggregate the data at the end of the month. For more information, refer to  What are AWS Cost and Usage Reports?