// 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{DeletionPolicy: &mysql.CreateDeletionPolicyDetails{FinalBackup: mysql.CreateDeletionPolicyDetailsFinalBackupSkipFinalBackup,
		IsDeleteProtected:        common.Bool(true),
		AutomaticBackupRetention: mysql.CreateDeletionPolicyDetailsAutomaticBackupRetentionDelete},
		FreeformTags:         map[string]string{"EXAMPLE_KEY_tMchl": "EXAMPLE_VALUE_W2uXr8wrPSSGtzTmmJ78"},
		HostnameLabel:        common.String("EXAMPLE-hostnameLabel-Value"),
		CrashRecovery:        mysql.CrashRecoveryStatusDisabled,
		DataStorageSizeInGBs: common.Int(23258),
		IpAddress:            common.String("EXAMPLE-ipAddress-Value"),
		Rest: &mysql.CreateRestDetails{Port: common.Int(62614),
			Configuration: mysql.RestConfigurationTypeDisabled},
		AdminUsername:      common.String("EXAMPLE-adminUsername-Value"),
		AvailabilityDomain: common.String("EXAMPLE-availabilityDomain-Value"),
		DisplayName:        common.String("EXAMPLE-displayName-Value"),
		IsHighlyAvailable:  common.Bool(false),
		ConfigurationId:    common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-configurationId-Value"),
		DataStorage: &mysql.DataStorageDetails{IsAutoExpandStorageEnabled: common.Bool(true),
			MaxStorageSizeInGBs: common.Int(120562)},
		SubnetId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value"),
		PortX:    common.Int(60455),
		ReadEndpoint: &mysql.CreateReadEndpointDetails{ExcludeIps: []string{"EXAMPLE--Value"},
			IsEnabled:                 common.Bool(true),
			ReadEndpointHostnameLabel: common.String("EXAMPLE-readEndpointHostnameLabel-Value"),
			ReadEndpointIpAddress:     common.String("EXAMPLE-readEndpointIpAddress-Value")},
		Source: mysql.CreateDbSystemSourceFromPitrDetails{RecoveryPoint: &common.SDKTime{Time: time.Now()},
			DbSystemId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value")},
		DatabaseManagement: mysql.DatabaseManagementStatusEnabled,
		EncryptData: &mysql.EncryptDataDetails{KeyGenerationType: mysql.KeyGenerationTypeByok,
			KeyId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value")},
		Description:  common.String("EXAMPLE-description-Value"),
		FaultDomain:  common.String("EXAMPLE-faultDomain-Value"),
		Maintenance:  &mysql.CreateMaintenanceDetails{WindowStartTime: common.String("EXAMPLE-windowStartTime-Value")},
		MysqlVersion: common.String("EXAMPLE-mysqlVersion-Value"),
		SecureConnections: &mysql.SecureConnectionDetails{CertificateGenerationType: mysql.CertificateGenerationTypeSystem,
			CertificateId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-certificateId-Value")},
		ShapeName:     common.String("EXAMPLE-shapeName-Value"),
		AdminPassword: common.String("EXAMPLE-adminPassword-Value"),
		BackupPolicy: &mysql.CreateBackupPolicyDetails{SoftDelete: mysql.SoftDeleteEnabled,
			WindowStartTime: common.String("EXAMPLE-windowStartTime-Value"),
			CopyPolicies: []mysql.CopyPolicy{mysql.CopyPolicy{BackupCopyRetentionInDays: common.Int(4),
				CopyToRegion: common.String("EXAMPLE-copyToRegion-Value")}},
			DefinedTags:     map[string]map[string]interface{}{"EXAMPLE_KEY_lPQfm": map[string]interface{}{"EXAMPLE_KEY_B5sh1": "EXAMPLE--Value"}},
			FreeformTags:    map[string]string{"EXAMPLE_KEY_gEm7n": "EXAMPLE_VALUE_g6zXsE3WCV9dRdRIO23M"},
			IsEnabled:       common.Bool(false),
			PitrPolicy:      &mysql.PitrPolicy{IsEnabled: common.Bool(true)},
			RetentionInDays: common.Int(19)},
		CustomerContacts: []mysql.CustomerContact{mysql.CustomerContact{Email: common.String("EXAMPLE-email-Value")}},
		DefinedTags:      map[string]map[string]interface{}{"EXAMPLE_KEY_FxuTH": map[string]interface{}{"EXAMPLE_KEY_nYBIw": "EXAMPLE--Value"}},
		AccessMode:       mysql.DbSystemAccessModeRestricted,
		CompartmentId:    common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value"),
		Port:             common.Int(4340),
		DatabaseMode:     mysql.DbSystemDatabaseModeOnly,
		NsgIds:           []string{"EXAMPLE--Value"}},
		OpcRequestId:  common.String("F1SLAV1HIDFKVVCAA2AN<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)
}

Was this article helpful?