Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabases
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedMySqlDatabases

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

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

    Gets the list of Managed MySQL Databases in a specific compartment.

    Example Usage

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

const testManagedMySqlDatabases = oci.DatabaseManagement.getManagedMySqlDatabases({
    compartmentId: compartmentId,
    filterByMySqlDatabaseTypeParam: managedMySqlDatabaseFilterByMySqlDatabaseTypeParam,
});

    import pulumi
import pulumi_oci as oci

test_managed_my_sql_databases = oci.DatabaseManagement.get_managed_my_sql_databases(compartment_id=compartment_id,
    filter_by_my_sql_database_type_param=managed_my_sql_database_filter_by_my_sql_database_type_param)

    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.GetManagedMySqlDatabases(ctx, &databasemanagement.GetManagedMySqlDatabasesArgs{
			CompartmentId:                  compartmentId,
			FilterByMySqlDatabaseTypeParam: pulumi.StringRef(managedMySqlDatabaseFilterByMySqlDatabaseTypeParam),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedMySqlDatabases = Oci.DatabaseManagement.GetManagedMySqlDatabases.Invoke(new()
    {
        CompartmentId = compartmentId,
        FilterByMySqlDatabaseTypeParam = managedMySqlDatabaseFilterByMySqlDatabaseTypeParam,
    });

});

    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.GetManagedMySqlDatabasesArgs;
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 testManagedMySqlDatabases = DatabaseManagementFunctions.getManagedMySqlDatabases(GetManagedMySqlDatabasesArgs.builder()
            .compartmentId(compartmentId)
            .filterByMySqlDatabaseTypeParam(managedMySqlDatabaseFilterByMySqlDatabaseTypeParam)
            .build());

    }
}

    variables:
  testManagedMySqlDatabases:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedMySqlDatabases
      arguments:
        compartmentId: ${compartmentId}
        filterByMySqlDatabaseTypeParam: ${managedMySqlDatabaseFilterByMySqlDatabaseTypeParam}

    Using getManagedMySqlDatabases

    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 getManagedMySqlDatabases(args: GetManagedMySqlDatabasesArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabasesResult>
function getManagedMySqlDatabasesOutput(args: GetManagedMySqlDatabasesOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabasesResult>
    def get_managed_my_sql_databases(compartment_id: Optional[str] = None,
                                 filter_by_my_sql_database_type_param: Optional[str] = None,
                                 filters: Optional[Sequence[_databasemanagement.GetManagedMySqlDatabasesFilter]] = None,
                                 opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabasesResult
def get_managed_my_sql_databases_output(compartment_id: Optional[pulumi.Input[str]] = None,
                                 filter_by_my_sql_database_type_param: Optional[pulumi.Input[str]] = None,
                                 filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedMySqlDatabasesFilterArgs]]]] = None,
                                 opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabasesResult]
    func GetManagedMySqlDatabases(ctx *Context, args *GetManagedMySqlDatabasesArgs, opts ...InvokeOption) (*GetManagedMySqlDatabasesResult, error)
func GetManagedMySqlDatabasesOutput(ctx *Context, args *GetManagedMySqlDatabasesOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabasesResultOutput

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

    public static class GetManagedMySqlDatabases 
{
    public static Task<GetManagedMySqlDatabasesResult> InvokeAsync(GetManagedMySqlDatabasesArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedMySqlDatabasesResult> Invoke(GetManagedMySqlDatabasesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedMySqlDatabasesResult> getManagedMySqlDatabases(GetManagedMySqlDatabasesArgs args, InvokeOptions options)
public static Output<GetManagedMySqlDatabasesResult> getManagedMySqlDatabases(GetManagedMySqlDatabasesArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseManagement/getManagedMySqlDatabases:getManagedMySqlDatabases
  arguments:
    # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    The OCID of the compartment.
    FilterByMySqlDatabaseTypeParam string
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    Filters List<GetManagedMySqlDatabasesFilter>
    CompartmentId string
    The OCID of the compartment.
    FilterByMySqlDatabaseTypeParam string
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    Filters []GetManagedMySqlDatabasesFilter
    compartmentId String
    The OCID of the compartment.
    filterByMySqlDatabaseTypeParam String
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    filters List<GetManagedMySqlDatabasesFilter>
    compartmentId string
    The OCID of the compartment.
    filterByMySqlDatabaseTypeParam string
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    filters GetManagedMySqlDatabasesFilter[]
    compartment_id str
    The OCID of the compartment.
    filter_by_my_sql_database_type_param str
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    filters Sequence[databasemanagement.GetManagedMySqlDatabasesFilter]
    compartmentId String
    The OCID of the compartment.
    filterByMySqlDatabaseTypeParam String
    The parameter to filter by MySQL database type. Allowed values are EXTERNAL or MDS.
    filters List<Property Map>

    getManagedMySqlDatabases Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment.
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedMySqlDatabaseCollections List<GetManagedMySqlDatabasesManagedMySqlDatabaseCollection>
    The list of managed_my_sql_database_collection.
    FilterByMySqlDatabaseTypeParam string
    Filters List<GetManagedMySqlDatabasesFilter>
    CompartmentId string
    The OCID of the compartment.
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedMySqlDatabaseCollections []GetManagedMySqlDatabasesManagedMySqlDatabaseCollection
    The list of managed_my_sql_database_collection.
    FilterByMySqlDatabaseTypeParam string
    Filters []GetManagedMySqlDatabasesFilter
    compartmentId String
    The OCID of the compartment.
    id String
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseCollections List<GetManagedMySqlDatabasesManagedMySqlDatabaseCollection>
    The list of managed_my_sql_database_collection.
    filterByMySqlDatabaseTypeParam String
    filters List<GetManagedMySqlDatabasesFilter>
    compartmentId string
    The OCID of the compartment.
    id string
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseCollections GetManagedMySqlDatabasesManagedMySqlDatabaseCollection[]
    The list of managed_my_sql_database_collection.
    filterByMySqlDatabaseTypeParam string
    filters GetManagedMySqlDatabasesFilter[]
    compartmentId String
    The OCID of the compartment.
    id String
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseCollections List<Property Map>
    The list of managed_my_sql_database_collection.
    filterByMySqlDatabaseTypeParam String
    filters List<Property Map>

    Supporting Types

    GetManagedMySqlDatabasesFilter

    Name string
    The name of the Managed MySQL Database.
    Values List<string>
    Regex bool
    Name string
    The name of the Managed MySQL Database.
    Values []string
    Regex bool
    name String
    The name of the Managed MySQL Database.
    values List<String>
    regex Boolean
    name string
    The name of the Managed MySQL Database.
    values string[]
    regex boolean
    name str
    The name of the Managed MySQL Database.
    values Sequence[str]
    regex bool
    name String
    The name of the Managed MySQL Database.
    values List<String>
    regex Boolean

    GetManagedMySqlDatabasesManagedMySqlDatabaseCollection

    GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItem

    CompartmentId string
    The OCID of the compartment.
    DatabaseType string
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    DbName string
    The name of the MySQL Database.
    DbVersion string
    The version of the MySQL Database.
    HeatWaveClusterDisplayName string
    The name of the HeatWave cluster.
    HeatWaveMemorySize int
    The total memory belonging to the HeatWave cluster in GBs.
    HeatWaveNodeShape string
    Shape of the nodes in the HeatWave cluster.
    HeatWaveNodes List<GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode>
    The information about an individual HeatWave nodes in the cluster.
    Id string
    The ID associated with the HeatWave node.
    IsHeatWaveActive bool
    If the HeatWave cluster is active or not.
    IsHeatWaveEnabled bool
    If HeatWave is enabled for this db system or not.
    IsLakehouseEnabled bool
    If HeatWave Lakehouse is enabled for the db system or not.
    ManagementState string
    Indicates database management status.
    Name string
    The name of the Managed MySQL Database.
    State string
    TimeCreated string
    The date and time the node was created.
    TimeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    TimeUpdated string
    The date and time the Managed MySQL Database was updated.
    CompartmentId string
    The OCID of the compartment.
    DatabaseType string
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    DbName string
    The name of the MySQL Database.
    DbVersion string
    The version of the MySQL Database.
    HeatWaveClusterDisplayName string
    The name of the HeatWave cluster.
    HeatWaveMemorySize int
    The total memory belonging to the HeatWave cluster in GBs.
    HeatWaveNodeShape string
    Shape of the nodes in the HeatWave cluster.
    HeatWaveNodes []GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode
    The information about an individual HeatWave nodes in the cluster.
    Id string
    The ID associated with the HeatWave node.
    IsHeatWaveActive bool
    If the HeatWave cluster is active or not.
    IsHeatWaveEnabled bool
    If HeatWave is enabled for this db system or not.
    IsLakehouseEnabled bool
    If HeatWave Lakehouse is enabled for the db system or not.
    ManagementState string
    Indicates database management status.
    Name string
    The name of the Managed MySQL Database.
    State string
    TimeCreated string
    The date and time the node was created.
    TimeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    TimeUpdated string
    The date and time the Managed MySQL Database was updated.
    compartmentId String
    The OCID of the compartment.
    databaseType String
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    dbName String
    The name of the MySQL Database.
    dbVersion String
    The version of the MySQL Database.
    heatWaveClusterDisplayName String
    The name of the HeatWave cluster.
    heatWaveMemorySize Integer
    The total memory belonging to the HeatWave cluster in GBs.
    heatWaveNodeShape String
    Shape of the nodes in the HeatWave cluster.
    heatWaveNodes List<GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode>
    The information about an individual HeatWave nodes in the cluster.
    id String
    The ID associated with the HeatWave node.
    isHeatWaveActive Boolean
    If the HeatWave cluster is active or not.
    isHeatWaveEnabled Boolean
    If HeatWave is enabled for this db system or not.
    isLakehouseEnabled Boolean
    If HeatWave Lakehouse is enabled for the db system or not.
    managementState String
    Indicates database management status.
    name String
    The name of the Managed MySQL Database.
    state String
    timeCreated String
    The date and time the node was created.
    timeCreatedHeatWave String
    The date and time the Managed MySQL Database was created.
    timeUpdated String
    The date and time the Managed MySQL Database was updated.
    compartmentId string
    The OCID of the compartment.
    databaseType string
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    dbName string
    The name of the MySQL Database.
    dbVersion string
    The version of the MySQL Database.
    heatWaveClusterDisplayName string
    The name of the HeatWave cluster.
    heatWaveMemorySize number
    The total memory belonging to the HeatWave cluster in GBs.
    heatWaveNodeShape string
    Shape of the nodes in the HeatWave cluster.
    heatWaveNodes GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode[]
    The information about an individual HeatWave nodes in the cluster.
    id string
    The ID associated with the HeatWave node.
    isHeatWaveActive boolean
    If the HeatWave cluster is active or not.
    isHeatWaveEnabled boolean
    If HeatWave is enabled for this db system or not.
    isLakehouseEnabled boolean
    If HeatWave Lakehouse is enabled for the db system or not.
    managementState string
    Indicates database management status.
    name string
    The name of the Managed MySQL Database.
    state string
    timeCreated string
    The date and time the node was created.
    timeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    timeUpdated string
    The date and time the Managed MySQL Database was updated.
    compartment_id str
    The OCID of the compartment.
    database_type str
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    db_name str
    The name of the MySQL Database.
    db_version str
    The version of the MySQL Database.
    heat_wave_cluster_display_name str
    The name of the HeatWave cluster.
    heat_wave_memory_size int
    The total memory belonging to the HeatWave cluster in GBs.
    heat_wave_node_shape str
    Shape of the nodes in the HeatWave cluster.
    heat_wave_nodes Sequence[databasemanagement.GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode]
    The information about an individual HeatWave nodes in the cluster.
    id str
    The ID associated with the HeatWave node.
    is_heat_wave_active bool
    If the HeatWave cluster is active or not.
    is_heat_wave_enabled bool
    If HeatWave is enabled for this db system or not.
    is_lakehouse_enabled bool
    If HeatWave Lakehouse is enabled for the db system or not.
    management_state str
    Indicates database management status.
    name str
    The name of the Managed MySQL Database.
    state str
    time_created str
    The date and time the node was created.
    time_created_heat_wave str
    The date and time the Managed MySQL Database was created.
    time_updated str
    The date and time the Managed MySQL Database was updated.
    compartmentId String
    The OCID of the compartment.
    databaseType String
    The type of the MySQL Database. Indicates whether the database is external or MDS.
    dbName String
    The name of the MySQL Database.
    dbVersion String
    The version of the MySQL Database.
    heatWaveClusterDisplayName String
    The name of the HeatWave cluster.
    heatWaveMemorySize Number
    The total memory belonging to the HeatWave cluster in GBs.
    heatWaveNodeShape String
    Shape of the nodes in the HeatWave cluster.
    heatWaveNodes List<Property Map>
    The information about an individual HeatWave nodes in the cluster.
    id String
    The ID associated with the HeatWave node.
    isHeatWaveActive Boolean
    If the HeatWave cluster is active or not.
    isHeatWaveEnabled Boolean
    If HeatWave is enabled for this db system or not.
    isLakehouseEnabled Boolean
    If HeatWave Lakehouse is enabled for the db system or not.
    managementState String
    Indicates database management status.
    name String
    The name of the Managed MySQL Database.
    state String
    timeCreated String
    The date and time the node was created.
    timeCreatedHeatWave String
    The date and time the Managed MySQL Database was created.
    timeUpdated String
    The date and time the Managed MySQL Database was updated.

    GetManagedMySqlDatabasesManagedMySqlDatabaseCollectionItemHeatWaveNode

    Id string
    The ID associated with the HeatWave node.
    Status string
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    TimeCreated string
    The date and time the node was created.
    Id string
    The ID associated with the HeatWave node.
    Status string
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    TimeCreated string
    The date and time the node was created.
    id String
    The ID associated with the HeatWave node.
    status String
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    timeCreated String
    The date and time the node was created.
    id string
    The ID associated with the HeatWave node.
    status string
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    timeCreated string
    The date and time the node was created.
    id str
    The ID associated with the HeatWave node.
    status str
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    time_created str
    The date and time the node was created.
    id String
    The ID associated with the HeatWave node.
    status String
    The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
    timeCreated String
    The date and time the node was created.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
    pulumi/pulumi-oci