Databases & Analytics - Advanced configuration – Support Guides

Learn about the advanced configuration options available for Cloud Databases and Analytics through the OVHcloud Control Panel and via API.

Cloud Databases and Analytics* are managed services, meaning they are not fully configurable. For example, it is not possible to modify pg_hba.conf.

Advanced configuration is available for the following databases and analytics engines:

Dashboards
Kafka®
Kafka® Connect
MySQL®
OpenSearch™
PostgreSQL®
Valkey

Requirements

A Public Cloud project in your OVHcloud account
A Cloud Databases or Analytics* service running in your OVHcloud account (this guide can help you to meet this requirement)
Access to your OVHcloud Control Panel or the OVHcloud API.

Instructions

NOTE: Please note that changes to the advanced settings apply at the cluster level and therefore to all the services in the cluster.

Depending on the engine, some settings may already be defined.

Once the advanced configuration has been submitted, it is not possible to reset it to initial values. It is only possible to update the values, so we recommend that you take note of the initial values before changing them.

See the Checking section below.

Using the OVHcloud Control Panel

To change the advanced configuration, you first need to log in to your OVHcloud Control Panel. Navigate to the Databases (or Data Streaming or Data Analysis) area via the Public Cloud menu.

Select your engine instance, then the Advanced configuration tab.

Scroll to the bottom of the page. Select the key of the advanced setting you want to define, click the add + button, and then set its value.

When ready, click Save changes.

Using API

If you are not familiar with using the OVHcloud API, please refer to our guide on First Steps with the OVHcloud API.

Get your service and cluster IDs

You first need to identify the service and the cluster to which you want to apply the changes.

Get the desired service ID

Execute the following API call:

GET /cloud/project

From the resulting list, select and copy the service identifier corresponding to the desired service, also known as serviceName.

Get the desired cluster ID

Open the following API call, paste your service ID into the serviceName input field and click Execute:

Engine	API call
Dashboard	GET /cloud/project/{serviceName}/database/grafana
Kafka®	GET /cloud/project/{serviceName}/database/kafka
Kafka® Connect	GET /cloud/project/{serviceName}/database/kafkaConnect
MySQL®	GET /cloud/project/{serviceName}/database/mysql
OpenSearch™	GET /cloud/project/{serviceName}/database/opensearch
PostgreSQL®	GET /cloud/project/{serviceName}/database/postgresql
Valkey	GET /cloud/project/{serviceName}/database/valkey

From the resulting list, select and copy the clusterId.

Get the existing advanced configuration

Open the following API call, paste the corresponding inputs (serviceName, clusterId), and click Execute:

Engine	API call
Dashboard	GET /cloud/project/{serviceName}/database/grafana/{clusterId}/advancedConfiguration
Kafka®	GET /cloud/project/{serviceName}/database/kafka/{clusterId}/advancedConfiguration
Kafka® Connect	GET /cloud/project/{serviceName}/database/kafkaConnect/{clusterId}/advancedConfiguration
MySQL®	GET /cloud/project/{serviceName}/database/mysql/{clusterId}/advancedConfiguration
OpenSearch™	GET /cloud/project/{serviceName}/database/opensearch/{clusterId}/advancedConfiguration
PostgreSQL®	GET /cloud/project/{serviceName}/database/postgresql/{clusterId}/advancedConfiguration
Valkey	GET /cloud/project/{serviceName}/database/valkey/{clusterId}/advancedConfiguration

Advanced configuration settings list

Open the following API call, paste the corresponding inputs (serviceName, clusterId), and click Execute:

Engine	API call
Dashboard	GET /cloud/project/{serviceName}/database/grafana/{clusterId}/capabilities/advancedConfiguration
Kafka®	GET /cloud/project/{serviceName}/database/kafka/{clusterId}/capabilities/advancedConfiguration
Kafka® Connect	GET /cloud/project/{serviceName}/database/kafkaConnect/{clusterId}/capabilities/advancedConfiguration
MySQL®	GET /cloud/project/{serviceName}/database/mysql/{clusterId}/capabilities/advancedConfiguration
OpenSearch™	GET /cloud/project/{serviceName}/database/opensearch/{clusterId}/capabilities/advancedConfiguration
PostgreSQL®	GET /cloud/project/{serviceName}/database/postgresql/{clusterId}/capabilities/advancedConfiguration
Valkey	GET /cloud/project/{serviceName}/database/valkey/{clusterId}/capabilities/advancedConfiguration

Change advanced configuration

Open the following API call and paste the corresponding inputs (serviceName, clusterId):

Engine	API call
Dashboard	PUT /cloud/project/{serviceName}/database/grafana/{clusterId}/advancedConfiguration
Kafka®	PUT /cloud/project/{serviceName}/database/kafka/{clusterId}/advancedConfiguration
Kafka® Connect	PUT /cloud/project/{serviceName}/database/kafkaConnect/{clusterId}/advancedConfiguration
MySQL®	PUT /cloud/project/{serviceName}/database/mysql/{clusterId}/advancedConfiguration
OpenSearch™	PUT /cloud/project/{serviceName}/database/opensearch/{clusterId}/advancedConfiguration
PostgreSQL®	PUT /cloud/project/{serviceName}/database/postgresql/{clusterId}/advancedConfiguration
Valkey	PUT /cloud/project/{serviceName}/database/valkey/{clusterId}/advancedConfiguration

Now, according to the settings you chose, set the different values into the string arrays, such as in the example below:

When ready, click on Execute to update the advanced configuration.

Checking

You can check the changes in different ways such as:

Using API

Using pgAdmin

Follow this guide to learn more about pgAdmin.

Go further

For more information and tutorials, please see our other Managed Databases & Analytics or Platform as a Service guides. You can also explore the guides for other OVHcloud products and services.

OVHcloud Managed Databases and Analytics:

Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
MongoDB® is a registered trademark of MongoDB, Inc.
MySQL® is a registered trademark of Oracle and/or its affiliates.
PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.