--- title: "Databases & Analytics - Advanced configuration" description: "Learn about the advanced configuration options available for Cloud Databases and Analytics through the OVHcloud Control Panel and via API." url: https://docs.us.ovhcloud.com/en/public-cloud/databases/advanced-configuration lang: en --- > For AI agents: the complete documentation index is available at https://docs.us.ovhcloud.com/en/llms.txt, the full documentation bundle is available at https://docs.us.ovhcloud.com/en/llms-full.txt. # Databases & Analytics - Advanced configuration **Learn about the advanced configuration options available for Cloud Databases and Analytics through the OVHcloud Control Panel and via API.** Cloud Databases and Analytics[\*](#go-further) are managed services, meaning they are not fully configurable. For example, it is not possible to modify _pg\_hba.conf_. **Note:** Advanced configuration is available for the following databases and analytics engines: - Dashboards - Kafka® - Kafka® Connect - MySQL® - OpenSearch™ - PostgreSQL® - Valkey   ## Requirements - A [Public Cloud project](https://us.ovhcloud.com/public-cloud/) in your OVHcloud account - A Cloud Databases or Analytics[\*](#go-further) service running in your OVHcloud account ([this guide](https://docs.us.ovhcloud.com/en/public-cloud/databases/getting-started.md) can help you to meet this requirement) - Access to your [OVHcloud Control Panel](https://manager.us.ovhcloud.com/) or the [OVHcloud API](https://api.us.ovhcloud.com/).   ## Instructions **Warning:** **NOTE:** Please note that changes to the advanced settings apply at the cluster level and therefore to all the services in the cluster. **Note:** Depending on the engine, some settings may already be defined. **Note:** 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](#checking) section below. ### Using the OVHcloud Control Panel To change the advanced configuration, you first need to log in to your [OVHcloud Control Panel](https://manager.us.ovhcloud.com/). 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 **Note:** If you are not familiar with using the OVHcloud API, please refer to our guide on [First Steps with the OVHcloud API](https://docs.us.ovhcloud.com/en/manage-and-operate/api/first-steps.md). #### 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](https://api.us.ovhcloud.com/console/?section=/cloud/project&branch=v1#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_](https://docs.us.ovhcloud.com/en/public-cloud/databases/postgresql-connect-pgadmin.md)_ to learn more about pgAdmin._   ## Go further Browse all the [Databases guides](https://docs.us.ovhcloud.com/en/public-cloud/databases/landing-page-databases.md). Browse the rest of the [OVHcloud US documentation](https://docs.us.ovhcloud.com/en/index.md) for guides on our other products and services. Learn more about [Managed Databases](https://us.ovhcloud.com/public-cloud/databases/) on the OVHcloud US website. 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.