Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabase
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedMySqlDatabase

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Managed My Sql Database resource in Oracle Cloud Infrastructure Database Management service.

    Retrieves General Information for given MySQL Instance.

    Example Usage

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

const testManagedMySqlDatabase = oci.DatabaseManagement.getManagedMySqlDatabase({
    managedMySqlDatabaseId: testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.id,
});

    import pulumi
import pulumi_oci as oci

test_managed_my_sql_database = oci.DatabaseManagement.get_managed_my_sql_database(managed_my_sql_database_id=test_managed_my_sql_database_oci_database_management_managed_my_sql_database["id"])

    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.GetManagedMySqlDatabase(ctx, &databasemanagement.GetManagedMySqlDatabaseArgs{
			ManagedMySqlDatabaseId: testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.Id,
		}, 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 testManagedMySqlDatabase = Oci.DatabaseManagement.GetManagedMySqlDatabase.Invoke(new()
    {
        ManagedMySqlDatabaseId = testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.Id,
    });

});

    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.GetManagedMySqlDatabaseArgs;
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 testManagedMySqlDatabase = DatabaseManagementFunctions.getManagedMySqlDatabase(GetManagedMySqlDatabaseArgs.builder()
            .managedMySqlDatabaseId(testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.id())
            .build());

    }
}

    variables:
  testManagedMySqlDatabase:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedMySqlDatabase
      arguments:
        managedMySqlDatabaseId: ${testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.id}

    Using getManagedMySqlDatabase

    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 getManagedMySqlDatabase(args: GetManagedMySqlDatabaseArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabaseResult>
function getManagedMySqlDatabaseOutput(args: GetManagedMySqlDatabaseOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabaseResult>
    def get_managed_my_sql_database(managed_my_sql_database_id: Optional[str] = None,
                                opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabaseResult
def get_managed_my_sql_database_output(managed_my_sql_database_id: Optional[pulumi.Input[str]] = None,
                                opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabaseResult]
    func GetManagedMySqlDatabase(ctx *Context, args *GetManagedMySqlDatabaseArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseResult, error)
func GetManagedMySqlDatabaseOutput(ctx *Context, args *GetManagedMySqlDatabaseOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseResultOutput

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

    public static class GetManagedMySqlDatabase 
{
    public static Task<GetManagedMySqlDatabaseResult> InvokeAsync(GetManagedMySqlDatabaseArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedMySqlDatabaseResult> Invoke(GetManagedMySqlDatabaseInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedMySqlDatabaseResult> getManagedMySqlDatabase(GetManagedMySqlDatabaseArgs args, InvokeOptions options)
public static Output<GetManagedMySqlDatabaseResult> getManagedMySqlDatabase(GetManagedMySqlDatabaseArgs args, InvokeOptions options)

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

    The following arguments are supported:

    ManagedMySqlDatabaseId string
    The OCID of ManagedMySqlDatabase.
    ManagedMySqlDatabaseId string
    The OCID of ManagedMySqlDatabase.
    managedMySqlDatabaseId String
    The OCID of ManagedMySqlDatabase.
    managedMySqlDatabaseId string
    The OCID of ManagedMySqlDatabase.
    managed_my_sql_database_id str
    The OCID of ManagedMySqlDatabase.
    managedMySqlDatabaseId String
    The OCID of ManagedMySqlDatabase.

    getManagedMySqlDatabase Result

    The following output properties are available:

    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
    The shape of the nodes in the HeatWave cluster.
    HeatWaveNodes List<GetManagedMySqlDatabaseHeatWaveNode>
    The information about individual HeatWave nodes in the cluster.
    Id string
    The provider-assigned unique ID for this managed resource.
    IsHeatWaveActive bool
    Indicates whether the HeatWave cluster is active or not.
    IsHeatWaveEnabled bool
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    IsLakehouseEnabled bool
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    ManagedMySqlDatabaseId string
    ManagementState string
    Indicates database management status.
    Name string
    The name of the Managed MySQL Database.
    State string
    Indicates lifecycle state of the resource.
    TimeCreated string
    The date and time the HeatWave 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
    The shape of the nodes in the HeatWave cluster.
    HeatWaveNodes []GetManagedMySqlDatabaseHeatWaveNode
    The information about individual HeatWave nodes in the cluster.
    Id string
    The provider-assigned unique ID for this managed resource.
    IsHeatWaveActive bool
    Indicates whether the HeatWave cluster is active or not.
    IsHeatWaveEnabled bool
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    IsLakehouseEnabled bool
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    ManagedMySqlDatabaseId string
    ManagementState string
    Indicates database management status.
    Name string
    The name of the Managed MySQL Database.
    State string
    Indicates lifecycle state of the resource.
    TimeCreated string
    The date and time the HeatWave 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
    The shape of the nodes in the HeatWave cluster.
    heatWaveNodes List<GetManagedMySqlDatabaseHeatWaveNode>
    The information about individual HeatWave nodes in the cluster.
    id String
    The provider-assigned unique ID for this managed resource.
    isHeatWaveActive Boolean
    Indicates whether the HeatWave cluster is active or not.
    isHeatWaveEnabled Boolean
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    isLakehouseEnabled Boolean
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    managedMySqlDatabaseId String
    managementState String
    Indicates database management status.
    name String
    The name of the Managed MySQL Database.
    state String
    Indicates lifecycle state of the resource.
    timeCreated String
    The date and time the HeatWave 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
    The shape of the nodes in the HeatWave cluster.
    heatWaveNodes GetManagedMySqlDatabaseHeatWaveNode[]
    The information about individual HeatWave nodes in the cluster.
    id string
    The provider-assigned unique ID for this managed resource.
    isHeatWaveActive boolean
    Indicates whether the HeatWave cluster is active or not.
    isHeatWaveEnabled boolean
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    isLakehouseEnabled boolean
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    managedMySqlDatabaseId string
    managementState string
    Indicates database management status.
    name string
    The name of the Managed MySQL Database.
    state string
    Indicates lifecycle state of the resource.
    timeCreated string
    The date and time the HeatWave 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
    The shape of the nodes in the HeatWave cluster.
    heat_wave_nodes Sequence[databasemanagement.GetManagedMySqlDatabaseHeatWaveNode]
    The information about individual HeatWave nodes in the cluster.
    id str
    The provider-assigned unique ID for this managed resource.
    is_heat_wave_active bool
    Indicates whether the HeatWave cluster is active or not.
    is_heat_wave_enabled bool
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    is_lakehouse_enabled bool
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    managed_my_sql_database_id str
    management_state str
    Indicates database management status.
    name str
    The name of the Managed MySQL Database.
    state str
    Indicates lifecycle state of the resource.
    time_created str
    The date and time the HeatWave 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
    The shape of the nodes in the HeatWave cluster.
    heatWaveNodes List<Property Map>
    The information about individual HeatWave nodes in the cluster.
    id String
    The provider-assigned unique ID for this managed resource.
    isHeatWaveActive Boolean
    Indicates whether the HeatWave cluster is active or not.
    isHeatWaveEnabled Boolean
    Indicates whether HeatWave is enabled for the MySQL Database System or not.
    isLakehouseEnabled Boolean
    Indicates whether HeatWave Lakehouse is enabled for the MySQL Database System or not.
    managedMySqlDatabaseId String
    managementState String
    Indicates database management status.
    name String
    The name of the Managed MySQL Database.
    state String
    Indicates lifecycle state of the resource.
    timeCreated String
    The date and time the HeatWave 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.

    Supporting Types

    GetManagedMySqlDatabaseHeatWaveNode

    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 HeatWave 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 HeatWave 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 HeatWave 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 HeatWave 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 HeatWave 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 HeatWave 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.31.0 published on Thursday, Apr 17, 2025 by Pulumi
    pulumi/pulumi-oci