Amazon RDS Multi-AZ deployment with two readable standbys now supports snapshot export to S3

Posted on: Jun 27, 2024

Amazon Relational Database Service (Amazon RDS) Multi-AZ deployments with two readable standbys now supports export of snapshot data to an Amazon S3 bucket. Amazon RDS Multi-AZ deployments with two readable standbys is ideal when your workloads require lower write latency and more read capacity. In addition, this deployment option supports minor version upgrades and system maintenance updates with typically less than one second of downtime when using Amazon RDS Proxy or open source tools such as AWS Advanced JDBC Driver, PgBouncer, or ProxySQL.

You can now export Amazon RDS Multi-AZ deployments with two readable standbys snapshot data to an Amazon S3 bucket. The export process runs in the background and doesn't affect the performance of your cluster. When you export a DB snapshot, Amazon RDS extracts data from the snapshot and stores it in an Amazon S3 bucket. The data is stored in an Apache Parquet format that is compressed and consistent. After the data is exported, you can analyze the exported data directly through tools like Amazon Athena or Amazon Redshift Spectrum.

See the Amazon RDS User Guide for a full list of supported Regions and engine versions.

Learn more about Amazon RDS Multi-AZ deployments in the AWS News Blog. Create or update fully managed Amazon RDS Multi-AZ databases with two readable standby instances in the Amazon RDS Management Console.