1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabase
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabase

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 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,
});
Copy
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"])
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.GetManagedMySqlDatabase(ctx, &databasemanagement.GetManagedMySqlDatabaseArgs{
			ManagedMySqlDatabaseId: testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.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 testManagedMySqlDatabase = Oci.DatabaseManagement.GetManagedMySqlDatabase.Invoke(new()
    {
        ManagedMySqlDatabaseId = testManagedMySqlDatabaseOciDatabaseManagementManagedMySqlDatabase.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.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());

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

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>
Copy
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]
Copy
func GetManagedMySqlDatabase(ctx *Context, args *GetManagedMySqlDatabaseArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseResult, error)
func GetManagedMySqlDatabaseOutput(ctx *Context, args *GetManagedMySqlDatabaseOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetManagedMySqlDatabaseResult> getManagedMySqlDatabase(GetManagedMySqlDatabaseArgs args, InvokeOptions options)
public static Output<GetManagedMySqlDatabaseResult> getManagedMySqlDatabase(GetManagedMySqlDatabaseArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedMySqlDatabase:getManagedMySqlDatabase
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ManagedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
ManagedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
managedMySqlDatabaseId This property is required. String
The OCID of ManagedMySqlDatabase.
managedMySqlDatabaseId This property is required. string
The OCID of ManagedMySqlDatabase.
managed_my_sql_database_id This property is required. str
The OCID of ManagedMySqlDatabase.
managedMySqlDatabaseId This property is required. 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 This property is required. string
The ID associated with the HeatWave node.
Status This property is required. string
The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
TimeCreated This property is required. string
The date and time the HeatWave node was created.
Id This property is required. string
The ID associated with the HeatWave node.
Status This property is required. string
The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
TimeCreated This property is required. string
The date and time the HeatWave node was created.
id This property is required. String
The ID associated with the HeatWave node.
status This property is required. String
The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
timeCreated This property is required. String
The date and time the HeatWave node was created.
id This property is required. string
The ID associated with the HeatWave node.
status This property is required. string
The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
timeCreated This property is required. string
The date and time the HeatWave node was created.
id This property is required. str
The ID associated with the HeatWave node.
status This property is required. 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 This property is required. str
The date and time the HeatWave node was created.
id This property is required. String
The ID associated with the HeatWave node.
status This property is required. String
The status of the HeatWave node. Indicates whether the status of the node is UP, DOWN, or UNKNOWN at the current time.
timeCreated This property is required. 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.
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi