rds wait db-cluster-available

[tomfotherby]

AWS allows to create a copy-on-write clone of an existing Aurora cluster (docs). When this is done it takes a few minutes before the cluster is available. It would be great if there was a extra rds wait command added to the current list that works for "clusters" . Example usage:

rds wait db-cluster-available --db-cluster-identifier <cluster-id>

This would make scripting things easier. Currently I have a poor workaround:

status=unknown
while [[ "$status" != "available" ]]; do
  sleep 10
  status=$(aws rds describe-db-clusters --db-cluster-identifier $CLUSTERNAME --query 'DBClusters[0].Status' --output text)
done

[dstufft]

Marking this as an enhancement request, thanks!

[nhmaha]

+1

[jrichard0725]

+1

[TBragg]

+1

[derdeka]

+1

[tbastos]

+1

[rfreuler]

+1

[stashev]

It would be nice to have all wait command applied to rds Aurora clusters as well, including snapshots

[josephcarmello]

+1

[peterborghard]

+1

[IllyaYalovyy]

+1

[sebuala]

More than 1 year since the request and the AWS team couldn't make the enhancement.

[chandravadans]

+1

[shaileshubhe77]

Correct command is :

status=unknown
while [ "$status" != "available" ]; do
sleep 10
status=$(aws rds describe-db-clusters --db-cluster-identifier $CLUSTERNAME | jq -r '.DBClusters[0].Status' output text)
done

[bpatton00]

+1

[jimbocoder]

+infinity

[robbhudl]

+1

[muriloxk]

+1

[reizist]

+1

[bbuchalter]

[carojasq]

+1

[KapitalEarth]

I'll pause uploads, then. Have a good day. Regards, R.

…

Sent from my iPhone

On 18 Aug 2020, at 5:28 AM, Cristian Alejandro Rojas ***@***.***> wrote:  +1 — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[farman022]

+1

[iobites]

+1

[paul-m]

Very Plus One. +1

[rubengomex]

+1

[anthonyruok]

+1 p-p-p-p-please

[nchillal]

+1

[nic-hima]

This would be a huge enhancement!

[tim-finnigan]

Hi everyone, thanks for your patience regarding this feature request. There is clearly a lot of demand to add this. I raised this internally with the RDS team and currently waiting on a response. In the meantime, I’ll go ahead and transfer this to our shared SDK repository as it is a cross-SDK request.

[tim-finnigan]

P54131834

[tim-finnigan]

I received an update from the RDS team that they have added this feature request to their backlog. We can’t provide a specific timeline for when this would be implemented but it is something they will try to prioritize.

[TomGudman]

Bash code, as an interim solution

CLUSTER_NAME="XXX"
while true
do
  sleep 5
  STATUS=$(aws rds describe-db-clusters --db-cluster-identifier $CLUSTER_NAME --query 'DBClusters[0].Status' --output text)
  if [[ $STATUS == 'available' ]]; then
    break
  fi                                                                                                                                                                                                                                           
done
echo 'Ready!'

One-liner for convenience

CLUSTER_NAME="XXX"; while true; do sleep 5 ; STATUS=$(aws rds describe-db-clusters --db-cluster-identifier $CLUSTER_NAME --query 'DBClusters[0].Status' --output text);  if [[ $STATUS == 'available' ]]; then break; fi ; done; echo 'Ready!'

[sr-apotapov]

Still no solution?
4 years to implement a simplest request.

[daniefdz]

You can implement your own custom waiter to support db-cluster operations

    model = botocore.waiter.WaiterModel({
        "version": 2,
        "waiters": {
            "db_cluster_available": {
                "operation": "DescribeDBClusters",
                "delay": 10,
                "maxAttempts": 30,
                "acceptors": [
                    {
                    "matcher": "pathAll",
                    "expected": "available",
                    "state": "success",
                    "argument": "DBClusters[].Status"
                    }
                ]
            }
        }
    })

    waiter = botocore.waiter.create_waiter_with_client("db_cluster_available", model, client)

https://docs.aws.amazon.com/code-samples/latest/catalog/python-demo_tools-custom_waiter.py.html
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds.html#RDS.Client.describe_db_clusters

[tim-finnigan]

Hi all thanks again for your patience. A new waiter model had been added for DBClusterAvailable:

The new waiter is available starting in these versions:

• AWS CLI v2.7.13
• AWS CLI v1.25.23
• boto3 v1.24.23

Please update your version of the CLI/SDK and let us know if you run into any issues using this.

[github-actions]

This issue is now closed.

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.

[paul-m]

🎉