< Back
New-GcSqlInstanceConfig
Post
NAME New-GcSqlInstanceConfig
SYNOPSIS
Makes a new Google Cloud SQL instance description.
SYNTAX
New-GcSqlInstanceConfig [-Project <string>] [-Name] <string> -SettingConfig <Settings> [-DatabaseVer <string>]
[-MasterInstanceName <string>] [-FailoverReplica <string>] [-ReplicaConfig <ReplicaConfiguration>] [-Region
<string>] [<CommonParameters>]
DESCRIPTION
Makes a new Google Cloud SQL instance description. Use Add-GcSqlInstance to instantiate the instance within a
project.
PARAMETERS
-Project <string>
The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if
applicable.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Name <string>
Name of the Cloud SQL instance. This does not include the project ID.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SettingConfig <Settings>
The user settings. Can be created with New-GcSqlSettingConfig.
Required? true
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-DatabaseVer <string>
The database engine type and version. This cannot be changed after instance creation.
e.g. "MYSQL_5_6" or "MYSQL_5_7". Defaults to "MYSQL_5_7".
Required? false
Position? named
Default value MYSQL_5_7
Accept pipeline input? false
Accept wildcard characters? false
-MasterInstanceName <string>
The name of the instance which will act as master in the replication setup. Should only be used for
read-replica instances.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-FailoverReplica <string>
The name of the failover replica. If specified at instance creation, a failover replica is created for the
instance. This property is applicable only to Second Generation instances.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ReplicaConfig <ReplicaConfiguration>
The ReplicaConfiguration created by New-GcSqlInstanceReplicaConfig.
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Region <string>
The geographical region. Can be us-central1, asia-east1, or europe-west1.
Defaults to us-central1 and cannot be changed after instance creation.
Required? false
Position? named
Default value us-central1
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
Google.Apis.SQLAdmin.v1beta4.Data.Settings
The user settings. Can be created with New-GcSqlSettingConfig.
Google.Apis.SQLAdmin.v1beta4.Data.ReplicaConfiguration
The ReplicaConfiguration created by New-GcSqlInstanceReplicaConfig.
OUTPUTS
Google.Apis.SQLAdmin.v1beta4.Data.DatabaseInstance
---------- EXAMPLE 1 ----------
PS C:\\> New-GcSqlInstanceConfig "myInstance" $mySettings
Creates an instance resource with name "myInstance" and settings $mySettings
---------- EXAMPLE 2 ----------
PS C:\\> New-GcSqlInstanceConfig "myInstance" $mySettings -ReplicaConfig $myRepl
Creates an instance resource with name "myInstance", settings $mySettings, and replica configuration $myRepl
RELATED LINKS
[How-To: Setting up Instances] (https://cloud.google.com/tools/powershe ... /sql/setup)
[Instance Settings] (https://cloud.google.com/sql/docs/instance-settings)
SYNOPSIS
Makes a new Google Cloud SQL instance description.
SYNTAX
New-GcSqlInstanceConfig [-Project <string>] [-Name] <string> -SettingConfig <Settings> [-DatabaseVer <string>]
[-MasterInstanceName <string>] [-FailoverReplica <string>] [-ReplicaConfig <ReplicaConfiguration>] [-Region
<string>] [<CommonParameters>]
DESCRIPTION
Makes a new Google Cloud SQL instance description. Use Add-GcSqlInstance to instantiate the instance within a
project.
PARAMETERS
-Project <string>
The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if
applicable.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Name <string>
Name of the Cloud SQL instance. This does not include the project ID.
Required? true
Position? 0
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SettingConfig <Settings>
The user settings. Can be created with New-GcSqlSettingConfig.
Required? true
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-DatabaseVer <string>
The database engine type and version. This cannot be changed after instance creation.
e.g. "MYSQL_5_6" or "MYSQL_5_7". Defaults to "MYSQL_5_7".
Required? false
Position? named
Default value MYSQL_5_7
Accept pipeline input? false
Accept wildcard characters? false
-MasterInstanceName <string>
The name of the instance which will act as master in the replication setup. Should only be used for
read-replica instances.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-FailoverReplica <string>
The name of the failover replica. If specified at instance creation, a failover replica is created for the
instance. This property is applicable only to Second Generation instances.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ReplicaConfig <ReplicaConfiguration>
The ReplicaConfiguration created by New-GcSqlInstanceReplicaConfig.
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-Region <string>
The geographical region. Can be us-central1, asia-east1, or europe-west1.
Defaults to us-central1 and cannot be changed after instance creation.
Required? false
Position? named
Default value us-central1
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
Google.Apis.SQLAdmin.v1beta4.Data.Settings
The user settings. Can be created with New-GcSqlSettingConfig.
Google.Apis.SQLAdmin.v1beta4.Data.ReplicaConfiguration
The ReplicaConfiguration created by New-GcSqlInstanceReplicaConfig.
OUTPUTS
Google.Apis.SQLAdmin.v1beta4.Data.DatabaseInstance
---------- EXAMPLE 1 ----------
PS C:\\> New-GcSqlInstanceConfig "myInstance" $mySettings
Creates an instance resource with name "myInstance" and settings $mySettings
---------- EXAMPLE 2 ----------
PS C:\\> New-GcSqlInstanceConfig "myInstance" $mySettings -ReplicaConfig $myRepl
Creates an instance resource with name "myInstance", settings $mySettings, and replica configuration $myRepl
RELATED LINKS
[How-To: Setting up Instances] (https://cloud.google.com/tools/powershe ... /sql/setup)
[Instance Settings] (https://cloud.google.com/sql/docs/instance-settings)