Aurora MYSQL Max_Connections Number

0

Hello everyone, I'm facing a little issue with my Aurora MYSQL database, I keep changing the max connections number to avoid 1040 error in my custom parameter group as showed in documentation, but after they say It was changed in RDS events It keeps returning to default value (180 for 2 instances in my case), I wonder if someone faced the same issue and how to fix that, thank you.

已提问 2 年前587 查看次数
1 回答
0
已接受的回答

Hi there!

From the notes, I understand that you managed to create a custom parameter group for your DB cluster and changed the max connection value but the value is not reflecting/changing. Please correct me if my understanding is wrong.

Please note that when changing the parameter value of your custom parameter group, you will need to associate the custom parameter group with the DB cluster. Check document in link [1] to confirm the steps to associate a DB cluster parameter group with a DB cluster. Change the check box under “Scheduling and Modifications” from apply during the next maintenance window to apply changes immediately.

Please note that after you change the DB cluster parameter group associated with a DB cluster, a reboot will be required on the primary DB instance in the cluster to apply the changes to all of the DB instances in the cluster.

I hope the above information is helpful.

References:

[1] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithDBClusterParamGroups.html#USER_WorkingWithParamGroups.AssociatingCluster

Letty
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则