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.

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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ