amazon-aurora-pgpool-example

amazon-aurora-pgpool-example copied to clipboard

Amazon Aurora Pgpool example

A set of CloudFormation templates that demonstrates using pgool middleware to provide a single endpoint for both the primary and read replica instances of an Amazon Aurora PostgreSQL-compatible cluster.

These CloudFormation (CFN) templates deploy an Aurora RDS PostgreSQL-compatible cluster with pgpool middleware. pgpool offers a single endpoint that directs traffic to the RDS cluster endpoint for writes and the RDS reader endpoint for reads.

The templates also set up a VPC with public and private subnets, security groups that limit communication, and an ELB to expose the pgpool instance externally.

License Summary

This sample code is made available under a modified MIT license. See the LICENSE file.

Setup

We assume that you have the AWS CLI installed and configured. Create an S3 bucket to contain the CFN templates. We'll refer to this as templatebucket.

In the scripts create.sh and update.sh, review and update the parameters. You must put in your own SSH key name in the keyname parameter, and we strongly encourage you to change the AllowedCidrIngress from the default of 0.0.0.0/0.

Create the CFN stack

Run:

./create.sh templatebucket pgpool pgpoolstack us-west-2

Use your AWS region of choice if you don't want to run in us-west-2.

Updating the stack

You can run the following to update the stack if you change the configuration:

./update.sh templatebucket pgpool pgpoolstack us-west-2

Using the stack

Look for the stack output parameter Endpoint. You can use Endpoint:5432 as your PostgreSQL-compatible connection host.