1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabase
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabase

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

    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/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)
    // Output-based functions aren't available in Java yet
    
    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.
    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
    Name string
    The name of the Managed MySQL Database.
    TimeCreated string
    The date and time the HeatWave node was created.
    TimeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    CompartmentId string
    The OCID of the compartment.
    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
    Name string
    The name of the Managed MySQL Database.
    TimeCreated string
    The date and time the HeatWave node was created.
    TimeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    compartmentId String
    The OCID of the compartment.
    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
    name String
    The name of the Managed MySQL Database.
    timeCreated String
    The date and time the HeatWave node was created.
    timeCreatedHeatWave String
    The date and time the Managed MySQL Database was created.
    compartmentId string
    The OCID of the compartment.
    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
    name string
    The name of the Managed MySQL Database.
    timeCreated string
    The date and time the HeatWave node was created.
    timeCreatedHeatWave string
    The date and time the Managed MySQL Database was created.
    compartment_id str
    The OCID of the compartment.
    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
    name str
    The name of the Managed MySQL Database.
    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.
    compartmentId String
    The OCID of the compartment.
    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
    name String
    The name of the Managed MySQL Database.
    timeCreated String
    The date and time the HeatWave node was created.
    timeCreatedHeatWave String
    The date and time the Managed MySQL Database was created.

    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 v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi