Home icon

How London Stock Exchange Group optimised blue/green deployments for Amazon Aurora PostgreSQL Global Database

Database Blog

This article discusses how the London Stock Exchange Group optimized their blue/green deployments for Amazon Aurora PostgreSQL Global Database.

Specifically, the article covers:

  • The solution overview for a blue/green deployment architecture using Aurora PostgreSQL Global Database
  • Prerequisites and required permissions for the process
  • Steps to configure the blue cluster parameter group for logical replication
  • Steps to create a publication on the blue cluster and configure the subscription from the green cluster
  • Verifying replication lag and converting the green cluster into a global database
  • Pre-cutover validation steps and altering sequences
  • Cutting over to the green cluster and post-cutover cleanup
  • Considerations around stopping write traffic, replication, primary keys, user credentials, schema changes, triggers, initial hydration, and validation
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Nov 14
2025
Introducing fully managed Blue/Green deployments for Amazon Aurora Global Database
Jun 26
2024
How London Stock Exchange Group migrated 30 PB of market data using AWS DataSync
Nov 14
2025
Amazon RDS Blue/Green deployments now supports Aurora Global Database
Aug 11
2025
How Wiz achieved near-zero downtime for Amazon Aurora PostgreSQL major version upgrades at scale using Aurora Blue/Green Deployments

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.