Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 by Pulumi
oci.Mysql.getMysqlDbSystems
Explore with Pulumi AI
This data source provides the list of Mysql Db Systems in Oracle Cloud Infrastructure MySQL Database service.
Get a list of DB Systems in the specified compartment. The default sort order is by timeUpdated, descending.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testMysqlDbSystems = oci.Mysql.getMysqlDbSystems({
compartmentId: compartmentId,
configurationId: mysqlConfigurationId,
databaseManagements: mysqlDbSystemDatabaseManagement,
dbSystemId: testDbSystem.id,
displayName: mysqlDbSystemDisplayName,
isHeatWaveClusterAttached: mysqlDbSystemIsHeatWaveClusterAttached,
isUpToDate: mysqlDbSystemIsUpToDate,
state: mysqlDbSystemState,
});
import pulumi
import pulumi_oci as oci
test_mysql_db_systems = oci.Mysql.get_mysql_db_systems(compartment_id=compartment_id,
configuration_id=mysql_configuration_id,
database_managements=mysql_db_system_database_management,
db_system_id=test_db_system["id"],
display_name=mysql_db_system_display_name,
is_heat_wave_cluster_attached=mysql_db_system_is_heat_wave_cluster_attached,
is_up_to_date=mysql_db_system_is_up_to_date,
state=mysql_db_system_state)
package main
import (
"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/Mysql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := Mysql.GetMysqlDbSystems(ctx, &mysql.GetMysqlDbSystemsArgs{
CompartmentId: compartmentId,
ConfigurationId: pulumi.StringRef(mysqlConfigurationId),
DatabaseManagements: mysqlDbSystemDatabaseManagement,
DbSystemId: pulumi.StringRef(testDbSystem.Id),
DisplayName: pulumi.StringRef(mysqlDbSystemDisplayName),
IsHeatWaveClusterAttached: pulumi.BoolRef(mysqlDbSystemIsHeatWaveClusterAttached),
IsUpToDate: pulumi.BoolRef(mysqlDbSystemIsUpToDate),
State: pulumi.StringRef(mysqlDbSystemState),
}, 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 testMysqlDbSystems = Oci.Mysql.GetMysqlDbSystems.Invoke(new()
{
CompartmentId = compartmentId,
ConfigurationId = mysqlConfigurationId,
DatabaseManagements = mysqlDbSystemDatabaseManagement,
DbSystemId = testDbSystem.Id,
DisplayName = mysqlDbSystemDisplayName,
IsHeatWaveClusterAttached = mysqlDbSystemIsHeatWaveClusterAttached,
IsUpToDate = mysqlDbSystemIsUpToDate,
State = mysqlDbSystemState,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlFunctions;
import com.pulumi.oci.Mysql.inputs.GetMysqlDbSystemsArgs;
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 testMysqlDbSystems = MysqlFunctions.getMysqlDbSystems(GetMysqlDbSystemsArgs.builder()
.compartmentId(compartmentId)
.configurationId(mysqlConfigurationId)
.databaseManagements(mysqlDbSystemDatabaseManagement)
.dbSystemId(testDbSystem.id())
.displayName(mysqlDbSystemDisplayName)
.isHeatWaveClusterAttached(mysqlDbSystemIsHeatWaveClusterAttached)
.isUpToDate(mysqlDbSystemIsUpToDate)
.state(mysqlDbSystemState)
.build());
}
}
variables:
testMysqlDbSystems:
fn::invoke:
Function: oci:Mysql:getMysqlDbSystems
Arguments:
compartmentId: ${compartmentId}
configurationId: ${mysqlConfigurationId}
databaseManagements: ${mysqlDbSystemDatabaseManagement}
dbSystemId: ${testDbSystem.id}
displayName: ${mysqlDbSystemDisplayName}
isHeatWaveClusterAttached: ${mysqlDbSystemIsHeatWaveClusterAttached}
isUpToDate: ${mysqlDbSystemIsUpToDate}
state: ${mysqlDbSystemState}
Using getMysqlDbSystems
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 getMysqlDbSystems(args: GetMysqlDbSystemsArgs, opts?: InvokeOptions): Promise<GetMysqlDbSystemsResult>
function getMysqlDbSystemsOutput(args: GetMysqlDbSystemsOutputArgs, opts?: InvokeOptions): Output<GetMysqlDbSystemsResult>
def get_mysql_db_systems(compartment_id: Optional[str] = None,
configuration_id: Optional[str] = None,
database_managements: Optional[Sequence[str]] = None,
db_system_id: Optional[str] = None,
display_name: Optional[str] = None,
filters: Optional[Sequence[_mysql.GetMysqlDbSystemsFilter]] = None,
is_heat_wave_cluster_attached: Optional[bool] = None,
is_up_to_date: Optional[bool] = None,
state: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetMysqlDbSystemsResult
def get_mysql_db_systems_output(compartment_id: Optional[pulumi.Input[str]] = None,
configuration_id: Optional[pulumi.Input[str]] = None,
database_managements: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
db_system_id: Optional[pulumi.Input[str]] = None,
display_name: Optional[pulumi.Input[str]] = None,
filters: Optional[pulumi.Input[Sequence[pulumi.Input[_mysql.GetMysqlDbSystemsFilterArgs]]]] = None,
is_heat_wave_cluster_attached: Optional[pulumi.Input[bool]] = None,
is_up_to_date: Optional[pulumi.Input[bool]] = None,
state: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetMysqlDbSystemsResult]
func GetMysqlDbSystems(ctx *Context, args *GetMysqlDbSystemsArgs, opts ...InvokeOption) (*GetMysqlDbSystemsResult, error)
func GetMysqlDbSystemsOutput(ctx *Context, args *GetMysqlDbSystemsOutputArgs, opts ...InvokeOption) GetMysqlDbSystemsResultOutput
> Note: This function is named GetMysqlDbSystems
in the Go SDK.
public static class GetMysqlDbSystems
{
public static Task<GetMysqlDbSystemsResult> InvokeAsync(GetMysqlDbSystemsArgs args, InvokeOptions? opts = null)
public static Output<GetMysqlDbSystemsResult> Invoke(GetMysqlDbSystemsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetMysqlDbSystemsResult> getMysqlDbSystems(GetMysqlDbSystemsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:Mysql/getMysqlDbSystems:getMysqlDbSystems
arguments:
# arguments dictionary
The following arguments are supported:
- Compartment
Id string - The compartment OCID.
- Configuration
Id string - The requested Configuration instance.
- Database
Managements List<string> - Filter DB Systems by their Database Management configuration.
- Db
System stringId - The DB System OCID.
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- Filters
List<Get
Mysql Db Systems Filter> - Is
Heat boolWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- Is
Up boolTo Date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- State string
- DbSystem Lifecycle State
- Compartment
Id string - The compartment OCID.
- Configuration
Id string - The requested Configuration instance.
- Database
Managements []string - Filter DB Systems by their Database Management configuration.
- Db
System stringId - The DB System OCID.
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- Filters
[]Get
Mysql Db Systems Filter - Is
Heat boolWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- Is
Up boolTo Date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- State string
- DbSystem Lifecycle State
- compartment
Id String - The compartment OCID.
- configuration
Id String - The requested Configuration instance.
- database
Managements List<String> - Filter DB Systems by their Database Management configuration.
- db
System StringId - The DB System OCID.
- display
Name String - A filter to return only the resource matching the given display name exactly.
- filters
List<Get
Db Systems Filter> - is
Heat BooleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Up BooleanTo Date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- state String
- DbSystem Lifecycle State
- compartment
Id string - The compartment OCID.
- configuration
Id string - The requested Configuration instance.
- database
Managements string[] - Filter DB Systems by their Database Management configuration.
- db
System stringId - The DB System OCID.
- display
Name string - A filter to return only the resource matching the given display name exactly.
- filters
Get
Mysql Db Systems Filter[] - is
Heat booleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Up booleanTo Date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- state string
- DbSystem Lifecycle State
- compartment_
id str - The compartment OCID.
- configuration_
id str - The requested Configuration instance.
- database_
managements Sequence[str] - Filter DB Systems by their Database Management configuration.
- db_
system_ strid - The DB System OCID.
- display_
name str - A filter to return only the resource matching the given display name exactly.
- filters
Sequence[mysql.
Get Mysql Db Systems Filter] - is_
heat_ boolwave_ cluster_ attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is_
up_ boolto_ date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- state str
- DbSystem Lifecycle State
- compartment
Id String - The compartment OCID.
- configuration
Id String - The requested Configuration instance.
- database
Managements List<String> - Filter DB Systems by their Database Management configuration.
- db
System StringId - The DB System OCID.
- display
Name String - A filter to return only the resource matching the given display name exactly.
- filters List<Property Map>
- is
Heat BooleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Up BooleanTo Date - Filter instances if they are using the latest revision of the Configuration they are associated with.
- state String
- DbSystem Lifecycle State
getMysqlDbSystems Result
The following output properties are available:
- Compartment
Id string - The OCID of the compartment the DB System belongs in.
- Db
Systems List<GetMysql Db Systems Db System> - The list of db_systems.
- Id string
- The provider-assigned unique ID for this managed resource.
- Configuration
Id string - The OCID of the Configuration to be used for Instances in this DB System.
- Database
Managements List<string> - Whether to enable monitoring via the Database Management service.
- Db
System stringId - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- Display
Name string - The user-friendly name for the DB System. It does not have to be unique.
- Filters
List<Get
Mysql Db Systems Filter> - Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Is
Up boolTo Date - State string
- The current state of the DB System.
- Compartment
Id string - The OCID of the compartment the DB System belongs in.
- Db
Systems []GetMysql Db Systems Db System - The list of db_systems.
- Id string
- The provider-assigned unique ID for this managed resource.
- Configuration
Id string - The OCID of the Configuration to be used for Instances in this DB System.
- Database
Managements []string - Whether to enable monitoring via the Database Management service.
- Db
System stringId - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- Display
Name string - The user-friendly name for the DB System. It does not have to be unique.
- Filters
[]Get
Mysql Db Systems Filter - Is
Heat boolWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- Is
Up boolTo Date - State string
- The current state of the DB System.
- compartment
Id String - The OCID of the compartment the DB System belongs in.
- db
Systems List<GetDb Systems Db System> - The list of db_systems.
- id String
- The provider-assigned unique ID for this managed resource.
- configuration
Id String - The OCID of the Configuration to be used for Instances in this DB System.
- database
Managements List<String> - Whether to enable monitoring via the Database Management service.
- db
System StringId - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- display
Name String - The user-friendly name for the DB System. It does not have to be unique.
- filters
List<Get
Db Systems Filter> - is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Up BooleanTo Date - state String
- The current state of the DB System.
- compartment
Id string - The OCID of the compartment the DB System belongs in.
- db
Systems GetMysql Db Systems Db System[] - The list of db_systems.
- id string
- The provider-assigned unique ID for this managed resource.
- configuration
Id string - The OCID of the Configuration to be used for Instances in this DB System.
- database
Managements string[] - Whether to enable monitoring via the Database Management service.
- db
System stringId - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- display
Name string - The user-friendly name for the DB System. It does not have to be unique.
- filters
Get
Mysql Db Systems Filter[] - is
Heat booleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Up booleanTo Date - state string
- The current state of the DB System.
- compartment_
id str - The OCID of the compartment the DB System belongs in.
- db_
systems Sequence[mysql.Get Mysql Db Systems Db System] - The list of db_systems.
- id str
- The provider-assigned unique ID for this managed resource.
- configuration_
id str - The OCID of the Configuration to be used for Instances in this DB System.
- database_
managements Sequence[str] - Whether to enable monitoring via the Database Management service.
- db_
system_ strid - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- display_
name str - The user-friendly name for the DB System. It does not have to be unique.
- filters
Sequence[mysql.
Get Mysql Db Systems Filter] - is_
heat_ boolwave_ cluster_ attached - If the DB System has a HeatWave Cluster attached.
- is_
up_ boolto_ date - state str
- The current state of the DB System.
- compartment
Id String - The OCID of the compartment the DB System belongs in.
- db
Systems List<Property Map> - The list of db_systems.
- id String
- The provider-assigned unique ID for this managed resource.
- configuration
Id String - The OCID of the Configuration to be used for Instances in this DB System.
- database
Managements List<String> - Whether to enable monitoring via the Database Management service.
- db
System StringId - The OCID of the DB System from which a backup shall be selected to be restored when creating the new DB System. Use this together with recovery point to perform a point in time recovery operation.
- display
Name String - The user-friendly name for the DB System. It does not have to be unique.
- filters List<Property Map>
- is
Heat BooleanWave Cluster Attached - If the DB System has a HeatWave Cluster attached.
- is
Up BooleanTo Date - state String
- The current state of the DB System.
Supporting Types
GetMysqlDbSystemsDbSystem
- Admin
Password string - Admin
Username string - Availability
Domain string - The availability domain in which the DB System is placed.
- Backup
Policies List<GetMysql Db Systems Db System Backup Policy> - The Backup policy for the DB System.
- Channels
List<Get
Mysql Db Systems Db System Channel> - A list with a summary of all the Channels attached to the DB System.
- Compartment
Id string - The compartment OCID.
- Configuration
Id string - The requested Configuration instance.
- Crash
Recovery string - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- Current
Placements List<GetMysql Db Systems Db System Current Placement> - The availability domain and fault domain a DB System is placed in.
- Customer
Contacts List<GetMysql Db Systems Db System Customer Contact> - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- Data
Storage intSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- Data
Storages List<GetMysql Db Systems Db System Data Storage> - Data Storage information.
- Database
Management string - Filter DB Systems by their Database Management configuration.
- Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies List<GetMysql Db Systems Db System Deletion Policy> - The Deletion policy for the DB System.
- Description string
- User-provided data about the DB System.
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- Endpoints
List<Get
Mysql Db Systems Db System Endpoint> - The network endpoints available for this DB System.
- Fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- Dictionary<string, string>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Heat
Wave List<GetClusters Mysql Db Systems Db System Heat Wave Cluster> - A summary of a HeatWave cluster.
- Hostname
Label string - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- Id string
- The OCID of the DB System.
- Ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- Is
Heat boolWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- Is
Highly boolAvailable - Specifies if the DB System is highly available.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Maintenances
List<Get
Mysql Db Systems Db System Maintenance> - The Maintenance Policy for the DB System or Read Replica that this model is included in.
- Mysql
Version string - Name of the MySQL Version in use for the DB System.
- Point
In List<GetTime Recovery Details Mysql Db Systems Db System Point In Time Recovery Detail> - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- Secure
Connections List<GetMysql Db Systems Db System Secure Connection> - Secure connection configuration details.
- Shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- Shutdown
Type string - Sources
List<Get
Mysql Db Systems Db System Source> - Parameters detailing how to provision the initial data of the DB System.
- State string
- DbSystem Lifecycle State
- Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Admin
Password string - Admin
Username string - Availability
Domain string - The availability domain in which the DB System is placed.
- Backup
Policies []GetMysql Db Systems Db System Backup Policy - The Backup policy for the DB System.
- Channels
[]Get
Mysql Db Systems Db System Channel - A list with a summary of all the Channels attached to the DB System.
- Compartment
Id string - The compartment OCID.
- Configuration
Id string - The requested Configuration instance.
- Crash
Recovery string - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- Current
Placements []GetMysql Db Systems Db System Current Placement - The availability domain and fault domain a DB System is placed in.
- Customer
Contacts []GetMysql Db Systems Db System Customer Contact - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- Data
Storage intSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- Data
Storages []GetMysql Db Systems Db System Data Storage - Data Storage information.
- Database
Management string - Filter DB Systems by their Database Management configuration.
- map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Deletion
Policies []GetMysql Db Systems Db System Deletion Policy - The Deletion policy for the DB System.
- Description string
- User-provided data about the DB System.
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- Endpoints
[]Get
Mysql Db Systems Db System Endpoint - The network endpoints available for this DB System.
- Fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- map[string]string
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Heat
Wave []GetClusters Mysql Db Systems Db System Heat Wave Cluster - A summary of a HeatWave cluster.
- Hostname
Label string - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- Id string
- The OCID of the DB System.
- Ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- Is
Heat boolWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- Is
Highly boolAvailable - Specifies if the DB System is highly available.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Maintenances
[]Get
Mysql Db Systems Db System Maintenance - The Maintenance Policy for the DB System or Read Replica that this model is included in.
- Mysql
Version string - Name of the MySQL Version in use for the DB System.
- Point
In []GetTime Recovery Details Mysql Db Systems Db System Point In Time Recovery Detail - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- Secure
Connections []GetMysql Db Systems Db System Secure Connection - Secure connection configuration details.
- Shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- Shutdown
Type string - Sources
[]Get
Mysql Db Systems Db System Source - Parameters detailing how to provision the initial data of the DB System.
- State string
- DbSystem Lifecycle State
- Subnet
Id string - The OCID of the subnet the DB System is associated with.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- admin
Password String - admin
Username String - availability
Domain String - The availability domain in which the DB System is placed.
- backup
Policies List<GetDb Systems Db System Backup Policy> - The Backup policy for the DB System.
- channels
List<Get
Db Systems Db System Channel> - A list with a summary of all the Channels attached to the DB System.
- compartment
Id String - The compartment OCID.
- configuration
Id String - The requested Configuration instance.
- crash
Recovery String - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- current
Placements List<GetDb Systems Db System Current Placement> - The availability domain and fault domain a DB System is placed in.
- customer
Contacts List<GetDb Systems Db System Customer Contact> - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- data
Storage IntegerSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storages List<GetDb Systems Db System Data Storage> - Data Storage information.
- database
Management String - Filter DB Systems by their Database Management configuration.
- Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies List<GetDb Systems Db System Deletion Policy> - The Deletion policy for the DB System.
- description String
- User-provided data about the DB System.
- display
Name String - A filter to return only the resource matching the given display name exactly.
- endpoints
List<Get
Db Systems Db System Endpoint> - The network endpoints available for this DB System.
- fault
Domain String - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- Map<String,String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- heat
Wave List<GetClusters Db Systems Db System Heat Wave Cluster> - A summary of a HeatWave cluster.
- hostname
Label String - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- id String
- The OCID of the DB System.
- ip
Address String - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- is
Heat BooleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Highly BooleanAvailable - Specifies if the DB System is highly available.
- lifecycle
Details String - Additional information about the current lifecycleState.
- maintenances
List<Get
Db Systems Db System Maintenance> - The Maintenance Policy for the DB System or Read Replica that this model is included in.
- mysql
Version String - Name of the MySQL Version in use for the DB System.
- point
In List<GetTime Recovery Details Db Systems Db System Point In Time Recovery Detail> - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- port Integer
- The port for primary endpoint of the DB System to listen on.
- port
X Integer - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- secure
Connections List<GetDb Systems Db System Secure Connection> - Secure connection configuration details.
- shape
Name String - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- shutdown
Type String - sources
List<Get
Db Systems Db System Source> - Parameters detailing how to provision the initial data of the DB System.
- state String
- DbSystem Lifecycle State
- subnet
Id String - The OCID of the subnet the DB System is associated with.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- admin
Password string - admin
Username string - availability
Domain string - The availability domain in which the DB System is placed.
- backup
Policies GetMysql Db Systems Db System Backup Policy[] - The Backup policy for the DB System.
- channels
Get
Mysql Db Systems Db System Channel[] - A list with a summary of all the Channels attached to the DB System.
- compartment
Id string - The compartment OCID.
- configuration
Id string - The requested Configuration instance.
- crash
Recovery string - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- current
Placements GetMysql Db Systems Db System Current Placement[] - The availability domain and fault domain a DB System is placed in.
- customer
Contacts GetMysql Db Systems Db System Customer Contact[] - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- data
Storage numberSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storages GetMysql Db Systems Db System Data Storage[] - Data Storage information.
- database
Management string - Filter DB Systems by their Database Management configuration.
- {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies GetMysql Db Systems Db System Deletion Policy[] - The Deletion policy for the DB System.
- description string
- User-provided data about the DB System.
- display
Name string - A filter to return only the resource matching the given display name exactly.
- endpoints
Get
Mysql Db Systems Db System Endpoint[] - The network endpoints available for this DB System.
- fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- {[key: string]: string}
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- heat
Wave GetClusters Mysql Db Systems Db System Heat Wave Cluster[] - A summary of a HeatWave cluster.
- hostname
Label string - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- id string
- The OCID of the DB System.
- ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- is
Heat booleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Highly booleanAvailable - Specifies if the DB System is highly available.
- lifecycle
Details string - Additional information about the current lifecycleState.
- maintenances
Get
Mysql Db Systems Db System Maintenance[] - The Maintenance Policy for the DB System or Read Replica that this model is included in.
- mysql
Version string - Name of the MySQL Version in use for the DB System.
- point
In GetTime Recovery Details Mysql Db Systems Db System Point In Time Recovery Detail[] - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- port number
- The port for primary endpoint of the DB System to listen on.
- port
X number - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- secure
Connections GetMysql Db Systems Db System Secure Connection[] - Secure connection configuration details.
- shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- shutdown
Type string - sources
Get
Mysql Db Systems Db System Source[] - Parameters detailing how to provision the initial data of the DB System.
- state string
- DbSystem Lifecycle State
- subnet
Id string - The OCID of the subnet the DB System is associated with.
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- admin_
password str - admin_
username str - availability_
domain str - The availability domain in which the DB System is placed.
- backup_
policies Sequence[mysql.Get Mysql Db Systems Db System Backup Policy] - The Backup policy for the DB System.
- channels
Sequence[mysql.
Get Mysql Db Systems Db System Channel] - A list with a summary of all the Channels attached to the DB System.
- compartment_
id str - The compartment OCID.
- configuration_
id str - The requested Configuration instance.
- crash_
recovery str - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- current_
placements Sequence[mysql.Get Mysql Db Systems Db System Current Placement] - The availability domain and fault domain a DB System is placed in.
- customer_
contacts Sequence[mysql.Get Mysql Db Systems Db System Customer Contact] - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- data_
storage_ intsize_ in_ gb - Initial size of the data volume in GiBs that will be created and attached.
- data_
storages Sequence[mysql.Get Mysql Db Systems Db System Data Storage] - Data Storage information.
- database_
management str - Filter DB Systems by their Database Management configuration.
- Mapping[str, str]
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deletion_
policies Sequence[mysql.Get Mysql Db Systems Db System Deletion Policy] - The Deletion policy for the DB System.
- description str
- User-provided data about the DB System.
- display_
name str - A filter to return only the resource matching the given display name exactly.
- endpoints
Sequence[mysql.
Get Mysql Db Systems Db System Endpoint] - The network endpoints available for this DB System.
- fault_
domain str - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- Mapping[str, str]
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- heat_
wave_ Sequence[mysql.clusters Get Mysql Db Systems Db System Heat Wave Cluster] - A summary of a HeatWave cluster.
- hostname_
label str - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- id str
- The OCID of the DB System.
- ip_
address str - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- is_
heat_ boolwave_ cluster_ attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is_
highly_ boolavailable - Specifies if the DB System is highly available.
- lifecycle_
details str - Additional information about the current lifecycleState.
- maintenances
Sequence[mysql.
Get Mysql Db Systems Db System Maintenance] - The Maintenance Policy for the DB System or Read Replica that this model is included in.
- mysql_
version str - Name of the MySQL Version in use for the DB System.
- point_
in_ Sequence[mysql.time_ recovery_ details Get Mysql Db Systems Db System Point In Time Recovery Detail] - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- port int
- The port for primary endpoint of the DB System to listen on.
- port_
x int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- secure_
connections Sequence[mysql.Get Mysql Db Systems Db System Secure Connection] - Secure connection configuration details.
- shape_
name str - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- shutdown_
type str - sources
Sequence[mysql.
Get Mysql Db Systems Db System Source] - Parameters detailing how to provision the initial data of the DB System.
- state str
- DbSystem Lifecycle State
- subnet_
id str - The OCID of the subnet the DB System is associated with.
- time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- admin
Password String - admin
Username String - availability
Domain String - The availability domain in which the DB System is placed.
- backup
Policies List<Property Map> - The Backup policy for the DB System.
- channels List<Property Map>
- A list with a summary of all the Channels attached to the DB System.
- compartment
Id String - The compartment OCID.
- configuration
Id String - The requested Configuration instance.
- crash
Recovery String - Whether to run the DB System with InnoDB Redo Logs and the Double Write Buffer enabled or disabled, and whether to enable or disable syncing of the Binary Logs.
- current
Placements List<Property Map> - The availability domain and fault domain a DB System is placed in.
- customer
Contacts List<Property Map> - The list of customer email addresses that receive information from Oracle about the specified Oracle Cloud Infrastructure DB System resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a DB System.
- data
Storage NumberSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storages List<Property Map> - Data Storage information.
- database
Management String - Filter DB Systems by their Database Management configuration.
- Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- deletion
Policies List<Property Map> - The Deletion policy for the DB System.
- description String
- User-provided data about the DB System.
- display
Name String - A filter to return only the resource matching the given display name exactly.
- endpoints List<Property Map>
- The network endpoints available for this DB System.
- fault
Domain String - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- Map<String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- heat
Wave List<Property Map>Clusters - A summary of a HeatWave cluster.
- hostname
Label String - The hostname for the primary endpoint of the DB System. Used for DNS. The value is the hostname portion of the primary private IP's fully qualified domain name (FQDN) (for example, "dbsystem-1" in FQDN "dbsystem-1.subnet123.vcn1.oraclevcn.com"). Must be unique across all VNICs in the subnet and comply with RFC 952 and RFC 1123.
- id String
- The OCID of the DB System.
- ip
Address String - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- is
Heat BooleanWave Cluster Attached - If true, return only DB Systems with a HeatWave cluster attached, if false return only DB Systems with no HeatWave cluster attached. If not present, return all DB Systems.
- is
Highly BooleanAvailable - Specifies if the DB System is highly available.
- lifecycle
Details String - Additional information about the current lifecycleState.
- maintenances List<Property Map>
- The Maintenance Policy for the DB System or Read Replica that this model is included in.
- mysql
Version String - Name of the MySQL Version in use for the DB System.
- point
In List<Property Map>Time Recovery Details - Point-in-time Recovery details like earliest and latest recovery time point for the DB System.
- port Number
- The port for primary endpoint of the DB System to listen on.
- port
X Number - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- secure
Connections List<Property Map> - Secure connection configuration details.
- shape
Name String - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- shutdown
Type String - sources List<Property Map>
- Parameters detailing how to provision the initial data of the DB System.
- state String
- DbSystem Lifecycle State
- subnet
Id String - The OCID of the subnet the DB System is associated with.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
GetMysqlDbSystemsDbSystemBackupPolicy
- Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Dictionary<string, string>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Pitr
Policies List<GetMysql Db Systems Db System Backup Policy Pitr Policy> - The PITR policy for the DB System.
- Retention
In intDays - The number of days automated backups are retained.
- Window
Start stringTime - The start time of the maintenance window.
- map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- map[string]string
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Pitr
Policies []GetMysql Db Systems Db System Backup Policy Pitr Policy - The PITR policy for the DB System.
- Retention
In intDays - The number of days automated backups are retained.
- Window
Start stringTime - The start time of the maintenance window.
- Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Map<String,String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- pitr
Policies List<GetDb Systems Db System Backup Policy Pitr Policy> - The PITR policy for the DB System.
- retention
In IntegerDays - The number of days automated backups are retained.
- window
Start StringTime - The start time of the maintenance window.
- {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- {[key: string]: string}
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- is
Enabled boolean - Whether the Channel has been enabled by the user.
- pitr
Policies GetMysql Db Systems Db System Backup Policy Pitr Policy[] - The PITR policy for the DB System.
- retention
In numberDays - The number of days automated backups are retained.
- window
Start stringTime - The start time of the maintenance window.
- Mapping[str, str]
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Mapping[str, str]
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- is_
enabled bool - Whether the Channel has been enabled by the user.
- pitr_
policies Sequence[mysql.Get Mysql Db Systems Db System Backup Policy Pitr Policy] - The PITR policy for the DB System.
- retention_
in_ intdays - The number of days automated backups are retained.
- window_
start_ strtime - The start time of the maintenance window.
- Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Map<String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- pitr
Policies List<Property Map> - The PITR policy for the DB System.
- retention
In NumberDays - The number of days automated backups are retained.
- window
Start StringTime - The start time of the maintenance window.
GetMysqlDbSystemsDbSystemBackupPolicyPitrPolicy
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- is
Enabled boolean - Whether the Channel has been enabled by the user.
- is_
enabled bool - Whether the Channel has been enabled by the user.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
GetMysqlDbSystemsDbSystemChannel
- Compartment
Id string - The compartment OCID.
- Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- Dictionary<string, string>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Id string
- The OCID of the DB System.
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Sources
List<Get
Mysql Db Systems Db System Channel Source> - Parameters detailing how to provision the initial data of the DB System.
- State string
- DbSystem Lifecycle State
- Targets
List<Get
Mysql Db Systems Db System Channel Target> - Details about the Channel target.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Compartment
Id string - The compartment OCID.
- map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Display
Name string - A filter to return only the resource matching the given display name exactly.
- map[string]string
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- Id string
- The OCID of the DB System.
- Is
Enabled bool - Whether the Channel has been enabled by the user.
- Lifecycle
Details string - Additional information about the current lifecycleState.
- Sources
[]Get
Mysql Db Systems Db System Channel Source - Parameters detailing how to provision the initial data of the DB System.
- State string
- DbSystem Lifecycle State
- Targets
[]Get
Mysql Db Systems Db System Channel Target - Details about the Channel target.
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- compartment
Id String - The compartment OCID.
- Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - A filter to return only the resource matching the given display name exactly.
- Map<String,String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id String
- The OCID of the DB System.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details String - Additional information about the current lifecycleState.
- sources
List<Get
Db Systems Db System Channel Source> - Parameters detailing how to provision the initial data of the DB System.
- state String
- DbSystem Lifecycle State
- targets
List<Get
Db Systems Db System Channel Target> - Details about the Channel target.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- compartment
Id string - The compartment OCID.
- {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name string - A filter to return only the resource matching the given display name exactly.
- {[key: string]: string}
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id string
- The OCID of the DB System.
- is
Enabled boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details string - Additional information about the current lifecycleState.
- sources
Get
Mysql Db Systems Db System Channel Source[] - Parameters detailing how to provision the initial data of the DB System.
- state string
- DbSystem Lifecycle State
- targets
Get
Mysql Db Systems Db System Channel Target[] - Details about the Channel target.
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- compartment_
id str - The compartment OCID.
- Mapping[str, str]
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display_
name str - A filter to return only the resource matching the given display name exactly.
- Mapping[str, str]
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id str
- The OCID of the DB System.
- is_
enabled bool - Whether the Channel has been enabled by the user.
- lifecycle_
details str - Additional information about the current lifecycleState.
- sources
Sequence[mysql.
Get Mysql Db Systems Db System Channel Source] - Parameters detailing how to provision the initial data of the DB System.
- state str
- DbSystem Lifecycle State
- targets
Sequence[mysql.
Get Mysql Db Systems Db System Channel Target] - Details about the Channel target.
- time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- compartment
Id String - The compartment OCID.
- Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- display
Name String - A filter to return only the resource matching the given display name exactly.
- Map<String>
- Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"}
- id String
- The OCID of the DB System.
- is
Enabled Boolean - Whether the Channel has been enabled by the user.
- lifecycle
Details String - Additional information about the current lifecycleState.
- sources List<Property Map>
- Parameters detailing how to provision the initial data of the DB System.
- state String
- DbSystem Lifecycle State
- targets List<Property Map>
- Details about the Channel target.
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
GetMysqlDbSystemsDbSystemChannelSource
- Anonymous
Transactions List<GetHandlings Mysql Db Systems Db System Channel Source Anonymous Transactions Handling> - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- Hostname string
- The network address of the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Source
Type string - The specific source identifier.
- Ssl
Ca List<GetCertificates Mysql Db Systems Db System Channel Source Ssl Ca Certificate> - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- Ssl
Mode string - The SSL mode of the Channel.
- Username string
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
- Anonymous
Transactions []GetHandlings Mysql Db Systems Db System Channel Source Anonymous Transactions Handling - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- Hostname string
- The network address of the DB System.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Source
Type string - The specific source identifier.
- Ssl
Ca []GetCertificates Mysql Db Systems Db System Channel Source Ssl Ca Certificate - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- Ssl
Mode string - The SSL mode of the Channel.
- Username string
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
- anonymous
Transactions List<GetHandlings Db Systems Db System Channel Source Anonymous Transactions Handling> - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- hostname String
- The network address of the DB System.
- port Integer
- The port for primary endpoint of the DB System to listen on.
- source
Type String - The specific source identifier.
- ssl
Ca List<GetCertificates Db Systems Db System Channel Source Ssl Ca Certificate> - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode String - The SSL mode of the Channel.
- username String
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
- anonymous
Transactions GetHandlings Mysql Db Systems Db System Channel Source Anonymous Transactions Handling[] - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- hostname string
- The network address of the DB System.
- port number
- The port for primary endpoint of the DB System to listen on.
- source
Type string - The specific source identifier.
- ssl
Ca GetCertificates Mysql Db Systems Db System Channel Source Ssl Ca Certificate[] - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode string - The SSL mode of the Channel.
- username string
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
- anonymous_
transactions_ Sequence[mysql.handlings Get Mysql Db Systems Db System Channel Source Anonymous Transactions Handling] - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- hostname str
- The network address of the DB System.
- port int
- The port for primary endpoint of the DB System to listen on.
- source_
type str - The specific source identifier.
- ssl_
ca_ Sequence[mysql.certificates Get Mysql Db Systems Db System Channel Source Ssl Ca Certificate] - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl_
mode str - The SSL mode of the Channel.
- username str
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
- anonymous
Transactions List<Property Map>Handlings - Specifies how the replication channel handles replicated transactions without an identifier, enabling replication from a source that does not use transaction-id-based replication to a replica that does.
- hostname String
- The network address of the DB System.
- port Number
- The port for primary endpoint of the DB System to listen on.
- source
Type String - The specific source identifier.
- ssl
Ca List<Property Map>Certificates - The CA certificate of the server used for VERIFY_IDENTITY and VERIFY_CA ssl modes.
- ssl
Mode String - The SSL mode of the Channel.
- username String
- The name of the replication user on the source MySQL instance. The username has a maximum length of 96 characters. For more information, please see the MySQL documentation
GetMysqlDbSystemsDbSystemChannelSourceAnonymousTransactionsHandling
- Last
Configured stringLog Filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- Last
Configured stringLog Offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- Policy string
- Specifies how the replication channel handles anonymous transactions.
- Uuid string
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
- Last
Configured stringLog Filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- Last
Configured stringLog Offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- Policy string
- Specifies how the replication channel handles anonymous transactions.
- Uuid string
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
- last
Configured StringLog Filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- last
Configured StringLog Offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- policy String
- Specifies how the replication channel handles anonymous transactions.
- uuid String
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
- last
Configured stringLog Filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- last
Configured stringLog Offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- policy string
- Specifies how the replication channel handles anonymous transactions.
- uuid string
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
- last_
configured_ strlog_ filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- last_
configured_ strlog_ offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- policy str
- Specifies how the replication channel handles anonymous transactions.
- uuid str
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
- last
Configured StringLog Filename - Specifies one of the coordinates (file) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- last
Configured StringLog Offset - Specifies one of the coordinates (offset) at which the replica should begin reading the source's log. As this value specifies the point where replication starts from, it is only used once, when it starts. It is never used again, unless a new UpdateChannel operation modifies it.
- policy String
- Specifies how the replication channel handles anonymous transactions.
- uuid String
- The UUID that is used as a prefix when generating transaction identifiers for anonymous transactions coming from the source. You can change the UUID later.
GetMysqlDbSystemsDbSystemChannelSourceSslCaCertificate
- Certificate
Type string - The type of CA certificate.
- Contents string
- The string containing the CA certificate in PEM format.
- Certificate
Type string - The type of CA certificate.
- Contents string
- The string containing the CA certificate in PEM format.
- certificate
Type String - The type of CA certificate.
- contents String
- The string containing the CA certificate in PEM format.
- certificate
Type string - The type of CA certificate.
- contents string
- The string containing the CA certificate in PEM format.
- certificate_
type str - The type of CA certificate.
- contents str
- The string containing the CA certificate in PEM format.
- certificate
Type String - The type of CA certificate.
- contents String
- The string containing the CA certificate in PEM format.
GetMysqlDbSystemsDbSystemChannelTarget
- Applier
Username string - The username for the replication applier of the target MySQL DB System.
- Channel
Name string - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- Db
System stringId - The DB System OCID.
- Delay
In intSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- Filters
List<Get
Mysql Db Systems Db System Channel Target Filter> - Replication filter rules to be applied at the DB System Channel target.
- Tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- Target
Type string - The specific target identifier.
- Applier
Username string - The username for the replication applier of the target MySQL DB System.
- Channel
Name string - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- Db
System stringId - The DB System OCID.
- Delay
In intSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- Filters
[]Get
Mysql Db Systems Db System Channel Target Filter - Replication filter rules to be applied at the DB System Channel target.
- Tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- Target
Type string - The specific target identifier.
- applier
Username String - The username for the replication applier of the target MySQL DB System.
- channel
Name String - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- db
System StringId - The DB System OCID.
- delay
In IntegerSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
List<Get
Db Systems Db System Channel Target Filter> - Replication filter rules to be applied at the DB System Channel target.
- tables
Without StringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type String - The specific target identifier.
- applier
Username string - The username for the replication applier of the target MySQL DB System.
- channel
Name string - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- db
System stringId - The DB System OCID.
- delay
In numberSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
Get
Mysql Db Systems Db System Channel Target Filter[] - Replication filter rules to be applied at the DB System Channel target.
- tables
Without stringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type string - The specific target identifier.
- applier_
username str - The username for the replication applier of the target MySQL DB System.
- channel_
name str - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- db_
system_ strid - The DB System OCID.
- delay_
in_ intseconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters
Sequence[mysql.
Get Mysql Db Systems Db System Channel Target Filter] - Replication filter rules to be applied at the DB System Channel target.
- tables_
without_ strprimary_ key_ handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target_
type str - The specific target identifier.
- applier
Username String - The username for the replication applier of the target MySQL DB System.
- channel
Name String - The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.
- db
System StringId - The DB System OCID.
- delay
In NumberSeconds - Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.
- filters List<Property Map>
- Replication filter rules to be applied at the DB System Channel target.
- tables
Without StringPrimary Key Handling - Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.
- target
Type String - The specific target identifier.
GetMysqlDbSystemsDbSystemChannelTargetFilter
- Type string
- The type of the filter rule.
- Value string
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
- Type string
- The type of the filter rule.
- Value string
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
- type String
- The type of the filter rule.
- value String
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
- type string
- The type of the filter rule.
- value string
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
- type str
- The type of the filter rule.
- value str
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
- type String
- The type of the filter rule.
- value String
- The body of the filter rule. This can represent a database, a table, or a database pair (represented as "db1->db2"). For more information, see Replication Filtering Rules.
GetMysqlDbSystemsDbSystemCurrentPlacement
- Availability
Domain string - The availability domain in which the DB System is placed.
- Fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- Availability
Domain string - The availability domain in which the DB System is placed.
- Fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- availability
Domain String - The availability domain in which the DB System is placed.
- fault
Domain String - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- availability
Domain string - The availability domain in which the DB System is placed.
- fault
Domain string - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- availability_
domain str - The availability domain in which the DB System is placed.
- fault_
domain str - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
- availability
Domain String - The availability domain in which the DB System is placed.
- fault
Domain String - The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
GetMysqlDbSystemsDbSystemCustomerContact
- Email string
- The email address used by Oracle to send notifications regarding the DB System.
- Email string
- The email address used by Oracle to send notifications regarding the DB System.
- email String
- The email address used by Oracle to send notifications regarding the DB System.
- email string
- The email address used by Oracle to send notifications regarding the DB System.
- email str
- The email address used by Oracle to send notifications regarding the DB System.
- email String
- The email address used by Oracle to send notifications regarding the DB System.
GetMysqlDbSystemsDbSystemDataStorage
- Allocated
Storage intSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- Data
Storage intSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- Data
Storage intSize Limit In Gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- Is
Auto boolExpand Storage Enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- Max
Storage intSize In Gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
- Allocated
Storage intSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- Data
Storage intSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- Data
Storage intSize Limit In Gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- Is
Auto boolExpand Storage Enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- Max
Storage intSize In Gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
- allocated
Storage IntegerSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage IntegerSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storage IntegerSize Limit In Gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- is
Auto BooleanExpand Storage Enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- max
Storage IntegerSize In Gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
- allocated
Storage numberSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage numberSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storage numberSize Limit In Gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- is
Auto booleanExpand Storage Enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- max
Storage numberSize In Gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
- allocated_
storage_ intsize_ in_ gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data_
storage_ intsize_ in_ gb - Initial size of the data volume in GiBs that will be created and attached.
- data_
storage_ intsize_ limit_ in_ gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- is_
auto_ boolexpand_ storage_ enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- max_
storage_ intsize_ in_ gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
- allocated
Storage NumberSize In Gbs - The actual allocated storage size for the DB System. This may be higher than dataStorageSizeInGBs if an automatic storage expansion has occurred.
- data
Storage NumberSize In Gb - Initial size of the data volume in GiBs that will be created and attached.
- data
Storage NumberSize Limit In Gbs - The absolute limit the DB System's storage size may ever expand to, either manually or automatically. This limit is based based on the initial dataStorageSizeInGBs when the DB System was first created. Both dataStorageSizeInGBs and maxDataStorageSizeInGBs can not exceed this value.
- is
Auto BooleanExpand Storage Enabled - Enable/disable automatic storage expansion. When set to true, the DB System will automatically add storage incrementally up to the value specified in maxStorageSizeInGBs.
- max
Storage NumberSize In Gbs - Maximum storage size this DB System can expand to. When isAutoExpandStorageEnabled is set to true, the DB System will add storage incrementally up to this value.
GetMysqlDbSystemsDbSystemDeletionPolicy
- Automatic
Backup stringRetention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- Final
Backup string - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- Is
Delete boolProtected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- Automatic
Backup stringRetention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- Final
Backup string - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- Is
Delete boolProtected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup StringRetention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup String - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- is
Delete BooleanProtected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup stringRetention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup string - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- is
Delete booleanProtected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic_
backup_ strretention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final_
backup str - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- is_
delete_ boolprotected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
- automatic
Backup StringRetention - Specifies if any automatic backups created for a DB System should be retained or deleted when the DB System is deleted.
- final
Backup String - Specifies whether or not a backup is taken when the DB System is deleted. REQUIRE_FINAL_BACKUP: a backup is taken if the DB System is deleted. SKIP_FINAL_BACKUP: a backup is not taken if the DB System is deleted.
- is
Delete BooleanProtected - Specifies whether the DB System can be deleted. Set to true to prevent deletion, false (default) to allow.
GetMysqlDbSystemsDbSystemEndpoint
- Hostname string
- The network address of the DB System.
- Ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- Modes List<string>
- The access modes from the client that this endpoint supports.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- Resource
Id string - The OCID of the resource that this endpoint is attached to.
- Resource
Type string - The type of endpoint that clients and connectors can connect to.
- Status string
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- Status
Details string - Additional information about the current endpoint status.
- Hostname string
- The network address of the DB System.
- Ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- Modes []string
- The access modes from the client that this endpoint supports.
- Port int
- The port for primary endpoint of the DB System to listen on.
- Port
X int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- Resource
Id string - The OCID of the resource that this endpoint is attached to.
- Resource
Type string - The type of endpoint that clients and connectors can connect to.
- Status string
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- Status
Details string - Additional information about the current endpoint status.
- hostname String
- The network address of the DB System.
- ip
Address String - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- modes List<String>
- The access modes from the client that this endpoint supports.
- port Integer
- The port for primary endpoint of the DB System to listen on.
- port
X Integer - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- resource
Id String - The OCID of the resource that this endpoint is attached to.
- resource
Type String - The type of endpoint that clients and connectors can connect to.
- status String
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- status
Details String - Additional information about the current endpoint status.
- hostname string
- The network address of the DB System.
- ip
Address string - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- modes string[]
- The access modes from the client that this endpoint supports.
- port number
- The port for primary endpoint of the DB System to listen on.
- port
X number - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- resource
Id string - The OCID of the resource that this endpoint is attached to.
- resource
Type string - The type of endpoint that clients and connectors can connect to.
- status string
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- status
Details string - Additional information about the current endpoint status.
- hostname str
- The network address of the DB System.
- ip_
address str - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- modes Sequence[str]
- The access modes from the client that this endpoint supports.
- port int
- The port for primary endpoint of the DB System to listen on.
- port_
x int - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- resource_
id str - The OCID of the resource that this endpoint is attached to.
- resource_
type str - The type of endpoint that clients and connectors can connect to.
- status str
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- status_
details str - Additional information about the current endpoint status.
- hostname String
- The network address of the DB System.
- ip
Address String - The IP address the DB System is configured to listen on. A private IP address of the primary endpoint of the DB System. Must be an available IP address within the subnet's CIDR. This will be a "dotted-quad" style IPv4 address.
- modes List<String>
- The access modes from the client that this endpoint supports.
- port Number
- The port for primary endpoint of the DB System to listen on.
- port
X Number - The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
- resource
Id String - The OCID of the resource that this endpoint is attached to.
- resource
Type String - The type of endpoint that clients and connectors can connect to.
- status String
- The state of the endpoints, as far as it can seen from the DB System. There may be some inconsistency with the actual state of the MySQL service.
- status
Details String - Additional information about the current endpoint status.
GetMysqlDbSystemsDbSystemHeatWaveCluster
- Cluster
Size int - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- Is
Lakehouse boolEnabled - Lakehouse enabled status for the HeatWave cluster.
- Shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- State string
- DbSystem Lifecycle State
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- Cluster
Size int - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- Is
Lakehouse boolEnabled - Lakehouse enabled status for the HeatWave cluster.
- Shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- State string
- DbSystem Lifecycle State
- Time
Created string - The date and time the DB System was created.
- Time
Updated string - The time the DB System was last updated.
- cluster
Size Integer - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse BooleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name String - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- state String
- DbSystem Lifecycle State
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
- cluster
Size number - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse booleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name string - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- state string
- DbSystem Lifecycle State
- time
Created string - The date and time the DB System was created.
- time
Updated string - The time the DB System was last updated.
- cluster_
size int - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is_
lakehouse_ boolenabled - Lakehouse enabled status for the HeatWave cluster.
- shape_
name str - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- state str
- DbSystem Lifecycle State
- time_
created str - The date and time the DB System was created.
- time_
updated str - The time the DB System was last updated.
- cluster
Size Number - The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
- is
Lakehouse BooleanEnabled - Lakehouse enabled status for the HeatWave cluster.
- shape
Name String - The shape of the primary instances of the DB System. The shape determines resources allocated to a DB System - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes. To get a list of shapes, use (the ListShapes operation.
- state String
- DbSystem Lifecycle State
- time
Created String - The date and time the DB System was created.
- time
Updated String - The time the DB System was last updated.
GetMysqlDbSystemsDbSystemMaintenance
- Window
Start stringTime - The start time of the maintenance window.
- Window
Start stringTime - The start time of the maintenance window.
- window
Start StringTime - The start time of the maintenance window.
- window
Start stringTime - The start time of the maintenance window.
- window_
start_ strtime - The start time of the maintenance window.
- window
Start StringTime - The start time of the maintenance window.
GetMysqlDbSystemsDbSystemPointInTimeRecoveryDetail
- Time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- Time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- Time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- Time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest StringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest StringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest stringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest stringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
- time_
earliest_ strrecovery_ point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time_
latest_ strrecovery_ point - Latest recovery time point for the DB System, as described by RFC 3339.
- time
Earliest StringRecovery Point - Earliest recovery time point for the DB System, as described by RFC 3339.
- time
Latest StringRecovery Point - Latest recovery time point for the DB System, as described by RFC 3339.
GetMysqlDbSystemsDbSystemSecureConnection
- Certificate
Generation stringType - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- Certificate
Id string - The OCID of the certificate to use.
- Certificate
Generation stringType - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- Certificate
Id string - The OCID of the certificate to use.
- certificate
Generation StringType - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id String - The OCID of the certificate to use.
- certificate
Generation stringType - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id string - The OCID of the certificate to use.
- certificate_
generation_ strtype - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate_
id str - The OCID of the certificate to use.
- certificate
Generation StringType - Select whether to use MySQL Database Service-managed certificate (SYSTEM) or your own certificate (BYOC).
- certificate
Id String - The OCID of the certificate to use.
GetMysqlDbSystemsDbSystemSource
- Backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- Db
System stringId - The DB System OCID.
- Recovery
Point string - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- Source
Type string - The specific source identifier.
- Source
Url string
- Backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- Db
System stringId - The DB System OCID.
- Recovery
Point string - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- Source
Type string - The specific source identifier.
- Source
Url string
- backup
Id String - The OCID of the backup to be used as the source for the new DB System.
- db
System StringId - The DB System OCID.
- recovery
Point String - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- source
Type String - The specific source identifier.
- source
Url String
- backup
Id string - The OCID of the backup to be used as the source for the new DB System.
- db
System stringId - The DB System OCID.
- recovery
Point string - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- source
Type string - The specific source identifier.
- source
Url string
- backup_
id str - The OCID of the backup to be used as the source for the new DB System.
- db_
system_ strid - The DB System OCID.
- recovery_
point str - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- source_
type str - The specific source identifier.
- source_
url str
- backup
Id String - The OCID of the backup to be used as the source for the new DB System.
- db
System StringId - The DB System OCID.
- recovery
Point String - The date and time, as per RFC 3339, of the change up to which the new DB System shall be restored to, using a backup and logs from the original DB System. In case no point in time is specified, then this new DB System shall be restored up to the latest change recorded for the original DB System.
- source
Type String - The specific source identifier.
- source
Url String
GetMysqlDbSystemsFilter
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
oci
Terraform Provider.