< Back
New-GcSqlSettingConfig
Post
NAME New-GcSqlSettingConfig
SYNOPSIS
Makes a new Google Cloud SQL Instance Settings configuration for a second generation instance.
SYNTAX
New-GcSqlSettingConfig [[-TierConfig] <string>] [-Policy {ALWAYS | NONE}] [-BinaryLogEnabled <bool>]
[-BackupConfigEnabled <bool>] [-BackupConfigStartTime <string>] [-DataDiskSizeGb <long>] [-DatabaseFlag
<DatabaseFlags[]>] [-IpConfigAuthorizedNetwork <AclEntry[]>] [-IpConfigIpv4Enabled <SwitchParameter>]
[-IpConfigRequireSsl <SwitchParameter>] [-LocationPreferenceFollowGae <string>] [-LocationPreferenceZone <string>]
[-MaintenanceWindowDay <int>] [-MaintenanceWindowHour <int>] [-StorageAutoResize <SwitchParameter>] [-DiskType
{PD_SSD | PD_HDD}] [<CommonParameters>]
DESCRIPTION
Creates a settings configuration specified by the passed in parameters. Meant to be only for Second generation
instances. Can be pipelined into New-GcSqlInstanceConfig.
NOTE: If any parameter is incorrect/invalid, this cmdlet not fail. You will only receive an error once you try to
update or add an instance with this configuration to your project.
PARAMETERS
-TierConfig <string>
The tier of service for this instance, for example "db-n1-standard-1". Pricing information is available at
https://cloud.google.com/sql/pricing. Get-GcSqlTiers will also tell you what tiers are available for your
project. Defaults to "db-n1-standard-1"
Required? false
Position? 0
Default value db-n1-standard-1
Accept pipeline input? false
Accept wildcard characters? false
-Policy <ActivationPolicy>
The activation policy specifies when the instance is activated; it is applicable only when the instance state
is RUNNABLE. Can be ALWAYS, or NEVER. Defaults to ALWAYS
Possible values: ALWAYS, NONE
Required? false
Position? named
Default value ALWAYS
Accept pipeline input? false
Accept wildcard characters? false
-BinaryLogEnabled <bool>
Whether binary log is enabled. If backup configuration is disabled, binary log must be disabled as well.
Defaults to true for non-replica instances.
Required? false
Position? named
Default value True
Accept pipeline input? false
Accept wildcard characters? false
-BackupConfigEnabled <bool>
Whether the backup configuration is enabled or not. Defaults to true for non-replica instances.
Required? false
Position? named
Default value True
Accept pipeline input? false
Accept wildcard characters? false
-BackupConfigStartTime <string>
Start time for the daily backup configuration in UTC timezone in the 24 hour format - HH:MM Defaults to 22:00
Required? false
Position? named
Default value 22:00
Accept pipeline input? false
Accept wildcard characters? false
-DataDiskSizeGb <long>
The size of data disk, in GB. The data disk size minimum is 10 GB. (Defaults to 50).
Required? false
Position? named
Default value 50
Accept pipeline input? false
Accept wildcard characters? false
-DatabaseFlag <DatabaseFlags[]>
The database flags passed to the instance at startup. Defaults to an empty list.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigAuthorizedNetwork <AclEntry[]>
The list of external networks that are allowed to connect to the instance using the IP. In CIDR notation, also
known as 'slash' notation (e.g. "192.168.100.0/24"). May include other ipConfiguration params, but unsure.
Defaults to an empty list.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigIpv4Enabled <SwitchParameter>
Whether the instance should be assigned an IP address or not. Defaults to false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigRequireSsl <SwitchParameter>
Whether the mysqld should default to ???????REQUIRE X509??????? for users connecting over IP. Defaults to false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-LocationPreferenceFollowGae <string>
The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LocationPreferenceZone <string>
The preferred Compute Engine Zone (e.g. us-central1-a, us-central1-b, etc.).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-MaintenanceWindowDay <int>
Day of the week (1-7) starting monday that the instance may be restarted for maintenance purposes. Defaults to
5 (Friday).
Required? false
Position? named
Default value 5
Accept pipeline input? false
Accept wildcard characters? false
-MaintenanceWindowHour <int>
Hour of day (0-23) that the instance may be restarted for maintenance purposes. Defaults to 22;
Required? false
Position? named
Default value 22
Accept pipeline input? false
Accept wildcard characters? false
-StorageAutoResize <SwitchParameter>
Configuration to increase storage size automatically. The default value is false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-DiskType <DataDiskType>
The type of data disk: PD_SSD (default) or PD_HDD.
Possible values: PD_SSD, PD_HDD
Required? false
Position? named
Default value PD_SSD
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Google.Apis.SQLAdmin.v1beta4.Data.Settings
---------- EXAMPLE 1 ----------
PS C:\\> New-GcSqlSettingConfig "db-n1-standard-1"
Creates a settings resource with tier "db-n1-standard-1".
---------- EXAMPLE 2 ----------
PS C:\\> New-GcSqlSettingConfig "db-n1-standard-1" -MaintenanceWindowDay 1 -MaintenanceWindowHour "22:00"
Creates a settings resource with tier "db-n1-standard-1", and a maintenance window on monday at 22:00.
RELATED LINKS
[Instance Settings] (https://cloud.google.com/sql/docs/instance-settings)
SYNOPSIS
Makes a new Google Cloud SQL Instance Settings configuration for a second generation instance.
SYNTAX
New-GcSqlSettingConfig [[-TierConfig] <string>] [-Policy {ALWAYS | NONE}] [-BinaryLogEnabled <bool>]
[-BackupConfigEnabled <bool>] [-BackupConfigStartTime <string>] [-DataDiskSizeGb <long>] [-DatabaseFlag
<DatabaseFlags[]>] [-IpConfigAuthorizedNetwork <AclEntry[]>] [-IpConfigIpv4Enabled <SwitchParameter>]
[-IpConfigRequireSsl <SwitchParameter>] [-LocationPreferenceFollowGae <string>] [-LocationPreferenceZone <string>]
[-MaintenanceWindowDay <int>] [-MaintenanceWindowHour <int>] [-StorageAutoResize <SwitchParameter>] [-DiskType
{PD_SSD | PD_HDD}] [<CommonParameters>]
DESCRIPTION
Creates a settings configuration specified by the passed in parameters. Meant to be only for Second generation
instances. Can be pipelined into New-GcSqlInstanceConfig.
NOTE: If any parameter is incorrect/invalid, this cmdlet not fail. You will only receive an error once you try to
update or add an instance with this configuration to your project.
PARAMETERS
-TierConfig <string>
The tier of service for this instance, for example "db-n1-standard-1". Pricing information is available at
https://cloud.google.com/sql/pricing. Get-GcSqlTiers will also tell you what tiers are available for your
project. Defaults to "db-n1-standard-1"
Required? false
Position? 0
Default value db-n1-standard-1
Accept pipeline input? false
Accept wildcard characters? false
-Policy <ActivationPolicy>
The activation policy specifies when the instance is activated; it is applicable only when the instance state
is RUNNABLE. Can be ALWAYS, or NEVER. Defaults to ALWAYS
Possible values: ALWAYS, NONE
Required? false
Position? named
Default value ALWAYS
Accept pipeline input? false
Accept wildcard characters? false
-BinaryLogEnabled <bool>
Whether binary log is enabled. If backup configuration is disabled, binary log must be disabled as well.
Defaults to true for non-replica instances.
Required? false
Position? named
Default value True
Accept pipeline input? false
Accept wildcard characters? false
-BackupConfigEnabled <bool>
Whether the backup configuration is enabled or not. Defaults to true for non-replica instances.
Required? false
Position? named
Default value True
Accept pipeline input? false
Accept wildcard characters? false
-BackupConfigStartTime <string>
Start time for the daily backup configuration in UTC timezone in the 24 hour format - HH:MM Defaults to 22:00
Required? false
Position? named
Default value 22:00
Accept pipeline input? false
Accept wildcard characters? false
-DataDiskSizeGb <long>
The size of data disk, in GB. The data disk size minimum is 10 GB. (Defaults to 50).
Required? false
Position? named
Default value 50
Accept pipeline input? false
Accept wildcard characters? false
-DatabaseFlag <DatabaseFlags[]>
The database flags passed to the instance at startup. Defaults to an empty list.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigAuthorizedNetwork <AclEntry[]>
The list of external networks that are allowed to connect to the instance using the IP. In CIDR notation, also
known as 'slash' notation (e.g. "192.168.100.0/24"). May include other ipConfiguration params, but unsure.
Defaults to an empty list.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigIpv4Enabled <SwitchParameter>
Whether the instance should be assigned an IP address or not. Defaults to false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-IpConfigRequireSsl <SwitchParameter>
Whether the mysqld should default to ???????REQUIRE X509??????? for users connecting over IP. Defaults to false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-LocationPreferenceFollowGae <string>
The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LocationPreferenceZone <string>
The preferred Compute Engine Zone (e.g. us-central1-a, us-central1-b, etc.).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-MaintenanceWindowDay <int>
Day of the week (1-7) starting monday that the instance may be restarted for maintenance purposes. Defaults to
5 (Friday).
Required? false
Position? named
Default value 5
Accept pipeline input? false
Accept wildcard characters? false
-MaintenanceWindowHour <int>
Hour of day (0-23) that the instance may be restarted for maintenance purposes. Defaults to 22;
Required? false
Position? named
Default value 22
Accept pipeline input? false
Accept wildcard characters? false
-StorageAutoResize <SwitchParameter>
Configuration to increase storage size automatically. The default value is false.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-DiskType <DataDiskType>
The type of data disk: PD_SSD (default) or PD_HDD.
Possible values: PD_SSD, PD_HDD
Required? false
Position? named
Default value PD_SSD
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Google.Apis.SQLAdmin.v1beta4.Data.Settings
---------- EXAMPLE 1 ----------
PS C:\\> New-GcSqlSettingConfig "db-n1-standard-1"
Creates a settings resource with tier "db-n1-standard-1".
---------- EXAMPLE 2 ----------
PS C:\\> New-GcSqlSettingConfig "db-n1-standard-1" -MaintenanceWindowDay 1 -MaintenanceWindowHour "22:00"
Creates a settings resource with tier "db-n1-standard-1", and a maintenance window on monday at 22:00.
RELATED LINKS
[Instance Settings] (https://cloud.google.com/sql/docs/instance-settings)