檢視叢集狀

在 Amazon RDS 主控台中，透過從主控台的導覽窗格中選擇 Databases (資料庫)，可檢視資料庫叢集詳細資訊。您也可以檢視屬於 Amazon Aurora 資料庫叢集成員的資料庫執行個體詳細資訊。

若要使用檢視資料庫叢集資訊 AWS CLI，請使用描述-db-叢集命令。例如，下列 AWS CLI 命令會針對已設定的 AWS 帳戶列出修改us-east-1區域中所有資料庫叢集的資料庫叢集資訊。

aws rds describe-db-clusters --region us-east-1

如果您 AWS CLI 已設定 JSON 輸出，命令會傳回下列輸出。

{
    "DBClusters": [
        {
            "Status": "available",
            "Engine": "aurora-mysql",
            "Endpoint": "sample-cluster1.cluster-123456789012.us-east-1.rds.amazonaws.com"
            "AllocatedStorage": 1,
            "DBClusterIdentifier": "sample-cluster1",
            "MasterUsername": "mymasteruser",
            "EarliestRestorableTime": "2023-03-30T03:35:42.563Z",
            "DBClusterMembers": [
                {
                    "IsClusterWriter": false,
                    "DBClusterParameterGroupStatus": "in-sync",
                    "DBInstanceIdentifier": "sample-replica"
                },
                {
                    "IsClusterWriter": true,
                    "DBClusterParameterGroupStatus": "in-sync",
                    "DBInstanceIdentifier": "sample-primary"
                }
            ],
            "Port": 3306,
            "PreferredBackupWindow": "03:34-04:04",
            "VpcSecurityGroups": [
                {
                    "Status": "active",
                    "VpcSecurityGroupId": "sg-ddb65fec"
                }
            ],
            "DBSubnetGroup": "default",
            "StorageEncrypted": false,
            "DatabaseName": "sample",
            "EngineVersion": "5.7.mysql_aurora.2.11.0",
            "DBClusterParameterGroup": "default.aurora-mysql5.7",
            "BackupRetentionPeriod": 1,
            "AvailabilityZones": [
                "us-east-1b",
                "us-east-1c",
                "us-east-1d"
            ],
            "LatestRestorableTime": "2023-03-31T20:06:08.903Z",
            "PreferredMaintenanceWindow": "wed:08:15-wed:08:45"
        },
        {
            "Status": "available",
            "Engine": "aurora-mysql",
            "Endpoint": "aurora-sample.cluster-123456789012.us-east-1.rds.amazonaws.com",
            "AllocatedStorage": 1,
            "DBClusterIdentifier": "aurora-sample-cluster",
            "MasterUsername": "mymasteruser",
            "EarliestRestorableTime": "2023-03-30T10:21:34.826Z",
            "DBClusterMembers": [
                {
                    "IsClusterWriter": false,
                    "DBClusterParameterGroupStatus": "in-sync",
                    "DBInstanceIdentifier": "aurora-replica-sample"
                },
                {
                    "IsClusterWriter": true,
                    "DBClusterParameterGroupStatus": "in-sync",
                    "DBInstanceIdentifier": "aurora-sample"
                }
            ],
            "Port": 3306,
            "PreferredBackupWindow": "10:20-10:50",
            "VpcSecurityGroups": [
                {
                    "Status": "active",
                    "VpcSecurityGroupId": "sg-55da224b"
                }
            ],
            "DBSubnetGroup": "default",
            "StorageEncrypted": false,
            "DatabaseName": "sample",
            "EngineVersion": "5.7.mysql_aurora.2.11.0",
            "DBClusterParameterGroup": "default.aurora-mysql5.7",
            "BackupRetentionPeriod": 1,
            "AvailabilityZones": [
                "us-east-1b",
                "us-east-1c",
                "us-east-1d"
            ],
            "LatestRestorableTime": "2023-03-31T20:00:11.491Z",
            "PreferredMaintenanceWindow": "sun:03:53-sun:04:23"
        }
    ]
}

若要使用 Amazon RDS API 檢視資料庫叢集資訊，請使用 DescribeDBClusters 操作。

若只要檢視資料庫叢集的狀態，請在中使用下列查詢 AWS CLI。

aws rds describe-db-clusters --query 'DBClusters[*].[DBClusterIdentifier,Status]' --output table

若要使用檢視資料庫執行個體及其狀態資訊 AWS CLI，請使用描述-DB 執行個體命令。例如，下面的 AWS CLI 命令列出了所有的數據庫實例信息。

aws rds describe-db-instances

若要檢視特定資料庫執行個體及其狀態，請搭配下列選項呼叫 describe-db-instances 命令：

aws rds describe-db-instances --db-instance-identifier mydbinstance

若只要檢視所有資料庫執行個體的狀態，請在中使用下列查詢 AWS CLI。

aws rds describe-db-instances --query 'DBInstances[*].[DBInstanceIdentifier,DBInstanceStatus]' --output table

若要使用 Amazon RDS API 檢視資料庫執行個體的狀態，請呼叫 DescribeDBInstances 操作。