- \n
- We can export all types of backup from RDS to S3<\/span><\/li>\n
- Steps to export to s3:<\/span>\n
- \n
- Create an S3 bucket with Proper IAM Permission<\/span><\/li>\n
- Create a KMS key for server-side encryption (SSE)<\/span><\/li>\n
- We can use CLI or GUI to perform this action<\/span><\/li>\n<\/ul>\n<\/li>\n
- No Impact on Performance as export runs in the background<\/span><\/li>\n
- \u00a0Data will be exported into S3 in Apache Parquet format. It is 2x faster and stores 1\/6 of the storage compared to the normal test format<\/span><\/li>\n
- We can use that exported data to create reports using Athena and EMR<\/span><\/li>\n<\/ol>\n
<\/p>\n
Architecture of Migration Process<\/b><\/h2>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Architecture-1024x684.png\")
<\/p>\nUsed Tools and AWS Components –<\/b><\/h3>\n
- \n
- AWS RDS<\/span><\/li>\n
- AWS S3<\/span><\/li>\n
- AWS KMS<\/span><\/li>\n
- AWS IAM<\/span><\/li>\n
- AWS Glue<\/span><\/li>\n
- AWS Crawler<\/span><\/li>\n
- AWS Athena<\/span><\/li>\n<\/ul>\n
Steps Performed for this Activity<\/b><\/h3>\n
- \n
- Create an S3 bucket in AWS\u00a0<\/span><\/li>\n
- Create a KMS Key or use the Existing Key for Encryption<\/span><\/li>\n
- Take RDS Database Snapshot<\/span><\/li>\n
- Export Snapshot to S3 Bucket with Parquet Format<\/span><\/li>\n
- Validate the Snapshot Migration (Check Size and Cost)<\/span><\/li>\n
- Create a Glue Crawler and Run it to fetch data<\/span><\/li>\n
- Use Athena to Execute Query and generate Report\u00a0 – Data Will be stored in CSV format in the S3 bucket location<\/span><\/li>\n
- You can also use those output files to import data into another database.<\/span><\/li>\n<\/ol>\n
\u00a0<\/span><\/p>\n
Execution Steps –\u00a0<\/b><\/h3>\n
- \n
- This process has been performed on the Beta Database of PostgreSQL Snapshot.<\/span><\/li>\n<\/ul>\n
Step 1: Export of RDS DB Snapshot to S3 Bucket<\/b><\/h3>\n
- \n
- Take a Snapshot of the Beta Database from RDS<\/span>
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/RDS_Snapshot_Migration.jpg\")
<\/li>\n- Export Database Snapshot to S3 bucket from Snapshot Menu<\/span>
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/S3_Bucket_export.jpg\")
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Snapshot_exported_history.jpg\")
<\/li>\n- Created KMS key as \u201cglue-kms\u201d in Key Management Service with default settings and copied the arn of the key created to export db snapshot configuration, and Crawler will use same to extract data by AWS Glue.<\/span>
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/KMS_KEY.jpg\")
<\/li>\n- Select S3 Bucket to upload and provide a proper IAM Role with a Newly created KMS Key to encrypt the database snapshot.<\/span><\/li>\n
- Snapshot has been exported in the S3 bucket and checked directly from the S3 Console.<\/span>
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Bucket_data.jpg\")
<\/li>\n- After completion of the export task to the S3 bucket, I am able to see the databases and tables in the bucket named test-beta.<\/span><\/li>\n<\/ul>\n
Step 2: Create and Run Crawler in AWS Glue to export S3 data in Glue Data Catalog<\/b><\/h3>\n
- \n
- In AWS Glue Console, Go to the crawler option and click on the add crawler button. Then, give the crawler name as beta-demo and click next<\/span><\/li>\n
- Click on Next and select a data source\u00a0<\/span><\/li>\n
- Select the S3 folder and provide the path that you want to extract and get data from a particular table or full database.<\/span><\/li>\n
- Here, we have selected a specific table customer_master to check.<\/span><\/li>\n
- Select the IAM role which AWS Glue and Crawler will use to access Snapshot from S3 Bucket<\/span>
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/IAM_for_crawler.jpg\")
<\/li>\n<\/ul>\nCreate Database<\/strong><\/h2>\n
1. Review the Created Crawler<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Create_crawler.jpg\")
<\/p>\n2. Select Data Source for Crawler<\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Create_crawler__data_source.jpg\")
<\/p>\n3. Create a schedule for Crawler<\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Crawler_schedule.jpg\")
<\/p>\n4. Run The Crawler and see the process<\/span><\/p>\n
<\/p>\n5. Check the Database in AWS Glue, and you will find the table that the crawler extracted from the S3 Bucket<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Crawler_database.jpg\")
<\/p>\nStep 3: In Athena, run of queries and store of queries output in S3 bucket<\/b><\/h3>\n
1. Check Query Editor<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Athena_dashboard.jpg\")
<\/p>\n2. In Query Editor, You will find the Data Source as AWS Data Catalog, and demodb will be there as a database because it is the only database available right now.<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Athena_query_run.jpg\")
<\/p>\n3. Go to Settings and specify the location to store output, which you will get after the execution of queries in Athena , we have provided the Same S3 bucket with a New Folder in it.<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/Athena_query_output_dest.jpg\")
<\/p>\n4. Execute the query and see the result.<\/span><\/p>\n
5. Check the Output in the Query editor and the S3 bucket, where it will be saved in CSV format.<\/span><\/p>\n
![\"\"](\"\/blog\/wp-ttn-blog\/uploads\/2023\/10\/athena_output_store.jpg\")
<\/p>\nYou can now download the CSV file open it, and check the result to verify.<\/span><\/p>\n
Notes:-\u00a0<\/span><\/p>\n
- \n
- A crawler will be used if the requirement comes to get a report or data from any historical snapshot<\/span><\/li>\n
- Costing of the crawler will be based on the minutes of usage<\/span><\/li>\n
- Costing of Athena will be based on the data explored from snapshot<\/span><\/li>\n<\/ul>\n
Costing Summary<\/b><\/h2>\n
- Costing of the crawler will be based on the minutes of usage<\/span><\/li>\n
- Click on Next and select a data source\u00a0<\/span><\/li>\n
- Export Database Snapshot to S3 bucket from Snapshot Menu<\/span>
- Take a Snapshot of the Beta Database from RDS<\/span>
- Create a KMS Key or use the Existing Key for Encryption<\/span><\/li>\n
- AWS S3<\/span><\/li>\n
- Create a KMS key for server-side encryption (SSE)<\/span><\/li>\n
- Steps to export to s3:<\/span>\n