CODEWITHSUNDEEP
javaamazon-web-servicesamazon-redshift
Glory
Glory

Reputation: 9

Check redshift cluster status programmatically

Is there any way to ping redshift cluster and get its status. in JAVA, if it is "available" or not. I have to ping a cluster during downtime and check if it is available or not.

Upvotes: 0

Views: 1103

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269550

This depends on how you define "available".

The DescribeClusters() API call returns a ClusterStatus that provides the cluster status from the AWS viewpoint.

Or, you could connect to the Redshift cluster with an SQL client and see whether it accepts the connection. That would be checking the status from whether Redshift itself is responsive.

If the 'downtime' you report also affects the ClusterStatus, then the API call would be the easier method.

Upvotes: 1

Related Questions