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?

2 Answers
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
EXPERT
answered 22 days ago
  • 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
MODERATOR
AWS-SUM
answered 22 days ago
AWS
SUPPORT ENGINEER
reviewed 21 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions