1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabaseConfigurationData
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabaseConfigurationData

Explore with Pulumi AI

This data source provides the list of Managed My Sql Database Configuration Data in Oracle Cloud Infrastructure Database Management service.

Retrieves Configuration Data for given MySQL Instance.

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedMySqlDatabaseConfigurationData = oci.DatabaseManagement.getManagedMySqlDatabaseConfigurationData({
    managedMySqlDatabaseId: testManagedMySqlDatabase.id,
});
Copy
import pulumi
import pulumi_oci as oci

test_managed_my_sql_database_configuration_data = oci.DatabaseManagement.get_managed_my_sql_database_configuration_data(managed_my_sql_database_id=test_managed_my_sql_database["id"])
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/databasemanagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetManagedMySqlDatabaseConfigurationData(ctx, &databasemanagement.GetManagedMySqlDatabaseConfigurationDataArgs{
			ManagedMySqlDatabaseId: testManagedMySqlDatabase.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedMySqlDatabaseConfigurationData = Oci.DatabaseManagement.GetManagedMySqlDatabaseConfigurationData.Invoke(new()
    {
        ManagedMySqlDatabaseId = testManagedMySqlDatabase.Id,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedMySqlDatabaseConfigurationDataArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testManagedMySqlDatabaseConfigurationData = DatabaseManagementFunctions.getManagedMySqlDatabaseConfigurationData(GetManagedMySqlDatabaseConfigurationDataArgs.builder()
            .managedMySqlDatabaseId(testManagedMySqlDatabase.id())
            .build());

    }
}
Copy
variables:
  testManagedMySqlDatabaseConfigurationData:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedMySqlDatabaseConfigurationData
      arguments:
        managedMySqlDatabaseId: ${testManagedMySqlDatabase.id}
Copy

Using getManagedMySqlDatabaseConfigurationData

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getManagedMySqlDatabaseConfigurationData(args: GetManagedMySqlDatabaseConfigurationDataArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabaseConfigurationDataResult>
function getManagedMySqlDatabaseConfigurationDataOutput(args: GetManagedMySqlDatabaseConfigurationDataOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabaseConfigurationDataResult>
Copy
def get_managed_my_sql_database_configuration_data(filters: Optional[Sequence[_databasemanagement.GetManagedMySqlDatabaseConfigurationDataFilter]] = None,
                                                   managed_my_sql_database_id: Optional[str] = None,
                                                   opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabaseConfigurationDataResult
def get_managed_my_sql_database_configuration_data_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedMySqlDatabaseConfigurationDataFilterArgs]]]] = None,
                                                   managed_my_sql_database_id: Optional[pulumi.Input[str]] = None,
                                                   opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabaseConfigurationDataResult]
Copy
func GetManagedMySqlDatabaseConfigurationData(ctx *Context, args *GetManagedMySqlDatabaseConfigurationDataArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseConfigurationDataResult, error)
func GetManagedMySqlDatabaseConfigurationDataOutput(ctx *Context, args *GetManagedMySqlDatabaseConfigurationDataOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseConfigurationDataResultOutput
Copy

> Note: This function is named GetManagedMySqlDatabaseConfigurationData in the Go SDK.

public static class GetManagedMySqlDatabaseConfigurationData 
{
    public static Task<GetManagedMySqlDatabaseConfigurationDataResult> InvokeAsync(GetManagedMySqlDatabaseConfigurationDataArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedMySqlDatabaseConfigurationDataResult> Invoke(GetManagedMySqlDatabaseConfigurationDataInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetManagedMySqlDatabaseConfigurationDataResult> getManagedMySqlDatabaseConfigurationData(GetManagedMySqlDatabaseConfigurationDataArgs args, InvokeOptions options)
public static Output<GetManagedMySqlDatabaseConfigurationDataResult> getManagedMySqlDatabaseConfigurationData(GetManagedMySqlDatabaseConfigurationDataArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedMySqlDatabaseConfigurationData:getManagedMySqlDatabaseConfigurationData
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ManagedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
Filters Changes to this property will trigger replacement. List<GetManagedMySqlDatabaseConfigurationDataFilter>
ManagedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
Filters Changes to this property will trigger replacement. []GetManagedMySqlDatabaseConfigurationDataFilter
managedMySqlDatabaseId This property is required. String
The OCID of ManagedMySqlDatabase.
filters Changes to this property will trigger replacement. List<GetManagedMySqlDatabaseConfigurationDataFilter>
managedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
filters Changes to this property will trigger replacement. GetManagedMySqlDatabaseConfigurationDataFilter[]
managed_my_sql_database_id This property is required. str
The OCID of ManagedMySqlDatabase.
filters Changes to this property will trigger replacement. Sequence[databasemanagement.GetManagedMySqlDatabaseConfigurationDataFilter]
managedMySqlDatabaseId This property is required. String
The OCID of ManagedMySqlDatabase.
filters Changes to this property will trigger replacement. List<Property Map>

getManagedMySqlDatabaseConfigurationData Result

The following output properties are available:

id String
The provider-assigned unique ID for this managed resource.
managedMySqlDatabaseId String
mySqlConfigurationDataCollections List<Property Map>
The list of my_sql_configuration_data_collection.
filters List<Property Map>

Supporting Types

GetManagedMySqlDatabaseConfigurationDataFilter

Name This property is required. string
The name of variable
Values This property is required. List<string>
Regex bool
Name This property is required. string
The name of variable
Values This property is required. []string
Regex bool
name This property is required. String
The name of variable
values This property is required. List<String>
regex Boolean
name This property is required. string
The name of variable
values This property is required. string[]
regex boolean
name This property is required. str
The name of variable
values This property is required. Sequence[str]
regex bool
name This property is required. String
The name of variable
values This property is required. List<String>
regex Boolean

GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollection

Items This property is required. List<GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollectionItem>
List of ConfigurationDataSummary.
Items This property is required. []GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollectionItem
List of ConfigurationDataSummary.
items This property is required. List<GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollectionItem>
List of ConfigurationDataSummary.
items This property is required. GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollectionItem[]
List of ConfigurationDataSummary.
items This property is required. List<Property Map>
List of ConfigurationDataSummary.

GetManagedMySqlDatabaseConfigurationDataMySqlConfigurationDataCollectionItem

DefaultValue This property is required. string
default value of variable
Description This property is required. string
Description of the variable
HostSet This property is required. string
Host from where this value was set. Empty for MySql Database System
IsConfigurable This property is required. bool
Whether this variable is configurable
IsDynamic This property is required. bool
Whether variable can be set dynamically or not
IsInit This property is required. bool
whether variable is set at server startup
MaxValue This property is required. double
Maximum value of variable
MinValue This property is required. double
Minimum value of variable
Name This property is required. string
The name of variable
Path This property is required. string
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
PossibleValues This property is required. string
Comma separated list of possible values for the variable in value:valueDescription format
Source This property is required. string
The source from which the variable was most recently set
SupportedVersions This property is required. string
Comma separated list of MySql versions where this variable is supported
TimeSet This property is required. string
Time when value was set
Type This property is required. string
type of variable
UserSet This property is required. string
User who set this value. Empty for MySql Database System
Value This property is required. string
The value of variable
DefaultValue This property is required. string
default value of variable
Description This property is required. string
Description of the variable
HostSet This property is required. string
Host from where this value was set. Empty for MySql Database System
IsConfigurable This property is required. bool
Whether this variable is configurable
IsDynamic This property is required. bool
Whether variable can be set dynamically or not
IsInit This property is required. bool
whether variable is set at server startup
MaxValue This property is required. float64
Maximum value of variable
MinValue This property is required. float64
Minimum value of variable
Name This property is required. string
The name of variable
Path This property is required. string
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
PossibleValues This property is required. string
Comma separated list of possible values for the variable in value:valueDescription format
Source This property is required. string
The source from which the variable was most recently set
SupportedVersions This property is required. string
Comma separated list of MySql versions where this variable is supported
TimeSet This property is required. string
Time when value was set
Type This property is required. string
type of variable
UserSet This property is required. string
User who set this value. Empty for MySql Database System
Value This property is required. string
The value of variable
defaultValue This property is required. String
default value of variable
description This property is required. String
Description of the variable
hostSet This property is required. String
Host from where this value was set. Empty for MySql Database System
isConfigurable This property is required. Boolean
Whether this variable is configurable
isDynamic This property is required. Boolean
Whether variable can be set dynamically or not
isInit This property is required. Boolean
whether variable is set at server startup
maxValue This property is required. Double
Maximum value of variable
minValue This property is required. Double
Minimum value of variable
name This property is required. String
The name of variable
path This property is required. String
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
possibleValues This property is required. String
Comma separated list of possible values for the variable in value:valueDescription format
source This property is required. String
The source from which the variable was most recently set
supportedVersions This property is required. String
Comma separated list of MySql versions where this variable is supported
timeSet This property is required. String
Time when value was set
type This property is required. String
type of variable
userSet This property is required. String
User who set this value. Empty for MySql Database System
value This property is required. String
The value of variable
defaultValue This property is required. string
default value of variable
description This property is required. string
Description of the variable
hostSet This property is required. string
Host from where this value was set. Empty for MySql Database System
isConfigurable This property is required. boolean
Whether this variable is configurable
isDynamic This property is required. boolean
Whether variable can be set dynamically or not
isInit This property is required. boolean
whether variable is set at server startup
maxValue This property is required. number
Maximum value of variable
minValue This property is required. number
Minimum value of variable
name This property is required. string
The name of variable
path This property is required. string
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
possibleValues This property is required. string
Comma separated list of possible values for the variable in value:valueDescription format
source This property is required. string
The source from which the variable was most recently set
supportedVersions This property is required. string
Comma separated list of MySql versions where this variable is supported
timeSet This property is required. string
Time when value was set
type This property is required. string
type of variable
userSet This property is required. string
User who set this value. Empty for MySql Database System
value This property is required. string
The value of variable
default_value This property is required. str
default value of variable
description This property is required. str
Description of the variable
host_set This property is required. str
Host from where this value was set. Empty for MySql Database System
is_configurable This property is required. bool
Whether this variable is configurable
is_dynamic This property is required. bool
Whether variable can be set dynamically or not
is_init This property is required. bool
whether variable is set at server startup
max_value This property is required. float
Maximum value of variable
min_value This property is required. float
Minimum value of variable
name This property is required. str
The name of variable
path This property is required. str
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
possible_values This property is required. str
Comma separated list of possible values for the variable in value:valueDescription format
source This property is required. str
The source from which the variable was most recently set
supported_versions This property is required. str
Comma separated list of MySql versions where this variable is supported
time_set This property is required. str
Time when value was set
type This property is required. str
type of variable
user_set This property is required. str
User who set this value. Empty for MySql Database System
value This property is required. str
The value of variable
defaultValue This property is required. String
default value of variable
description This property is required. String
Description of the variable
hostSet This property is required. String
Host from where this value was set. Empty for MySql Database System
isConfigurable This property is required. Boolean
Whether this variable is configurable
isDynamic This property is required. Boolean
Whether variable can be set dynamically or not
isInit This property is required. Boolean
whether variable is set at server startup
maxValue This property is required. Number
Maximum value of variable
minValue This property is required. Number
Minimum value of variable
name This property is required. String
The name of variable
path This property is required. String
If the variable was set from an option file, VARIABLE_PATH is the path name of that file. Otherwise, the value is the empty string.
possibleValues This property is required. String
Comma separated list of possible values for the variable in value:valueDescription format
source This property is required. String
The source from which the variable was most recently set
supportedVersions This property is required. String
Comma separated list of MySql versions where this variable is supported
timeSet This property is required. String
Time when value was set
type This property is required. String
type of variable
userSet This property is required. String
User who set this value. Empty for MySql Database System
value This property is required. String
The value of variable

Package Details

Repository
oci pulumi/pulumi-oci
License
Apache-2.0
Notes
This Pulumi package is based on the oci Terraform Provider.