查看集群状态

在 Amazon RDS 控制台中，您可以通过从控制台的导航窗格选择 Databases (数据库) 来查看有关数据库集群的详细信息。您还可以查看属于 Amazon Aurora 数据库集群成员的数据库实例的详细信息。

要使用 Amazon CLI 查看数据库集群信息，请使用 describe-db-clusters 命令。例如，以下 Amazon CLI 命令为配置的 us-east-1 账户列出修改 Amazon 区域中的所有数据库集群的数据库集群信息。

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

如果已为 Amazon 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 操作。

要仅查看数据库集群的状态，请在 Amazon CLI 中使用以下查询。

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

要使用 Amazon CLI 查看数据库实例及其状态信息，请使用 describe-db-instances 命令。例如，以下 Amazon CLI 命令可列出所有数据库实例信息。

aws rds describe-db-instances

要查看特定数据库实例及其状态，请带以下选项调用 describe-db-instances 命令：

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

要只是查看所有数据库集群的状态，请在 Amazon CLI 中使用以下查询。

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

要使用 Amazon RDS API 查看数据库实例的状态，请调用 DescribeDBInstances 操作。