How to configure advanced PostgreSQL and MySQL Database Instance settings
Reviewed on 13 June 2023 • Published 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:
- You have an account and are logged into the Scaleway console
- You have a PostgreSQL or MySQL Database Instance
Important:
Changing the advanced settings can have an impact on the performance of your Database Instance.
-
Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
-
Click the database name or «See more Icon» > More info to access the database information page.
-
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