// This is an automatically generated code sample.
// To make this code sample work in your Oracle Cloud tenancy,
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
// boolean, number, and enum parameters with values not fitting your use case).
package main
import (
"context"
"fmt"
"time"
"github.com/oracle/oci-go-sdk/v65/common"
"github.com/oracle/oci-go-sdk/v65/example/helpers"
"github.com/oracle/oci-go-sdk/v65/mysql"
)
func ExampleCreateDbSystem() {
// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
client, err := mysql.NewDbSystemClientWithConfigurationProvider(common.DefaultConfigProvider())
helpers.FatalIfError(err)
// Create a request and dependent object(s).
req := mysql.CreateDbSystemRequest{CreateDbSystemDetails: mysql.CreateDbSystemDetails{FaultDomain: common.String("EXAMPLE-faultDomain-Value"),
ReadEndpoint: &mysql.CreateReadEndpointDetails{IsEnabled: common.Bool(false),
ReadEndpointHostnameLabel: common.String("EXAMPLE-readEndpointHostnameLabel-Value"),
ReadEndpointIpAddress: common.String("EXAMPLE-readEndpointIpAddress-Value"),
ReadEndpointIpv6AddressIpv6SubnetCidrPairDetails: &mysql.Ipv6AddressIpv6SubnetCidrPairDetails{Ipv6Address: common.String("EXAMPLE-ipv6Address-Value"),
Ipv6SubnetCidr: common.String("EXAMPLE-ipv6SubnetCidr-Value")},
ExcludeIps: []string{"EXAMPLE--Value"}},
TelemetryConfiguration: &mysql.CreateTelemetryConfigurationDetails{Logs: []mysql.LoggingDestinationConfiguration{mysql.LoggingDestinationConfiguration{Destination: mysql.LoggingDestinationConfigurationDestinationOpenTelemetry,
DestinationConfigurations: []mysql.DestinationConfiguration{mysql.DestinationConfiguration{Key: common.String("EXAMPLE-key-Value"),
Value: common.String("EXAMPLE-value-Value")}},
LogTypes: []mysql.LoggingDestinationConfigurationLogTypesEnum{mysql.LoggingDestinationConfigurationLogTypesErrorLog}}}},
ConfigurationId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-configurationId-Value"),
DeletionPolicy: &mysql.CreateDeletionPolicyDetails{IsDeleteProtected: common.Bool(false),
AutomaticBackupRetention: mysql.CreateDeletionPolicyDetailsAutomaticBackupRetentionRetain,
FinalBackup: mysql.CreateDeletionPolicyDetailsFinalBackupRequireFinalBackup},
EncryptData: &mysql.EncryptDataDetails{KeyGenerationType: mysql.KeyGenerationTypeByok,
KeyId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value")},
SecurityAttributes: map[string]map[string]interface{}{"EXAMPLE_KEY_cpoSP": map[string]interface{}{"EXAMPLE_KEY_WDLLy": "EXAMPLE--Value"}},
Maintenance: &mysql.CreateMaintenanceDetails{MaintenanceDisabledWindows: []mysql.MaintenanceDisabledWindow{mysql.MaintenanceDisabledWindow{TimeEnd: &common.SDKTime{Time: time.Now()},
TimeStart: &common.SDKTime{Time: time.Now()}}},
MaintenanceScheduleType: mysql.MaintenanceScheduleTypeEarly,
VersionPreference: mysql.VersionPreferenceSecondNewest,
VersionTrackPreference: mysql.VersionTrackPreferenceFollow,
WindowStartTime: common.String("EXAMPLE-windowStartTime-Value")},
AccessMode: mysql.DbSystemAccessModeUnrestricted,
DatabaseManagement: mysql.DatabaseManagementStatusEnabled,
HostnameLabel: common.String("EXAMPLE-hostnameLabel-Value"),
Rest: &mysql.CreateRestDetails{Configuration: mysql.RestConfigurationTypeDisabled,
Port: common.Int(64957)},
IsIpv6Enabled: common.Bool(false),
AvailabilityDomain: common.String("EXAMPLE-availabilityDomain-Value"),
IpAddress: common.String("EXAMPLE-ipAddress-Value"),
IsHighlyAvailable: common.Bool(false),
MysqlVersion: common.String("EXAMPLE-mysqlVersion-Value"),
AdminPassword: common.String("EXAMPLE-adminPassword-Value"),
BackupPolicy: &mysql.CreateBackupPolicyDetails{RetentionInDays: common.Int(33),
SoftDelete: mysql.SoftDeleteDisabled,
WindowStartTime: common.String("EXAMPLE-windowStartTime-Value"),
CopyPolicies: []mysql.CopyPolicy{mysql.CopyPolicy{BackupCopyRetentionInDays: common.Int(2),
CopyToRegion: common.String("EXAMPLE-copyToRegion-Value")}},
DefinedTags: map[string]map[string]interface{}{"EXAMPLE_KEY_8QjSn": map[string]interface{}{"EXAMPLE_KEY_ollKT": "EXAMPLE--Value"}},
FreeformTags: map[string]string{"EXAMPLE_KEY_rRDvW": "EXAMPLE_VALUE_hLJ6AGShS9crsCAKltGh"},
IsEnabled: common.Bool(true),
PitrPolicy: &mysql.PitrPolicy{IsEnabled: common.Bool(false)}},
CrashRecovery: mysql.CrashRecoveryStatusEnabled,
Description: common.String("EXAMPLE-description-Value"),
DisplayName: common.String("EXAMPLE-displayName-Value"),
FreeformTags: map[string]string{"EXAMPLE_KEY_snZta": "EXAMPLE_VALUE_VMvU9tRn7jy88fGtvY9h"},
PortX: common.Int(24495),
CompartmentId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value"),
CustomerContacts: []mysql.CustomerContact{mysql.CustomerContact{Email: common.String("EXAMPLE-email-Value")}},
DatabaseConsole: &mysql.CreateDatabaseConsoleDetails{Port: common.Int(55080),
Status: mysql.DatabaseConsoleStatusEnabled},
DefinedTags: map[string]map[string]interface{}{"EXAMPLE_KEY_wsuF5": map[string]interface{}{"EXAMPLE_KEY_EgPOQ": "EXAMPLE--Value"}},
NsgIds: []string{"EXAMPLE--Value"},
Port: common.Int(45798),
AdminUsername: common.String("EXAMPLE-adminUsername-Value"),
DataStorageSizeInGBs: common.Int(46695),
DatabaseMode: mysql.DbSystemDatabaseModeOnly,
Ipv6AddressIpv6SubnetCidrPairDetails: &mysql.Ipv6AddressIpv6SubnetCidrPairDetails{Ipv6Address: common.String("EXAMPLE-ipv6Address-Value"),
Ipv6SubnetCidr: common.String("EXAMPLE-ipv6SubnetCidr-Value")},
SecureConnections: &mysql.SecureConnectionDetails{CertificateGenerationType: mysql.CertificateGenerationTypeByoc,
CertificateId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-certificateId-Value")},
ShapeName: common.String("EXAMPLE-shapeName-Value"),
Source: mysql.CreateDbSystemSourceFromPitrDetails{DbSystemId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value"),
RecoveryPoint: &common.SDKTime{Time: time.Now()}},
SubnetId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value"),
DataStorage: &mysql.DataStorageDetails{IsAutoExpandStorageEnabled: common.Bool(false),
MaxStorageSizeInGBs: common.Int(82399)}},
OpcRequestId: common.String("3EWM1TFLGV6D6Z0ULHFA<unique_ID>"),
OpcRetryToken: common.String("EXAMPLE-opcRetryToken-Value")}
// Send the request using the service client
resp, err := client.CreateDbSystem(context.Background(), req)
helpers.FatalIfError(err)
// Retrieve value from the response.
fmt.Println(resp)
}