大网数据广告活动
服务器运维问答

RDS Aurora Serverless "Parameter Groups"

· 52CE 我爱测

I have an RDS Aurora Serverless MySQL cluster, and I am trying to change a MySQL setting ( connect_timeout ). Normally, you would use a Parameter Group to set the value on the DB instance. But, since this is serverless, the insta…

问题原文

原帖链接 · twiz · CC BY-SA 4.0

I have an RDS Aurora Serverless MySQL cluster, and I am trying to change a MySQL setting (connect_timeout). Normally, you would use a Parameter Group to set the value on the DB instance. But, since this is serverless, the instances are all managed by AWS, so it seems I can only configure the cluster.

Is there a way to set the Parameter Group that is used by the instances that AWS creates?

已采纳解答

原帖链接 · Michael - sqlbot · CC BY-SA 4.0

Aurora Serverless has limited options for configuration customization.

With an Aurora Serverless DB cluster, you can only modify the following cluster-level parameters:

  • character_set_server

  • collation_server

  • lc_time_names

  • lower_case_table_names

  • time_zone

If you modify other cluster-level parameters, the changes have no effect, and the Aurora Serverless DB cluster uses the default values for these parameters.

...

Note

Instance-level parameters do not apply to Aurora Serverless.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html

For the specific issue that prompted the question, connect_timeout can't be adjusted, but this timer would not be the cause of timeouts when connecting to a cold (sleeping) Aurora Serverless cluster, even though the wait time in that case can be up to about 30 seconds. This timer doesn't start running until the MySQL server has accepted the connection request, sent its initial handshake, and started waiting for the client to respond. To avoid timeouts in this situation, your client library will need to wait longer before giving up on the server.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2019-01-19)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。