AWSRDS每位用户的DB连接数
AWS RDS提供了多种方法来获取每位用户的DB连接数。以下是一些可能用到的示例代码：
- 使用AWS CLI：
aws rds describe-db-connections --profile your_profile 输出示例： { "DBConnections": [ { "DBInstanceIdentifier": "my-rds-instance", "Endpoint": "my-rds-instance.aaaaaaaaaa.ap-northeast-1.rds.amazonaws.com:3306", "CIDRIP": "1.2.3.4/32", "Status": "available", "EndpointPort": 3306, "VpcId": "vpc-01234567", "DBSecurityGroups": [ { "DBSecurityGroupName": "my-sec-group", "Status": "active" } ], "DBParameterGroups": [ { "DBParameterGroupName": "default.mysql5.7", "ParameterApplyStatus": "in-sync" } ], "ConnectionCreateTime": "2020-11-01T00:00:00.000Z" }, { "DBInstanceIdentifier": "my-rds-instance", "Endpoint": "my-rds-instance.aaaaaaaaaa.ap-northeast-1.rds.amazonaws.com:3306", "CIDRIP": "2.3.4.5/32", "Status": "available", "EndpointPort": 3306, "VpcId": "vpc-01234567", "DBSecurityGroups": [ { "DBSecurityGroupName": "my-sec-group", "Status": "active" } ], "DBParameterGroups": [ { "DBParameterGroupName": "default.mysql5.7", "ParameterApplyStatus": "in-sync" } ], "ConnectionCreateTime": "2020-11-02T00:00:00.000Z" } ] }
- 使用CloudWatch：
对于MySQL，您可以使用以下指标：
- NumberOfConnections
- ConnectionThroughput
示例代码：
import boto3
from datetime import datetime, timedelta
# Establish boto3 client
cloudwatch = boto3.client('cloudwatch