cloudwatch-常见资源指标收集及计算

RDS

数据库连接数使用率

1.配置Prometheusrules规则，设置资源映射关系

apiVersion: monitoring.coreos.com/v1
kind: PrometheusRule
metadata:
 name: aws-rds-static-memory
 namespace: monitor 
 labels:
   release: prometheus 
spec:
 groups:
 - name: aws_rds_memory_static
   rules:
   - record: aws_rds_instance_memory_bytes
     labels:
       tag_DBInstanceClass: "db.t3.micro"
     expr: "1073741824"
   - record: aws_rds_instance_memory_bytes
     labels:
       tag_DBInstanceClass: "db.t3.small"
     expr: "2147483648"
   - record: aws_rds_instance_memory_bytes
     labels:
       tag_DBInstanceClass: "db.t3.medium"
     expr: "4294967296"
   - record: aws_rds_instance_memory_bytes
     labels:
       tag_DBInstanceClass: "db.m5.large"
     expr: "8589934592"

2.计算

aws_rds_database_connections_average{name=~"^arn:aws.*",dimension_CacheNodeId=""} 
/
on(tag_DBInstanceClass)
group_left()
(
 aws_rds_instance_memory_bytes / 12582880
) *100 > 85