Class UpdateDbSystemDetails
Details required to update a DB System.
Inheritance
UpdateDbSystemDetails
Assembly: OCI.DotNetSDK.Mysql.dll
Syntax
public class UpdateDbSystemDetails
Properties
AdminPassword
Declaration
[JsonProperty(PropertyName = "adminPassword")]
public string AdminPassword { get; set; }
Property Value
Type |
Description |
string |
The password for the administrative user. The password must be
between 8 and 32 characters long, and must contain at least 1
numeric character, 1 lowercase character, 1 uppercase character, and
1 special (nonalphanumeric) character.
|
AdminUsername
Declaration
[JsonProperty(PropertyName = "adminUsername")]
public string AdminUsername { get; set; }
Property Value
Type |
Description |
string |
The username for the administrative user for the MySQL Instance.
|
AvailabilityDomain
Declaration
[JsonProperty(PropertyName = "availabilityDomain")]
public string AvailabilityDomain { get; set; }
Property Value
Type |
Description |
string |
The availability domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
In a failover scenario, the Read/Write endpoint is redirected to one of the other availability domains
and the MySQL instance in that domain is promoted to the primary instance.
This redirection does not affect the IP address of the DB System in any way.
For a standalone DB System, this defines the availability domain in which the DB System is placed.
|
BackupPolicy
Declaration
[JsonProperty(PropertyName = "backupPolicy")]
public UpdateBackupPolicyDetails BackupPolicy { get; set; }
Property Value
ConfigurationId
Declaration
[JsonProperty(PropertyName = "configurationId")]
public string ConfigurationId { get; set; }
Property Value
Type |
Description |
string |
The OCID of the Configuration to be used for Instances in this DB System.
|
CrashRecovery
Declaration
[JsonProperty(PropertyName = "crashRecovery")]
[JsonConverter(typeof(StringEnumConverter))]
public CrashRecoveryStatus? CrashRecovery { get; set; }
Property Value
Type |
Description |
CrashRecoveryStatus? |
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.
|
Declaration
[JsonProperty(PropertyName = "customerContacts")]
public List<CustomerContact> CustomerContacts { get; set; }
Property Value
Type |
Description |
List<CustomerContact> |
The list of customer email addresses that receive information from Oracle about the specified OCI 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.
|
DataStorage
Declaration
[JsonProperty(PropertyName = "dataStorage")]
public DataStorageDetails DataStorage { get; set; }
Property Value
DataStorageSizeInGBs
Declaration
[JsonProperty(PropertyName = "dataStorageSizeInGBs")]
public int? DataStorageSizeInGBs { get; set; }
Property Value
Type |
Description |
int? |
Expands the DB System's storage to the specified value. Only supports values larger than the current DB System's
storage size.
DB Systems with an initial storage size of 400 GB or less can be expanded up to 32 TB.
DB Systems with an initial storage size between 401-800 GB can be expanded up to 64 TB.
DB Systems with an initial storage size between 801-1200 GB can be expanded up to 96 TB.
DB Systems with an initial storage size of 1201 GB or more can be expanded up to 128 TB.
It is not possible to decrease data storage size.
|
DatabaseManagement
Declaration
[JsonProperty(PropertyName = "databaseManagement")]
[JsonConverter(typeof(StringEnumConverter))]
public DatabaseManagementStatus? DatabaseManagement { get; set; }
Property Value
Declaration
[JsonProperty(PropertyName = "definedTags")]
public Dictionary<string, Dictionary<string, object>> DefinedTags { get; set; }
Property Value
Type |
Description |
Dictionary<string, Dictionary<string, object>> |
Usage of predefined tag keys. These predefined keys are scoped to namespaces.
Example: {"foo-namespace": {"bar-key": "value"}}
|
DeletionPolicy
Declaration
[JsonProperty(PropertyName = "deletionPolicy")]
public UpdateDeletionPolicyDetails DeletionPolicy { get; set; }
Property Value
Description
Declaration
[JsonProperty(PropertyName = "description")]
public string Description { get; set; }
Property Value
Type |
Description |
string |
User-provided data about the DB System.
|
DisplayName
Declaration
[JsonProperty(PropertyName = "displayName")]
public string DisplayName { get; set; }
Property Value
Type |
Description |
string |
The user-friendly name for the DB System. It does not have to be unique.
|
FaultDomain
Declaration
[JsonProperty(PropertyName = "faultDomain")]
public string FaultDomain { get; set; }
Property Value
Type |
Description |
string |
The fault domain on which to deploy the Read/Write endpoint. This defines the preferred primary instance.
In a failover scenario, the Read/Write endpoint is redirected to one of the other fault domains
and the MySQL instance in that domain is promoted to the primary instance.
This redirection does not affect the IP address of the DB System in any way.
For a standalone DB System, this defines the fault domain in which the DB System is placed.
|
Declaration
[JsonProperty(PropertyName = "freeformTags")]
public Dictionary<string, string> FreeformTags { get; set; }
Property Value
Type |
Description |
Dictionary<string, string> |
Simple key-value pair applied without any predefined name, type or scope. Exists for cross-compatibility only.
Example: {"bar-key": "value"}
|
HostnameLabel
Declaration
[JsonProperty(PropertyName = "hostnameLabel")]
public string HostnameLabel { get; set; }
Property Value
Type |
Description |
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.
|
IpAddress
Declaration
[JsonProperty(PropertyName = "ipAddress")]
public string IpAddress { get; set; }
Property Value
Type |
Description |
string |
The IP address the DB System should be configured to listen on the provided subnet.
It must be a free private IP address within the subnet's CIDR. If you don't specify a
value, Oracle automatically assigns a private IP address from the subnet. This should
be a "dotted-quad" style IPv4 address.
|
IsHighlyAvailable
Declaration
[JsonProperty(PropertyName = "isHighlyAvailable")]
public bool? IsHighlyAvailable { get; set; }
Property Value
Type |
Description |
bool? |
Specifies if the DB System is highly available.
Set to true to enable high availability. Two secondary MySQL instances are created and placed in the unused
availability or fault domains, depending on your region and subnet type.
Set to false to disable high availability. The secondary MySQL instances are removed and the MySQL instance
in the preferred location is used.
|
Maintenance
Declaration
[JsonProperty(PropertyName = "maintenance")]
public UpdateMaintenanceDetails Maintenance { get; set; }
Property Value
MysqlVersion
Declaration
[JsonProperty(PropertyName = "mysqlVersion")]
public string MysqlVersion { get; set; }
Property Value
Type |
Description |
string |
The specific MySQL version identifier.
|
Port
Declaration
[JsonProperty(PropertyName = "port")]
public int? Port { get; set; }
Property Value
Type |
Description |
int? |
The port for primary endpoint of the DB System to listen on.
|
PortX
Declaration
[JsonProperty(PropertyName = "portX")]
public int? PortX { get; set; }
Property Value
Type |
Description |
int? |
The TCP network port on which X Plugin listens for connections. This is the X Plugin equivalent of port.
|
SecureConnections
Declaration
[JsonProperty(PropertyName = "secureConnections")]
public SecureConnectionDetails SecureConnections { get; set; }
Property Value
ShapeName
Declaration
[JsonProperty(PropertyName = "shapeName")]
public string ShapeName { get; set; }
Property Value
Type |
Description |
string |
The shape of the DB System. The shape determines resources
allocated to the 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
{@link #listShapes(ListShapesRequest) listShapes}
operation.
Changes in Shape will result in a downtime as the MySQL DB System is
migrated to the new Compute instance.
|
SubnetId
Declaration
[JsonProperty(PropertyName = "subnetId")]
public string SubnetId { get; set; }
Property Value
Type |
Description |
string |
The OCID of the subnet the DB System is associated with.
|