mysql_capabilities_advanced_configurations

Creates, updates, deletes, gets or lists a mysql_capabilities_advanced_configurations resource.

Overview

Name	mysql_capabilities_advanced_configurations
Type	Resource
Id	ovh.cloud_database.mysql_capabilities_advanced_configurations

Fields

The following fields are returned by SELECT queries:

list

Specific database engine capability

Name	Datatype	Description
name	string	Property name
default	string	Default value of the property. Null when the engine does not provide one.
description	string	Description of the property
maximum	number	Maximum value for the property if numeric and applicable
minimum	number	Minimum value for the property if numeric and applicable
type	string	Data type of the property (boolean, double, long, string)
values	array	Possible values for the property if string and applicable

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	cluster_id, service_name		Get MySQL advanced configuration fields

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
api_host	string	The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
cluster_id	string (uuid)	Cluster ID (wire: clusterId)
service_name	string	The Public Cloud project ID. Resolved from OVH_CLOUD_PROJECT_SERVICE when set.

SELECT examples

list

Get MySQL advanced configuration fields

SELECT
name,
default,
description,
maximum,
minimum,
type,
values
FROM ovh.cloud_database.mysql_capabilities_advanced_configurations
WHERE cluster_id = '{{ cluster_id }}' -- required
AND service_name = '{{ service_name }}' -- required unless OVH_CLOUD_PROJECT_SERVICE is set
;