Help us understand the problem. What is going on with this article?

[JAWS-UG CLI] RDS:#2 DBインスタンスの削除

More than 3 years have passed since last update.

前提条件

RDSへの権限

RDSに対してフル権限があること。

AWS CLI

以下のバージョンで動作確認済

  • AWS CLI 1.11.14
コマンド
aws --version

結果(例)

aws-cli/1.11.14 Python/2.7.10 Darwin/15.6.0 botocore/1.4.71

バージョンが古い場合は最新版に更新しましょう。

コマンド
sudo -H pip install -U awscli

0. 準備

0.1. リージョンの決定

変数の設定
export AWS_DEFAULT_REGION='ap-northeast-1'

0.2. 変数の確認

プロファイルが想定のものになっていることを確認します。

変数の確認
aws configure list

結果(例)

        Name                    Value             Type    Location
        ----                    -----             ----    --------
     profile       rdsFull-prjz-mbp13        env    AWS_DEFAULT_PROFILE
  access_key     ****************XXXX shared-credentials-file
  secret_key     ****************XXXX shared-credentials-file
      region        ap-northeast-1        env    AWS_DEFAULT_REGION

0.3. 削除するDBインスタンスの決定

変数の設定
RDS_INSTANCE_IDENT="<削除するインスタンス名>"

1. 事前作業

1.1. 削除するDBインスタンスの確認

コマンド
aws rds describe-db-instances \
        --db-instance-identifier ${RDS_INSTANCE_IDENT}

結果(例)

  {
    "DBInstances": [
      {
          "PubliclyAccessible": true,
          "MasterUsername": "pgadmin",
          "LicenseModel": "postgresql-license",
          "VpcSecurityGroups": [
              {
                  "Status": "active",
                  "VpcSecurityGroupId": "sg-xxxxxxxx"
              }
          ],
          "InstanceCreateTime": "2015-03-16T06:59:18.215Z",
          "OptionGroupMemberships": [
              {
                  "Status": "in-sync",
                  "OptionGroupName": "default:postgres-9-3"
              }
          ],
          "PendingModifiedValues": {},
          "Engine": "postgres",
          "MultiAZ": false,
          "LatestRestorableTime": "2015-03-16T08:00:29Z",
          "DBSecurityGroups": [],
          "DBParameterGroups": [
              {
                  "DBParameterGroupName": "default.postgres9.3",
                  "ParameterApplyStatus": "in-sync"
              }
          ],
          "AutoMinorVersionUpgrade": true,
          "PreferredBackupWindow": "14:23-14:53",
          "DBSubnetGroup": {
              "Subnets": [
                  {
                      "SubnetStatus": "Active",
                      "SubnetIdentifier": "subnet-xxxxxxxx",
                      "SubnetAvailabilityZone": {
                          "Name": "ap-northeast-1c"
                      }
                  },
                  {
                      "SubnetStatus": "Active",
                      "SubnetIdentifier": "subnet-xxxxxxxx",
                      "SubnetAvailabilityZone": {
                          "Name": "ap-northeast-1a"
                      }
                  }
              ],
              "DBSubnetGroupName": "default",
              "VpcId": "vpc-50b34035",
              "DBSubnetGroupDescription": "default",
              "SubnetGroupStatus": "Complete"
          },
          "ReadReplicaDBInstanceIdentifiers": [],
          "AllocatedStorage": 5,
          "BackupRetentionPeriod": 1,
          "DBName": "handson",
          "PreferredMaintenanceWindow": "sat:17:40-sat:18:10",
          "Endpoint": {
              "Port": 5432,
              "Address": "postgre-handson-ap-northeast-1.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com"
          },
          "DBInstanceStatus": "available",
          "EngineVersion": "9.3.5",
          "AvailabilityZone": "ap-northeast-1c",
          "StorageType": "standard",
          "DbiResourceId": "db-XNOYXXXXXXXXXXXXXXXXXXXXXX",
          "StorageEncrypted": false,
          "DBInstanceClass": "db.t1.micro",
          "DBInstanceIdentifier": "postgre-handson-ap-northeast-1"
      }
    ]
  }

2. DBインスタンスの削除

2.1. DBインスタンスの削除

変数の確認
cat << ETX

        RDS_INSTANCE_IDENT ${RDS_INSTANCE_IDENT}

ETX
コマンド
aws rds delete-db-instance \
        --db-instance-identifier ${RDS_INSTANCE_IDENT} \
        --skip-final-snapshot

結果(例)

  {
    "DBInstance": {
      "PubliclyAccessible": true,
      "MasterUsername": "pgadmin",
      "LicenseModel": "postgresql-license",
      "VpcSecurityGroups": [
          {
              "Status": "active",
              "VpcSecurityGroupId": "sg-xxxxxxxx"
          }
      ],
      "InstanceCreateTime": "2015-03-16T06:59:18.215Z",
      "OptionGroupMemberships": [
          {
              "Status": "in-sync",
              "OptionGroupName": "default:postgres-9-3"
          }
      ],
      "PendingModifiedValues": {},
      "Engine": "postgres",
      "MultiAZ": false,
      "LatestRestorableTime": "2015-03-16T08:00:29Z",
      "DBSecurityGroups": [],
      "DBParameterGroups": [
          {
              "DBParameterGroupName": "default.postgres9.3",
              "ParameterApplyStatus": "in-sync"
          }
      ],
      "AutoMinorVersionUpgrade": true,
      "PreferredBackupWindow": "14:23-14:53",
      "DBSubnetGroup": {
          "Subnets": [
              {
                  "SubnetStatus": "Active",
                  "SubnetIdentifier": "subnet-xxxxxxxx",
                  "SubnetAvailabilityZone": {
                      "Name": "ap-northeast-1c"
                  }
              },
              {
                  "SubnetStatus": "Active",
                  "SubnetIdentifier": "subnet-xxxxxxxx",
                  "SubnetAvailabilityZone": {
                      "Name": "ap-northeast-1a"
                  }
              }
          ],
          "DBSubnetGroupName": "default",
          "VpcId": "vpc-50b34035",
          "DBSubnetGroupDescription": "default",
          "SubnetGroupStatus": "Complete"
      },
      "ReadReplicaDBInstanceIdentifiers": [],
      "AllocatedStorage": 5,
      "BackupRetentionPeriod": 1,
      "DBName": "handson",
      "PreferredMaintenanceWindow": "sat:17:40-sat:18:10",
      "Endpoint": {
          "Port": 5432,
          "Address": "postgre-handson-ap-northeast-1.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com"
      },
      "DBInstanceStatus": "deleting",
      "EngineVersion": "9.3.5",
      "AvailabilityZone": "ap-northeast-1c",
      "StorageType": "standard",
      "DbiResourceId": "db-XNOYXXXXXXXXXXXXXXXXXXXXXX",
      "StorageEncrypted": false,
      "DBInstanceClass": "db.t1.micro",
      "DBInstanceIdentifier": "postgre-handson-ap-northeast-1"
    }
  }

2.2. DBインスタンスの状態確認

変数の設定
RDS_INSTANCE_STATUS=$( \
        aws rds describe-db-instances \
          --db-instance-identifier ${RDS_INSTANCE_IDENT}\
          --query 'DBInstances[].DBInstanceStatus'\
          --output text \
) \
          && echo ${RDS_INSTANCE_STATUS}

結果

  deleting

3. 事後確認

3.1. DBインスタンスの状態確認

変数の設定
RDS_INSTANCE_STATUS=$( \
        aws rds describe-db-instances\
          --db-instance-identifier ${RDS_INSTANCE_IDENT}\
          --query 'DBInstances[].DBInstanceStatus'\
          --output text \
) \
        && echo ${RDS_INSTANCE_STATUS}

結果

  A client error (DBInstanceNotFound) occurred when calling the DescribeDBInstances operation: DBInstance postgre-handson not found.

3.2. 残留スナップショットの確認

コマンド
aws rds describe-db-snapshots \
          --db-instance-identifier ${RDS_INSTANCE_IDENT}

結果

  {
      "DBSnapshots": []
  }

完了

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away