Update content

How to configure advanced PostgreSQL and MySQL Database Instance settings

Reviewed on 13 June 2023Published on 11 May 2019

Advanced settings allow you to modify the default configuration of your database engines.

Security & Identity (IAM):

You may need certain IAM permissions to carry out some actions described on this page. This means:

  • you are the Owner of the Scaleway Organization in which the actions will be carried out, or
  • you are an IAM user of the Organization, with a policy granting you the necessary permission sets
Requirements:
Important:

Changing the advanced settings can have an impact on the performance of your Database Instance.

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.

  2. Click the database name or «See more Icon» > More info to access the database information page.

  3. Click the Advanced settings tab.

    To add advanced settings follow these steps:

  • Click Add advanced setting.
  • Click Add parameters.
  • Select your parameter from the drop-down list.
  • Configure the value associated with your setting
  • Click «Validate Icon» to validate.

To delete them:

  • Click «Edit Icon» in the advanced settings tab.
  • Click «Delete Icon» next to the setting you wish to delete.
  • Click «Validate Icon» to confirm your changes.
See Also