Export Amazon RDS DB Snapshot to S3

Lab Details

  1. This lab walks you through the steps to export the RDS DB snapshot to S3.

  2. In this lab, you will practice creating an Amazon RDS DB Instance, Amazon S3 Bucket, AWS KMS Key.

  3. Duration: 1 hour 30 minutes

  4. AWS Region: US East (N. Virginia) us-east-1

Introduction

  1. All types of RDS Backups can be exported to S3 whether they are Automated Backups, Manual Backups or those created by AWS Backup service.

  2. Steps to export to s3:

    • We have to create an Amazon S3 Bucket with the required IAM permissions and create a KMS key for server-side encryption (SSE).

    • The Snapshot can be exported either via Console or CLI commands.

  3. The Export runs in the background. It does not affect any kind of database performance.

  4.  The data which is exported to S3 is always in the Apache Parquet format. Parquet format is 2 times faster to export and consumes up to 6 times less storage in Amazon S3 compared to test formats.

  5. The exported data can be analyzed by other AWS services like Amazon Sagemaker, Amazon EMR, and Amazon Athena.

Architecture Diagram

Use cases

  1. Disaster Recovery

  2. Data migration

  3. Perform queries on the exported snapshot using AWS services like Amazon Sagemaker, Amazon EMR, and Amazon Athena.

Task Details

  1. Log into AWS Management Console.

  2. Create an Amazon S3 Bucket.

  3. Create an AWS KMS Key.

  4. Create a Security group for RDS DB Instance.

  5. Create an Amazon RDS DB Instance.

  6. Take a snapshot from an existing DB Instance.

  7. Create a sample database and a table.

  8. Export the Snapshot to S3.

  9. Validation of the lab.

  10. Deleting AWS resources

Pre-requisites

  1. For testing this lab, it is necessary to download the MySql GUI Tool, To download it, go to the Download MySQL Workbench page. Based on your OS, select the respective option under Generally Available (GA) Releases. Download and Install.