wesupport

Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

Snapshot Restore Progress in Amazon Redshift – How to Monitor?

by | Aug 9, 2021

Want to check Snapshot Restore Progress in Amazon Redshift? We can help you.

Recently, one of our customers was trying to restore a snapshot of his Amazon Redshift cluster.

However, he didn’t know how to check its progress.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how to monitor the progress of the snapshot restore.

 

Snapshot Restore Progress in Amazon Redshift

Generally, there are three snapshots restore options that Amazon Redshift supports.

  • Cluster restore

Restores all tables, databases, and metadata from the snapshot to an Amazon Redshift cluster of the same size and node configuration as the source cluster.

  • Cross-instance restore

Restores an Amazon Redshift snapshot to a cluster that is a different size or runs a different node type.

  • Table restore

Restores specific tables and associated metadata from the snapshot to the Amazon Redshift cluster.

 

How to Monitor?

Moving ahead, let us see how our Support Techs use the above to monitor snapshots.

 

Monitor a cluster restore or cross-instance restore

In either of these ways, we can monitor the progress of the cluster restore or cross-instance restore:

  • AWS Management Console

Initially, we go to the Amazon Redshift cluster details in the Amazon Redshift console.

When the cluster restore is in progress, its status is set to Modifying.

On the Clusters details page, we can select the Maintenance and monitoring tab.

This tab lists the events that confirm the creation of the Amazon Redshift cluster and the completion of any data transfers.

Once the restore operation completes, the cluster status is set to Available.

–Or–

  • AWS CLI

In this case, to track the progress,  we can use the DescribeClusters API.

It shows snapshot details such as the size, transfer rate, time elapsed, and estimated remaining time in the snapshot restore.

Then, we can check the RestoreStatus entry to see if the snapshot is restored.

To check the status of the snapshot restore, we run:

aws redshift describe-clusters --cluster-identifier <value>

 

Monitor a table restore

To monitor the progress of the table restore we can use either of these ways:

  • AWS Management Console

Once the table restore initiates, we can track the status of the request from the Amazon Redshift console.

On the Clusters page, the Backup tab lists any restore table requests. The Status tab shows the current state of the request.

–Or–

  • AWS CLI

Here, we can use the describe-table-restore-status command to list the status of one or more table restores requests made using the RestoreTableFromClusterSnapshot API.

If we don’t specify a value for the TableRestoreRequestId parameter, then the DescribeTableRestoreStatus API returns the status of all table restore requests.

The requests will list in ascending order by date and time.

To obtain the status of the table restore, we run:

aws redshift describe-table-restore-status --cluster-identifier <mycluster>
aws redshift describe-table-restore-status --table-restore-request-id <value>

[Need help with the monitoring? We are here to assist you]

 

Conclusion

In short, we saw how our Support Techs monitor the Snapshot Restore Progress in Amazon Redshift.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Categories

Tags