cloudposse / terraform-aws-rds

Terraform module to provision AWS RDS instances
https://cloudposse.com/accelerate
Apache License 2.0
156 stars 181 forks source link

No documentation for aurora mysql 8 serverless #152

Closed jacobnollette closed 9 months ago

jacobnollette commented 1 year ago

Having issues finding out what the cluster family should be for mysql 8 aurora? Any ideas?

haidargit commented 9 months ago

Hi, run this one-liner aws cli command on your terminal/shell to get the cluster families.

aws rds describe-db-engine-versions --query "DBEngineVersions[].DBParameterGroupFamily" --region <your_region>

you'll get a long list from the output

[
    "aurora-mysql5.7",
    . . .
    "docdb3.6",
    . . .
    "custom-sqlserver-ee-15.0",
    . . .
    . . .
    . . .
    "db2-se-11.5",
    . . .
    etc
]

Then choose the desired family based on your needs/requirements and put it in your Terraform configuration. So this is not a bug, actually.

or.. you can use grep to simplify the cluster family findings, e.g., "aurora-mysql8.0"

aws rds describe-db-engine-versions --query "DBEngineVersions[].DBParameterGroupFamily" --region us-west-2 | grep aurora-mysql

image

good luck!

reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithDBInstanceParamGroups.html

joe-niland commented 9 months ago

Thanks for the info @haidargit