< Back

New-GcSqlInstanceConfig

Mon Jan 13, 2020 11:32 pm

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)