pulumi-gcp-kotlin/com.pulumi.gcp.sql.kotlin.outputs/GetDatabaseInstanceSetting

GetDatabaseInstanceSetting

data class GetDatabaseInstanceSetting(val activationPolicy: String, val activeDirectoryConfigs: List<GetDatabaseInstanceSettingActiveDirectoryConfig>, val advancedMachineFeatures: List<GetDatabaseInstanceSettingAdvancedMachineFeature>, val availabilityType: String, val backupConfigurations: List<GetDatabaseInstanceSettingBackupConfiguration>, val collation: String, val connectionPoolConfigs: List<GetDatabaseInstanceSettingConnectionPoolConfig>, val connectorEnforcement: String, val dataCacheConfigs: List<GetDatabaseInstanceSettingDataCacheConfig>, val dataDiskProvisionedIops: Int, val dataDiskProvisionedThroughput: Int, val databaseFlags: List<GetDatabaseInstanceSettingDatabaseFlag>, val deletionProtectionEnabled: Boolean, val denyMaintenancePeriods: List<GetDatabaseInstanceSettingDenyMaintenancePeriod>, val diskAutoresize: Boolean, val diskAutoresizeLimit: Int, val diskSize: Int, val diskType: String, val edition: String, val enableDataplexIntegration: Boolean, val enableGoogleMlIntegration: Boolean, val insightsConfigs: List<GetDatabaseInstanceSettingInsightsConfig>, val ipConfigurations: List<GetDatabaseInstanceSettingIpConfiguration>, val locationPreferences: List<GetDatabaseInstanceSettingLocationPreference>, val maintenanceWindows: List<GetDatabaseInstanceSettingMaintenanceWindow>, val passwordValidationPolicies: List<GetDatabaseInstanceSettingPasswordValidationPolicy>, val pricingPlan: String, val retainBackupsOnDelete: Boolean, val sqlServerAuditConfigs: List<GetDatabaseInstanceSettingSqlServerAuditConfig>, val tier: String, val timeZone: String, val userLabels: Map<String, String>, val version: Int)

Constructors

Types

Companion

object Companion

Properties

activationPolicy

val activationPolicy: String

This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.

activeDirectoryConfigs

val activeDirectoryConfigs: List<GetDatabaseInstanceSettingActiveDirectoryConfig>

advancedMachineFeatures

val advancedMachineFeatures: List<GetDatabaseInstanceSettingAdvancedMachineFeature>

availabilityType

val availabilityType: String

The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.

backupConfigurations

val backupConfigurations: List<GetDatabaseInstanceSettingBackupConfiguration>

collation

val collation: String

The name of server instance collation.

connectionPoolConfigs

val connectionPoolConfigs: List<GetDatabaseInstanceSettingConnectionPoolConfig>

The managed connection pool setting for a Cloud SQL instance.

connectorEnforcement

val connectorEnforcement: String

Enables the enforcement of Cloud SQL Auth Proxy or Cloud SQL connectors for all the connections. If enabled, all the direct connections are rejected.

databaseFlags

val databaseFlags: List<GetDatabaseInstanceSettingDatabaseFlag>

dataCacheConfigs

val dataCacheConfigs: List<GetDatabaseInstanceSettingDataCacheConfig>

Data cache configurations.

dataDiskProvisionedIops

val dataDiskProvisionedIops: Int

Provisioned number of I/O operations per second for the data disk. This field is only used for HYPERDISK_BALANCED disk types.

dataDiskProvisionedThroughput

val dataDiskProvisionedThroughput: Int

Provisioned throughput measured in MiB per second for the data disk. This field is only used for HYPERDISK_BALANCED disk types.

deletionProtectionEnabled

val deletionProtectionEnabled: Boolean

Configuration to protect against accidental instance deletion.

denyMaintenancePeriods

val denyMaintenancePeriods: List<GetDatabaseInstanceSettingDenyMaintenancePeriod>

diskAutoresize

val diskAutoresize: Boolean

Enables auto-resizing of the storage size. Defaults to true.

diskAutoresizeLimit

val diskAutoresizeLimit: Int

The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.

diskSize

val diskSize: Int

The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB for PD_SSD, PD_HDD and 20GB for HYPERDISK_BALANCED.

diskType

val diskType: String

The type of supported data disk is tier dependent and can be PD_SSD or PD_HDD or HYPERDISK_BALANCED.

edition

val edition: String

The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.

enableDataplexIntegration

val enableDataplexIntegration: Boolean

Enables Dataplex Integration.

enableGoogleMlIntegration

val enableGoogleMlIntegration: Boolean

Enables Vertex AI Integration.

insightsConfigs

val insightsConfigs: List<GetDatabaseInstanceSettingInsightsConfig>

Configuration of Query Insights.

ipConfigurations

val ipConfigurations: List<GetDatabaseInstanceSettingIpConfiguration>

locationPreferences

val locationPreferences: List<GetDatabaseInstanceSettingLocationPreference>

maintenanceWindows

val maintenanceWindows: List<GetDatabaseInstanceSettingMaintenanceWindow>

Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.

passwordValidationPolicies

val passwordValidationPolicies: List<GetDatabaseInstanceSettingPasswordValidationPolicy>

pricingPlan

val pricingPlan: String

Pricing plan for this instance, can only be PER_USE.

retainBackupsOnDelete

val retainBackupsOnDelete: Boolean

When this parameter is set to true, Cloud SQL retains backups of the instance even after the instance is deleted. The ON_DEMAND backup will be retained until customer deletes the backup or the project. The AUTOMATED backup will be retained based on the backups retention setting.

sqlServerAuditConfigs

val sqlServerAuditConfigs: List<GetDatabaseInstanceSettingSqlServerAuditConfig>

tier

val tier: String

The machine type to use. See tiers for more details and supported versions. Postgres supports only shared-core machine types, and custom machine types such as db-custom-2-13312. See the Custom Machine Type Documentation to learn about specifying custom machine types.

timeZone

val timeZone: String

The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.

userLabels

val userLabels: Map<String, String>

A set of key/value user label pairs to assign to the instance.

version

val version: Int

Used to make sure changes to the settings block are atomic.