[Enhancement]: Set monitoring interval for RDS clusters

[jeroenvdheuvel]

Description

RDS clusters like Aurora (MySQL) have the monitoring interval configured on the cluster instead of individual cluster instances. When trying to set the monitoring interval on an instance level, an error is thrown:

Error: updating RDS Cluster Instance (my-cluster-here): operation error RDS: ModifyDBInstance, https response error StatusCode: 400, RequestID: my-request-id-here, api error InvalidParameterCombination: MonitoringInterval conflicts with cluster level parameter.

Monitoring interval should be set on the cluster, via --monitoring-interval.

Can support for setting the monitoring interval and monitoring-arn-role be added to the cluster?

Affected Resource(s) and/or Data Source(s)

• aws_rds_cluster
• aws_rds_cluster_instance (being incompatible with setting cluster settings)

Potential Terraform Configuration

resource "aws_rds_cluster" "cluster" {
  monitoring_interval = 10
  monitoring_role_arn = "arn:aws:..."
  ...
}

References

monitoring interval and role arn: https://docs.aws.amazon.com/cli/latest/reference/rds/modify-db-cluster.html#options

monitoring interval and role arn for RDS instance: https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/rds_cluster_instance#monitoring_interval-2

Would you like to implement a fix?

No

[github-actions]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.