Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

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?

Themen
KalkulationMigration und ModernisierungAnalysenDatenbank
Tags
Amazon LightsailAmazon Relational Database ServiceMySQL
Sprache
English
Ahmed Nabil
gefragt vor 4 Monaten188 Aufrufe
2 Antworten
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
EXPERTE
Riku_Kobayashi
beantwortet vor 4 Monaten
  • Ahmed Nabil
    vor 4 Monaten

    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.

  • Riku_Kobayashi EXPERTE
    vor 4 Monaten

    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
EXPERTE
AWS-SUM
beantwortet vor 4 Monaten
AWS
SUPPORT-TECHNIKER
Naveen_P
überprüft vor 4 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt