Amazon RDS Multi-Availability Zone backups - AWS Backup

Amazon RDS Multi-Availability Zone backups

AWS Backup backs up and supports Amazon RDS for MySQL and for PostgreSQL Multi-AZ (Availability Zone) deployment options with one primary and two readable standby database instances.

Multi-Availability Zone backups are available in the following regions: Asia Pacific (Sydney) Region, Asia Pacific (Tokyo) Region, Europe (Ireland) Region, US East (Ohio) Region, US West (Oregon) Region, Europe (Stockholm) Region, Asia Pacific (Singapore) Region, US East (N. Virginia) Region, and Europe (Frankfurt) Region.

The Multi-AZ deployment option optimizes write transactions and is ideal when your workloads require additional read capacity, lower write transaction latency, more resilience from network jitter (which impacts the consistency of write transaction latency), and high availability and durability.

To create a Multi-AZ cluster, you can choose either MySQL or PostgreSQL as the engine type.

In the AWS Backup console, there are three deployment options:

  • Multi-AZ DB cluster: Creates a DB cluster with a primary DB instances and two readable standby DB instances, which each DB instance in a different Availability Zone. Provides high availability, data redundancy, and increases capacity to server-ready workloads.

  • Multi-AZ DB instance: Creates a primary DB instance and a standby DB instance in a different Availability Zone. This provides high availability and data redundancy, but the standby DB instance doesn’t support connections for read workloads.

  • Single DB instance: Creates a single DB instance with no standby DB instances.

To create a backup for Amazon RDS, see Creating a backup for scheduling a backup as part of your backup plans or creating an on-demand backup.

Note

Point-in-Time Recovery (PITR) can support instances, but not clusters.

Copying a Multi-AZ DB cluster snapshot is not supported.

Differences between a multi-AZ cluster and an RDS instance

A backup in a single Availability Zone or in two Availability Zones is an RDS instance; a deployment and backup with three or more instances is a cluster, similar to Amazon Aurora, Amazon Neptune, and Amazon DocumentDB clusters.

The ARN (Amazon Resource Name) is rendered differently depending on if instance or cluster is used:

An RDS instance ARN: arn:aws:rds:region: account:db:name

An RDS Multi-Availability Cluster: arn:aws:rds:region:account :cluster:name

For more information, consult Multi-AZ DB cluster deployments in the Amazon RDS User Guide.

For more information on Creating a Multi-AZ DB cluster snapshot, see the Amazon RDS User Guide.