Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabaseHighAvailabilityMembers
Oracle Cloud Infrastructure v3.3.0 published on Thursday, Jul 17, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedMySqlDatabaseHighAvailabilityMembers

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v3.3.0 published on Thursday, Jul 17, 2025 by Pulumi
pulumi/pulumi-oci

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

    Information about high availability members of a specific MySQL server’s replication group.

    Example Usage

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

const testManagedMySqlDatabaseHighAvailabilityMembers = oci.DatabaseManagement.getManagedMySqlDatabaseHighAvailabilityMembers({
    managedMySqlDatabaseId: testManagedMySqlDatabase.id,
});

    import pulumi
import pulumi_oci as oci

test_managed_my_sql_database_high_availability_members = oci.DatabaseManagement.get_managed_my_sql_database_high_availability_members(managed_my_sql_database_id=test_managed_my_sql_database["id"])

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v3/go/oci/databasemanagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetManagedMySqlDatabaseHighAvailabilityMembers(ctx, &databasemanagement.GetManagedMySqlDatabaseHighAvailabilityMembersArgs{
			ManagedMySqlDatabaseId: testManagedMySqlDatabase.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 testManagedMySqlDatabaseHighAvailabilityMembers = Oci.DatabaseManagement.GetManagedMySqlDatabaseHighAvailabilityMembers.Invoke(new()
    {
        ManagedMySqlDatabaseId = testManagedMySqlDatabase.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.GetManagedMySqlDatabaseHighAvailabilityMembersArgs;
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 testManagedMySqlDatabaseHighAvailabilityMembers = DatabaseManagementFunctions.getManagedMySqlDatabaseHighAvailabilityMembers(GetManagedMySqlDatabaseHighAvailabilityMembersArgs.builder()
            .managedMySqlDatabaseId(testManagedMySqlDatabase.id())
            .build());

    }
}

    variables:
  testManagedMySqlDatabaseHighAvailabilityMembers:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedMySqlDatabaseHighAvailabilityMembers
      arguments:
        managedMySqlDatabaseId: ${testManagedMySqlDatabase.id}

    Using getManagedMySqlDatabaseHighAvailabilityMembers

    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 getManagedMySqlDatabaseHighAvailabilityMembers(args: GetManagedMySqlDatabaseHighAvailabilityMembersArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabaseHighAvailabilityMembersResult>
function getManagedMySqlDatabaseHighAvailabilityMembersOutput(args: GetManagedMySqlDatabaseHighAvailabilityMembersOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabaseHighAvailabilityMembersResult>
    def get_managed_my_sql_database_high_availability_members(filters: Optional[Sequence[GetManagedMySqlDatabaseHighAvailabilityMembersFilter]] = None,
                                                          managed_my_sql_database_id: Optional[str] = None,
                                                          opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabaseHighAvailabilityMembersResult
def get_managed_my_sql_database_high_availability_members_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetManagedMySqlDatabaseHighAvailabilityMembersFilterArgs]]]] = None,
                                                          managed_my_sql_database_id: Optional[pulumi.Input[str]] = None,
                                                          opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabaseHighAvailabilityMembersResult]
    func GetManagedMySqlDatabaseHighAvailabilityMembers(ctx *Context, args *GetManagedMySqlDatabaseHighAvailabilityMembersArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseHighAvailabilityMembersResult, error)
func GetManagedMySqlDatabaseHighAvailabilityMembersOutput(ctx *Context, args *GetManagedMySqlDatabaseHighAvailabilityMembersOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseHighAvailabilityMembersResultOutput

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

    public static class GetManagedMySqlDatabaseHighAvailabilityMembers 
{
    public static Task<GetManagedMySqlDatabaseHighAvailabilityMembersResult> InvokeAsync(GetManagedMySqlDatabaseHighAvailabilityMembersArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedMySqlDatabaseHighAvailabilityMembersResult> Invoke(GetManagedMySqlDatabaseHighAvailabilityMembersInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedMySqlDatabaseHighAvailabilityMembersResult> getManagedMySqlDatabaseHighAvailabilityMembers(GetManagedMySqlDatabaseHighAvailabilityMembersArgs args, InvokeOptions options)
public static Output<GetManagedMySqlDatabaseHighAvailabilityMembersResult> getManagedMySqlDatabaseHighAvailabilityMembers(GetManagedMySqlDatabaseHighAvailabilityMembersArgs args, InvokeOptions options)

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

    The following arguments are supported:

    managedMySqlDatabaseId String
    The OCID of the Managed MySQL Database.
    filters List<Property Map>

    getManagedMySqlDatabaseHighAvailabilityMembers Result

    The following output properties are available:

    id String
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseHighAvailabilityMemberCollections List<Property Map>
    The list of managed_my_sql_database_high_availability_member_collection.
    managedMySqlDatabaseId String
    filters List<Property Map>

    Supporting Types

    GetManagedMySqlDatabaseHighAvailabilityMembersFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollection

    FlowControl string
    The mode used for flow control.
    GroupAutoIncrement int
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    GroupName string
    The name of the group to which this server instance belongs.
    Items List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem>
    A list of MySqlHighAvailabilityMember records.
    MemberRole string
    The role of this server as a group replication member.
    MemberState string
    The state of this server as a group replication member.
    SinglePrimaryMode string
    Indicates if the replication group is running in single-primary mode.
    StatusSummaries List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary>
    High availability status summary of a MySQL server.
    TransactionsInGtidExecuted string
    Number of transactions that were replicated within the cluster.
    ViewId string
    The current view identifier for this group.
    FlowControl string
    The mode used for flow control.
    GroupAutoIncrement int
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    GroupName string
    The name of the group to which this server instance belongs.
    Items []GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem
    A list of MySqlHighAvailabilityMember records.
    MemberRole string
    The role of this server as a group replication member.
    MemberState string
    The state of this server as a group replication member.
    SinglePrimaryMode string
    Indicates if the replication group is running in single-primary mode.
    StatusSummaries []GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary
    High availability status summary of a MySQL server.
    TransactionsInGtidExecuted string
    Number of transactions that were replicated within the cluster.
    ViewId string
    The current view identifier for this group.
    flowControl String
    The mode used for flow control.
    groupAutoIncrement Integer
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    groupName String
    The name of the group to which this server instance belongs.
    items List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem>
    A list of MySqlHighAvailabilityMember records.
    memberRole String
    The role of this server as a group replication member.
    memberState String
    The state of this server as a group replication member.
    singlePrimaryMode String
    Indicates if the replication group is running in single-primary mode.
    statusSummaries List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary>
    High availability status summary of a MySQL server.
    transactionsInGtidExecuted String
    Number of transactions that were replicated within the cluster.
    viewId String
    The current view identifier for this group.
    flowControl string
    The mode used for flow control.
    groupAutoIncrement number
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    groupName string
    The name of the group to which this server instance belongs.
    items GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem[]
    A list of MySqlHighAvailabilityMember records.
    memberRole string
    The role of this server as a group replication member.
    memberState string
    The state of this server as a group replication member.
    singlePrimaryMode string
    Indicates if the replication group is running in single-primary mode.
    statusSummaries GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary[]
    High availability status summary of a MySQL server.
    transactionsInGtidExecuted string
    Number of transactions that were replicated within the cluster.
    viewId string
    The current view identifier for this group.
    flow_control str
    The mode used for flow control.
    group_auto_increment int
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    group_name str
    The name of the group to which this server instance belongs.
    items Sequence[GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem]
    A list of MySqlHighAvailabilityMember records.
    member_role str
    The role of this server as a group replication member.
    member_state str
    The state of this server as a group replication member.
    single_primary_mode str
    Indicates if the replication group is running in single-primary mode.
    status_summaries Sequence[GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary]
    High availability status summary of a MySQL server.
    transactions_in_gtid_executed str
    Number of transactions that were replicated within the cluster.
    view_id str
    The current view identifier for this group.
    flowControl String
    The mode used for flow control.
    groupAutoIncrement Number
    The interval between successive values for auto-incremented columns for transactions that execute on this server instance.
    groupName String
    The name of the group to which this server instance belongs.
    items List<Property Map>
    A list of MySqlHighAvailabilityMember records.
    memberRole String
    The role of this server as a group replication member.
    memberState String
    The state of this server as a group replication member.
    singlePrimaryMode String
    Indicates if the replication group is running in single-primary mode.
    statusSummaries List<Property Map>
    High availability status summary of a MySQL server.
    transactionsInGtidExecuted String
    Number of transactions that were replicated within the cluster.
    viewId String
    The current view identifier for this group.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionItem

    MemberHost string
    The host name of the group member which clients use to connect to it.
    MemberPort int
    The port number of the group member which clients to connect to it.
    MemberRole string
    The role of this server as a group replication member.
    MemberState string
    The state of this server as a group replication member.
    MemberUuid string
    The Universally Unique Identifier (UUID) of the member server.
    MemberHost string
    The host name of the group member which clients use to connect to it.
    MemberPort int
    The port number of the group member which clients to connect to it.
    MemberRole string
    The role of this server as a group replication member.
    MemberState string
    The state of this server as a group replication member.
    MemberUuid string
    The Universally Unique Identifier (UUID) of the member server.
    memberHost String
    The host name of the group member which clients use to connect to it.
    memberPort Integer
    The port number of the group member which clients to connect to it.
    memberRole String
    The role of this server as a group replication member.
    memberState String
    The state of this server as a group replication member.
    memberUuid String
    The Universally Unique Identifier (UUID) of the member server.
    memberHost string
    The host name of the group member which clients use to connect to it.
    memberPort number
    The port number of the group member which clients to connect to it.
    memberRole string
    The role of this server as a group replication member.
    memberState string
    The state of this server as a group replication member.
    memberUuid string
    The Universally Unique Identifier (UUID) of the member server.
    member_host str
    The host name of the group member which clients use to connect to it.
    member_port int
    The port number of the group member which clients to connect to it.
    member_role str
    The role of this server as a group replication member.
    member_state str
    The state of this server as a group replication member.
    member_uuid str
    The Universally Unique Identifier (UUID) of the member server.
    memberHost String
    The host name of the group member which clients use to connect to it.
    memberPort Number
    The port number of the group member which clients to connect to it.
    memberRole String
    The role of this server as a group replication member.
    memberState String
    The state of this server as a group replication member.
    memberUuid String
    The Universally Unique Identifier (UUID) of the member server.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummary

    channelApplyErrors List<Property Map>
    A list of MySqlChannelApplyError records.
    channelFetchErrors List<Property Map>
    A list of MySqlChannelFetchError records.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyError

    ApplyErrors []GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyError
    Error from apply operation of a MySQL server replication channel.
    ChannelName string
    The name of the replication channel
    applyErrors GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyError[]
    Error from apply operation of a MySQL server replication channel.
    channelName string
    The name of the replication channel
    applyErrors List<Property Map>
    Error from apply operation of a MySQL server replication channel.
    channelName String
    The name of the replication channel

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyError

    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    WorkerErrors List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError>
    A list of MySqlApplyErrorWorker records.
    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    WorkerErrors []GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError
    A list of MySqlApplyErrorWorker records.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Integer
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.
    workerErrors List<GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError>
    A list of MySqlApplyErrorWorker records.
    lastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError string
    The timestamp when the most recent I/O error occurred.
    workerErrors GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError[]
    A list of MySqlApplyErrorWorker records.
    last_error_message str
    The error message of the most recent error that caused the I/O thread to stop.
    last_error_number int
    The error number of the most recent error that caused the I/O thread to stop.
    time_last_error str
    The timestamp when the most recent I/O error occurred.
    worker_errors Sequence[GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError]
    A list of MySqlApplyErrorWorker records.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.
    workerErrors List<Property Map>
    A list of MySqlApplyErrorWorker records.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelApplyErrorApplyErrorWorkerError

    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Integer
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError string
    The timestamp when the most recent I/O error occurred.
    last_error_message str
    The error message of the most recent error that caused the I/O thread to stop.
    last_error_number int
    The error number of the most recent error that caused the I/O thread to stop.
    time_last_error str
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelFetchError

    ChannelName string
    The name of the replication channel
    FetchErrors []GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelFetchErrorFetchError
    Error from fetch operation of a MySQL server replication channel.
    channelName string
    The name of the replication channel
    fetchErrors GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelFetchErrorFetchError[]
    Error from fetch operation of a MySQL server replication channel.
    channelName String
    The name of the replication channel
    fetchErrors List<Property Map>
    Error from fetch operation of a MySQL server replication channel.

    GetManagedMySqlDatabaseHighAvailabilityMembersManagedMySqlDatabaseHighAvailabilityMemberCollectionStatusSummaryChannelFetchErrorFetchError

    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    LastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    LastErrorNumber int
    The error number of the most recent error that caused the I/O thread to stop.
    TimeLastError string
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Integer
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage string
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError string
    The timestamp when the most recent I/O error occurred.
    last_error_message str
    The error message of the most recent error that caused the I/O thread to stop.
    last_error_number int
    The error number of the most recent error that caused the I/O thread to stop.
    time_last_error str
    The timestamp when the most recent I/O error occurred.
    lastErrorMessage String
    The error message of the most recent error that caused the I/O thread to stop.
    lastErrorNumber Number
    The error number of the most recent error that caused the I/O thread to stop.
    timeLastError String
    The timestamp when the most recent I/O error occurred.

    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 v3.3.0 published on Thursday, Jul 17, 2025 by Pulumi
    pulumi/pulumi-oci