// 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"

	"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 ExampleUpdateDbSystem() {
	// 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.UpdateDbSystemRequest{DbSystemId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value"),
		IfMatch:      common.String("EXAMPLE-ifMatch-Value"),
		OpcRequestId: common.String("DCDXYZGMDXMOSAGJBLFO<unique_ID>"),
		UpdateDbSystemDetails: mysql.UpdateDbSystemDetails{NsgIds: []string{"EXAMPLE--Value"},
			Description:   common.String("EXAMPLE-description-Value"),
			IpAddress:     common.String("EXAMPLE-ipAddress-Value"),
			AdminUsername: common.String("EXAMPLE-adminUsername-Value"),
			ReadEndpoint: &mysql.UpdateReadEndpointDetails{ReadEndpointIpAddress: common.String("EXAMPLE-readEndpointIpAddress-Value"),
				ExcludeIps:                []string{"EXAMPLE--Value"},
				IsEnabled:                 common.Bool(true),
				ReadEndpointHostnameLabel: common.String("EXAMPLE-readEndpointHostnameLabel-Value")},
			FaultDomain:       common.String("EXAMPLE-faultDomain-Value"),
			FreeformTags:      map[string]string{"EXAMPLE_KEY_eX9FP": "EXAMPLE_VALUE_YQDjelTZQQqXPD51upqz"},
			IsHighlyAvailable: common.Bool(false),
			Maintenance:       &mysql.UpdateMaintenanceDetails{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")},
			DatabaseManagement: mysql.DatabaseManagementStatusDisabled,
			EncryptData: &mysql.EncryptDataDetails{KeyGenerationType: mysql.KeyGenerationTypeByok,
				KeyId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value")},
			CrashRecovery: mysql.CrashRecoveryStatusDisabled,
			DataStorage: &mysql.DataStorageDetails{MaxStorageSizeInGBs: common.Int(91257),
				IsAutoExpandStorageEnabled: common.Bool(true)},
			PortX:              common.Int(57859),
			AdminPassword:      common.String("EXAMPLE-adminPassword-Value"),
			AvailabilityDomain: common.String("EXAMPLE-availabilityDomain-Value"),
			DisplayName:        common.String("EXAMPLE-displayName-Value"),
			ShapeName:          common.String("EXAMPLE-shapeName-Value"),
			Port:               common.Int(13128),
			Rest: &mysql.UpdateRestDetails{Configuration: mysql.RestConfigurationTypeDbsystemOnly,
				Port: common.Int(65522)},
			CustomerContacts:     []mysql.CustomerContact{mysql.CustomerContact{Email: common.String("EXAMPLE-email-Value")}},
			DataStorageSizeInGBs: common.Int(115921),
			DatabaseMode:         mysql.DbSystemDatabaseModeWrite,
			SubnetId:             common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value"),
			AccessMode:           mysql.DbSystemAccessModeRestricted,
			ConfigurationId:      common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-configurationId-Value"),
			DeletionPolicy: &mysql.UpdateDeletionPolicyDetails{AutomaticBackupRetention: mysql.UpdateDeletionPolicyDetailsAutomaticBackupRetentionRetain,
				FinalBackup:       mysql.UpdateDeletionPolicyDetailsFinalBackupSkipFinalBackup,
				IsDeleteProtected: common.Bool(true)},
			HostnameLabel: common.String("EXAMPLE-hostnameLabel-Value"),
			BackupPolicy: &mysql.UpdateBackupPolicyDetails{DefinedTags: map[string]map[string]interface{}{"EXAMPLE_KEY_y9du0": map[string]interface{}{"EXAMPLE_KEY_gEU4S": "EXAMPLE--Value"}},
				FreeformTags:    map[string]string{"EXAMPLE_KEY_JnJU7": "EXAMPLE_VALUE_zPE8TObBTTrPqIxZtYs7"},
				IsEnabled:       common.Bool(false),
				PitrPolicy:      &mysql.PitrPolicy{IsEnabled: common.Bool(false)},
				RetentionInDays: common.Int(34),
				SoftDelete:      mysql.SoftDeleteEnabled,
				WindowStartTime: common.String("EXAMPLE-windowStartTime-Value"),
				CopyPolicies: []mysql.CopyPolicy{mysql.CopyPolicy{BackupCopyRetentionInDays: common.Int(26),
					CopyToRegion: common.String("EXAMPLE-copyToRegion-Value")}}},
			DefinedTags: map[string]map[string]interface{}{"EXAMPLE_KEY_6NzIr": map[string]interface{}{"EXAMPLE_KEY_Awfue": "EXAMPLE--Value"}}}}

	// Send the request using the service client
	resp, err := client.UpdateDbSystem(context.Background(), req)
	helpers.FatalIfError(err)

	// Retrieve value from the response.
	fmt.Println(resp)
}

Was this article helpful?