REST Resource: projects.locations.preferenceSets

Resource: PreferenceSet

The preferences that apply to all assets in a given context.

JSON representation 
{
  "name": string,
  "createTime": string,
  "updateTime": string,
  "displayName": string,
  "description": string,
  "regionPreferences": {
    object (RegionPreferences)
  },
  "virtualMachinePreferences": {
    object (VirtualMachinePreferences)
  },
  "databasePreferences": {
    object (DatabasePreferences)
  }
}
Fields
name

string

Output only. Name of the PreferenceSet.
createTime

string (Timestamp format)

Output only. The timestamp when the preference set was created.

Uses RFC 3339, where generated output will always be Z-normalized and uses 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
updateTime

string (Timestamp format)

Output only. The timestamp when the preference set was last updated.

Uses RFC 3339, where generated output will always be Z-normalized and uses 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
displayName

string

User-friendly display name. Maximum length is 63 characters.
description

string

A description of the preference set.
regionPreferences

object (RegionPreferences)

Optional. Region preferences for assets using this preference set. If you are unsure which value to set, the migration service API region is often a good value to start with. If unspecified, VirtualMachinePreferences.RegionPreferences is used.
virtualMachinePreferences

object (VirtualMachinePreferences)

A set of preferences that applies to all virtual machines in the context.
databasePreferences

object (DatabasePreferences)

Optional. A set of preferences that applies to all databases in the context.

DatabasePreferences

DatabasePreferences enables you to create sets of preferences for your migrated databases.

JSON representation 
{
  "mssqlToCloudSqlForSqlServerPreferences": {
    object (SqlServer)
  },
  "mysqlToCloudSqlForMysqlPreferences": {
    object (MySql)
  },
  "postgresqlToCloudSqlForPostgresqlPreferences": {
    object (PostgreSql)
  }
}
Fields
mssqlToCloudSqlForSqlServerPreferences

object (SqlServer)

Optional. Preferences for target SQL Server on Cloud SQL when migrating from source Microsoft SQL server.
mysqlToCloudSqlForMysqlPreferences

object (MySql)

Optional. Preferences for target MySQL on Cloud SQL when migrating from source MySQL.
postgresqlToCloudSqlForPostgresqlPreferences

object (PostgreSql)

Optional. Preferences for target PostgreSQL on Cloud SQL when migrating from source PostgreSQL.

SqlServer

Preferences for SQL Server on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  },
  "multithreading": enum (Multithreading),
  "versionType": enum (VersionType)
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.
multithreading

enum (Multithreading)

Optional. Preferences for multithreading support.
versionType

enum (VersionType)

Optional. Edition of Microsoft SQL version that is used on a Cloud SQL for SQL server instance.

Common

Preferences common to Cloud SQL databases.

JSON representation 
{
  "backup": {
    object (Backup)
  },
  "commitmentPlan": enum (CommitmentPlan),
  "zoneAvailability": enum (CloudSqlZoneAvailability),
  "sizingOptimizationStrategy": enum (SizingOptimizationStrategy),
  "persistentDiskType": enum (PersistentDiskType),
  "edition": enum (CloudSqlEdition)
}
Fields
backup

object (Backup)

Optional. Preferences for database backups.
commitmentPlan

enum (CommitmentPlan)

Optional. Commitment plan to consider when calculating costs. Only regular CUDs (not flexible) are currently available.
zoneAvailability

enum (CloudSqlZoneAvailability)

Optional. Preferred zone availability.
sizingOptimizationStrategy

enum (SizingOptimizationStrategy)

Optional. Sizing optimization strategy of the database. Currently supported for Cloud SQL are just two values: SIZING_OPTIMIZATION_STRATEGY_MODERATE and SIZING_OPTIMIZATION_STRATEGY_SAME_AS_SOURCE.

SIZING_OPTIMIZATION_STRATEGY_UNSPECIFIED will behave like SIZING_OPTIMIZATION_STRATEGY_MODERATE.
persistentDiskType

enum (PersistentDiskType)

Optional. Persistent disk type to use. If unspecified, a disk type is recommended based on available usage data. For SQL Server, only SSD is available. For MySQL and PostgreSQL, only STANDARD (HDD) and SSD types are available.
edition

enum (CloudSqlEdition)

Optional. Preferred Cloud SQL edition.

Backup

Preferences for database backups.

JSON representation 
{
  "backupMode": enum (BackupMode)
}
Fields
backupMode

enum (BackupMode)

Optional. Automated backup mode.

BackupMode

Automated backup mode.

Enums
BACKUP_MODE_UNSPECIFIED An unspecified database backup mode.
BACKUP_MODE_DISABLED Automatic backups disabled, no additional charges for storage.
BACKUP_MODE_ENABLED Automatic backups enabled, there will be additional charges for storage.

Multithreading

Preferences for multithreading support. See https://cloud.google.com/sql/docs/sqlserver/create-instance#smt-create-instance for more details.

Enums
MULTITHREADING_UNSPECIFIED Same as MULTITHREADING_AUTO.
MULTITHREADING_DISABLED Disable simultaneous multithreading.
MULTITHREADING_ENABLED Enable simultaneous multithreading.
MULTITHREADING_DISABLED_WITH_COMPENSATION Disable simultaneous multithreading and increase number of VCPUs to compensate.

VersionType

Edition of Microsoft SQL Server version that is used on a Cloud SQL for SQL server instance.

Enums
VERSION_TYPE_UNSPECIFIED Unspecified SQL Server version type.
VERSION_TYPE_AUTO Version will be deduced from the source asset.
VERSION_TYPE_EXPRESS Version will be one of "Express" versions.
VERSION_TYPE_WEB Version will be one of "Web" versions.
VERSION_TYPE_STANDARD Version will be one of "Standard" versions.
VERSION_TYPE_ENTERPRISE Version will be one of "Enterprise" versions.

MySql

Preferences for MySQL on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  }
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.

PostgreSql

Preferences for PostgreSQL on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  }
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.

Methods

create

 Creates a new preference set in a given project and location.

delete

 Deletes a preference set.

get

 Gets the details of a preference set.

list

 Lists all the preference sets in a given project and location.

patch

 Updates the parameters of a preference set.