1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabases
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabases

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

    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,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_my_sql_databases = oci.DatabaseManagement.get_managed_my_sql_databases(compartment_id=compartment_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.GetManagedMySqlDatabases(ctx, &databasemanagement.GetManagedMySqlDatabasesArgs{
    			CompartmentId: compartmentId,
    		}, 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,
        });
    
    });
    
    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)
                .build());
    
        }
    }
    
    variables:
      testManagedMySqlDatabases:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedMySqlDatabases
          Arguments:
            compartmentId: ${compartmentId}
    

    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,
                                     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,
                                     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)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedMySqlDatabases:getManagedMySqlDatabases
      arguments:
        # arguments dictionary

    The following arguments are supported:

    compartmentId String
    The OCID of the compartment.
    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.
    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.
    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.
    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.
    filters GetManagedMySqlDatabasesFilter[]
    compartment_id str
    The OCID of the compartment.
    id str
    The provider-assigned unique ID for this managed resource.
    managed_my_sql_database_collections Sequence[databasemanagement.GetManagedMySqlDatabasesManagedMySqlDatabaseCollection]
    The list of managed_my_sql_database_collection.
    filters Sequence[databasemanagement.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.
    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.
    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.
    Name string
    The name of the Managed MySQL Database.
    TimeCreated string
    The date and time the 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
    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.
    Name string
    The name of the Managed MySQL Database.
    TimeCreated string
    The date and time the 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
    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.
    name String
    The name of the Managed MySQL Database.
    timeCreated String
    The date and time the 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
    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.
    name string
    The name of the Managed MySQL Database.
    timeCreated string
    The date and time the 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
    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.
    name str
    The name of the Managed MySQL Database.
    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.
    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
    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.
    name String
    The name of the Managed MySQL Database.
    timeCreated String
    The date and time the node was created.
    timeCreatedHeatWave String
    The date and time the Managed MySQL Database was created.

    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.3.0 published on Wednesday, Jul 17, 2024 by Pulumi