O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Cluster operation

From the topic of database maintenance, we will make a natural transition into the topic of cluster operation. The best practice to back up and restore your cluster is something you should try out and be comfortable with. It is always at the worst possible time that you will really need to have a restore working, so practice this before you need it. Also, remember that restores do not put the cluster into read-only. The cluster is available for use during the restore and will actually prioritize the streaming of the blocks needed to answer query questions. Understanding that is just as important as understanding the fact that a resize operation is a read-only operation, you will not be able to run any update queries. Read-only ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required