Learn about the advanced configuration options available for Cloud Databases through the OVHcloud Control Panel and via API.
Cloud Databases and Analytics are managed services, which means that they are not fully configurable. For example, it is not possible to modify pg_hba.conf.
Advanced configuration is available for the following database and analytics engines:
- Cassandra
- Grafana® 1
- Kafka
- Kafka Connect
- MySQL
- OpenSearch
- PostgreSQL
- Caching
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 and open your Public Cloud project. In the left-hand navigation bar, under Databases & Analytics, select Databases, Data Streaming, or Data Analysis. Select your engine instance then the Advanced configuration tab.
Select the key of the advanced setting you want to define, then set its value.
When ready, click on Update advanced configuration.
On the top-right of the advanced configuration tab, you can see the settings that are already defined.
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:
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 |
|---|---|
| Cassandra | |
| Grafana® | |
| Kafka | |
| Kafka Connect | |
| MySQL | |
| OpenSearch | |
| PostgreSQL | |
| Redis (Caching) |
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 |
|---|---|
| Cassandra | |
| Grafana® | |
| Kafka | |
| Kafka Connect | |
| MySQL | |
| OpenSearch | |
| PostgreSQL | |
| Redis (Caching) |
Advanced configuration settings list
Open the following API call, paste the corresponding inputs (serviceName, clusterId), and click Execute:
| Engine | API call |
|---|---|
| Cassandra | |
| Grafana® | |
| Kafka | |
| Kafka Connect | |
| MySQL | |
| OpenSearch | |
| PostgreSQL | |
| Redis (Caching) |
Change advanced configuration
Open the following API call and paste the corresponding inputs (serviceName, clusterId):
| Engine | API call |
|---|---|
| Cassandra | |
| Grafana® | |
| Kafka | |
| Kafka Connect | |
| MySQL | |
| OpenSearch | |
| PostgreSQL | |
| Redis (Caching) |
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.
[1]: The Grafana Labs Marks are trademarks of Grafana Labs, and are used with Grafana Labs’ permission. We are not affiliated with, endorsed or sponsored by Grafana Labs or its affiliates.