All fault domains details does not come for MySQL DB systems with High Availability

[bigdatasourav]

We have configured MySQL DB systems for High Availability; hence, it is deployed under multi-fault domain architecture. But the below APIs do not provide details of all the fault domains. It only provides information about the preferred one. https://pkg.go.dev/github.com/oracle/oci-go-sdk/[email protected]/mysql#DbSystemClient.ListDbSystems https://pkg.go.dev/github.com/oracle/oci-go-sdk/[email protected]/mysql#DbSystemClient.GetDbSystem

[KartikShrikantHegde]

Hi @bigdatasourav ,

Thanks for reporting the issue. We will ask the relevant team to take a look and provide an update.

[bigdatasourav]

Hey @KartikShrikantHegde, Could you please provide an update regarding the above?

[KartikShrikantHegde]

Hi @bigdatasourav ,

I have escalated the issue today and will provide an update as soon as I hear from the MySQL team. Also, do you have a Customer Support Identifier (CSI) number that you can share with us? That will help us get traction fast.

Thanks.

[jsled-at-oracle]

This is as designed.

The Availablity Domains and Fault Domains for a given region can be accessed through the ListAvailabilityDomains and ListFaultDomains operations on the identity module.

The ListDbSystem and GetDbSystem APIs here do return both the user-specified "preferred" placement (in availabilityDomain and faultDomain), and the currentPlacement of the DBSystem.