AWS, Cloud Computing

3 Mins Read

Manage Data Protection of Amazon Redshift Data Warehouse using AWS Backup

Overview

AWS Backup is a fully managed backup service that automates and centralizes data backup across AWS services. It allows us to configure backup policies and monitor the activity of AWS resources in one place. You can eliminate the need to write unique scripts and manual procedures by automating and combining backup tasks that were previously completed service by service.

Earlier, AWS backup is supported by Amazon S3, Amazon DynamoDB, Amazon FSx file systems, Amazon EC2, Amazon EFS, Amazon EBS, Amazon RDS and Aurora, AWS Storage Gateway, Amazon DocumentDB, Amazon Neptune, AWS CloudFormation, VMware CloudTM on AWS and on-premises VMware virtual machines and AWS BackInt.

Introduction

Amazon has announced that AWS Backup now also supports Amazon Redshift. It will help us to protect data warehouses with immutable backups, separate access policies, and centralized organizational governance of backup and restore jobs. It can be done using AWS Backup console or CLI or by using API. The Redshift Clusters can be backed up based on schedule or they can be backed up as needed via on-demand backup.

You can restore the tables or entire clusters using AWS CLI or AWS Backup Console. The original cluster settings are automatically entered into the console when you restore an Amazon Redshift cluster. Additional settings must be added based on requirements. The source and target databases must be specified when restoring a table.

  • Cloud Migration
  • Devops
  • AIML & IoT
Know More

Steps to create and restore AWS Backup on-demand

Step 1: Sign in to AWS Management Console. In Search Bar, enter Backup, and from the search results choose AWS Backup.

Step1

Step 2: Navigate to the left side of the pane and then Choose Protected resources. Next, click on Create on-demand backup.

Step2

Step 3: On the Create on-demand backup page,

  • Choose the resource type as Redshift.
  • Under Cluster identifier, choose the name or ID of the resource that you want to protect.
  • In the Backup window, choose to Create backup now which will start creating a backup of the resources immediately. If you want, you can also customize the backup window.
  • Choose a retention period as per your requirements.
  • For the Backup vault, Choose Default. Otherwise, you can create a new backup vault.

Step3

  • Under the IAM role, choose the Default role or a role of your choice.
  • Next, click on Create on-demand backup

Step3b

Step 4: In the Protected resources section, you can see details about the cluster snapshots.

Step4

Step 5: Restore Amazon Redshift Cluster.

  • In the Recovery Points pane, choose the recovery point ID and Click on Restore.
  • Under Restore options, choose Restore Cluster from Snapshot.
  • Specify your new cluster configuration settings. However, it will take default values from the existing cluster. You can change it by providing the Cluster identifier, Node type, and Number of nodes.
  • You can associate additional roles by clicking Associate IAM roles.
  • Next, click on Restore backup.
  • Navigate to the left side of the pane and select Jobs.
  • On the Jobs page, under the Restore Jobs pane, you can see the job created for restoring of Amazon Redshift Cluster.

Step5

Conclusion

AWS announces support for Amazon Redshift in AWS Backup, which makes it easier to centrally manage the data protection of your Amazon Redshift data warehouse. AWS Backup allows us to schedule and restore Redshift manual snapshots. Using this feature, you can automate the creation of Amazon Redshift backups and store them in an encrypted backup vault. It allows us to restore a table to an existing cluster or a cluster to a new cluster which simplifies data recovery.

Get your new hires billable within 1-60 days. Experience our Capability Development Framework today.

  • Cloud Training
  • Customized Training
  • Experiential Learning
Read More

About CloudThat

CloudThat is also the official AWS (Amazon Web Services) Advanced Consulting Partner and Training partner and Microsoft gold partner, helping people develop knowledge of the cloud and help their businesses aim for higher goals using best in industry cloud computing practices and expertise. We are on a mission to build a robust cloud computing ecosystem by disseminating knowledge on technological intricacies within the cloud space. Our blogs, webinars, case studies, and white papers enable all the stakeholders in the cloud computing sphere.

Drop a query if you have any questions regarding Amazon Redshift backups and I will get back to you quickly.

To get started, go through our Consultancy page and Managed Services Package that is CloudThat’s offerings.

FAQs

1. What is a backup vault?

ANS: – A backup vault is an encrypted repository in your AWS account that stores and organizes your backups (restore points). You can create a new backup repository in each AWS Region where an AWS backup is available which enables delete protection on backup vaults with AWS Backup Vault Lock to prevent malicious actors from re-encrypting your data.

2. How do I use access policies in a backup vault to control access to backups?

ANS: – AWS Backup can set resource-based policies for backup vaults, allowing you to control access to the backup vault and the backups in it.

3. Can I use AWS Backup to back up on-premises data?

ANS: – Yes, you can use AWS Backup can back up on-premises Storage Gateway volumes and VMware virtual machines, providing a common way to manage the backups of your application data both on-premises and on AWS.

WRITTEN BY Anusha

Anusha works as Research Associate at CloudThat. She is an enthusiastic person about learning new technologies and her interest is inclined towards AWS and DataScience.

Share

Comments

    Click to Comment

Get The Most Out Of Us

Our support doesn't end here. We have monthly newsletters, study guides, practice questions, and more to assist you in upgrading your cloud career. Subscribe to get them all!