Is it possible to create custom parameter group for Lightsail relational MYSQL database instance?

0

I have 4 database instances in Lightsail, i needed to use triggers but it turned out that creating triggers is not enabled by default, as a solution i must change a database parameter which i did to 3 out of the 4 instances i have, it looks like the remaining instance is set to use the default parameter group (which i couldn't update) instead of having a custom parameter.

Any thoughts?

已提问 4 个月前188 查看次数
2 回答
1

Hello.

If it is a Lightsail managed database, you should be able to change the parameters using the following command.
https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-updating-database-parameters

If you are using RDS, you can change the parameter group to a custom parameter group by following the steps in the document below.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithDBInstanceParamGroups.html

profile picture
专家
已回答 4 个月前
  • It is a lightsail managed DB and i already tried the update parameter solution it worked well with all the instances except one, failed with the following error message: (InvalidInputException) when calling the UpdateRelationalDatabaseParameters operation: Cannot modify a default parameter group.

  • Based on this documentation, it seems that Lightsail managed databases are configured with a custom parameter group when they are created. https://repost.aws/knowledge-center/lightsail-update-database-parameter

    When you create a Lightsail database, that database uses a custom parameter group named after the instance endpoint. Amazon Relational Database Service (Amazon RDS) DB instances use a default DB parameter group. To modify the database parameters for a Lightsail database instance, use the AWS Command Line Interface (AWS CLI).

    There is a possibility that this is a bug, so we recommend that you open a case with AWS Support under "Account and billing". Inquiries under "Account and billing" can be made free of charge. https://docs.aws.amazon.com/awssupport/latest/user/case-management.html

1

Hi,

Please contact AWS Support under the free support plan to get the issue looked into and allow you to update the database parameter.

Thanks.

profile pictureAWS
专家
AWS-SUM
已回答 4 个月前
AWS
支持工程师
已审核 4 个月前

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

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

回答问题的准则