Support Documents
×

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.

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

  2.  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.

  3. The exported data can be analyzed by other 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.

Architecture Diagram

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.

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.



Join Whizlabs_Hands-On to Read the Rest of this Lab..and More!

Step 1 : Login to My-Account
Step 2 : Click on "Access Now" to view the course you have purchased
Step 3 : You will be taken to our Learn Management Solution (LMS) to access your Labs,Quiz and Video courses