Advanced Database Instance settings allow you to tune the behavior of your database engines to better fit your needs.
Available settings depend on the database engine and its version. Note that some settings can only be defined upon database engine initialization. These are called init settings. You can find a full list of the settings available in the response body of the list available database engines endpoint.
Each advanced setting entry has a default value that users can override. The deletion of a setting entry will restore the setting to default value. Some of the defaults values can be different from the engine's defaults, as we optimize them to the Scaleway platform.
Set Database Instance advanced settings
Update an advanced setting for a Database Instance. Settings added upon database engine initialization can only be defined once, and cannot, therefore, be updated.
path Parameters
regionThe region you want to target
instance_idUUID of the Database Instance where the settings must be set.
Set Database Instance advanced settings › Request Body
Settings to define for the Database Instance.
Set Database Instance advanced settings › Responses
Settings configured for a Database Instance.
Add Database Instance advanced settings
Add an advanced setting to a Database Instance. You must set the name and the value of each setting.
path Parameters
regionThe region you want to target
instance_idUUID of the Database Instance you want to add settings to.
Add Database Instance advanced settings › Request Body
Settings to add to the Database Instance.
Add Database Instance advanced settings › Responses
Settings available on the Database Instance.
Delete Database Instance advanced settings
Delete an advanced setting in a Database Instance. You must specify the names of the settings you want to delete in the request.
path Parameters
regionThe region you want to target
instance_idUUID of the Database Instance to delete settings from.
Delete Database Instance advanced settings › Request Body
setting_namesSettings names to delete.
Delete Database Instance advanced settings › Responses
Settings names to delete from the Database Instance.