Skip to content

Latest commit

 

History

History
 
 

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 

terraform-google-sql for MSSQL Server

The following dependency must be available for SQL Server module:

Inputs

Name Description Type Default Required
activation_policy The activation policy for the master instance.Can be either ALWAYS, NEVER or ON_DEMAND. string "ALWAYS" no
additional_databases A list of databases to be created in your cluster object <list> no
additional_users A list of users to be created in your cluster object <list> no
authorized_gae_applications The authorized gae applications for the Cloud SQL instances list(string) <list> no
availability_type The availability type for the master instance.This is only used to set up high availability for the MSSQL instance. Can be either ZONAL or REGIONAL. string "ZONAL" no
create_timeout The optional timout that is applied to limit long database creates. string "15m" no
database_flags The database flags for the master instance. See more details object <list> no
database_version The database version to use: SQLSERVER_2017_STANDARD, SQLSERVER_2017_ENTERPRISE, SQLSERVER_2017_EXPRESS, or SQLSERVER_2017_WEB string "SQLSERVER_2017_STANDARD" no
db_charset The charset for the default database string "" no
db_collation The collation for the default database. Example: 'en_US.UTF8' string "" no
db_name The name of the default database to create string "default" no
delete_timeout The optional timout that is applied to limit long database deletes. string "30m" no
disk_autoresize Configuration to increase storage size. bool "true" no
disk_size The disk size for the master instance. string "10" no
disk_type The disk type for the master instance. string "PD_SSD" no
encryption_key_name The full path to the encryption key used for the CMEK disk encryption string "null" no
ip_configuration The ip configuration for the master instances. object <map> no
maintenance_window_day The day of week (1-7) for the master instance maintenance. number "1" no
maintenance_window_hour The hour of day (0-23) maintenance window for the master instance maintenance. number "23" no
maintenance_window_update_track The update track of maintenance window for the master instance maintenance.Can be either canary or stable. string "canary" no
module_depends_on List of modules or resources this module depends on. list(any) <list> no
name The name of the Cloud SQL resources string n/a yes
pricing_plan The pricing plan for the master instance. string "PER_USE" no
project_id The project ID to manage the Cloud SQL resources string n/a yes
random_instance_name Sets random suffix at the end of the Cloud SQL resource name bool "false" no
region The region of the Cloud SQL resources string "us-central1" no
root_password MSSERVER password for the root user. If not set, a random one will be generated and available in the root_password output variable. string "" no
tier The tier for the master instance. string "db-custom-2-3840" no
update_timeout The optional timout that is applied to limit long database updates. string "15m" no
user_labels The key/value labels for the master instances. map(string) <map> no
user_name The name of the default user string "default" no
user_password The password for the default user. If not set, a random one will be generated and available in the generated_user_password output variable. string "" no
zone The zone for the master instance. string "us-central1-a" no

Outputs

Name Description
generated_user_password The auto generated default user password if not input password was provided
instance_address The IPv4 addesses assigned for the master instance
instance_connection_name The connection name of the master instance to be used in connection strings
instance_first_ip_address The first IPv4 address of the addresses assigned.
instance_name The instance name for the master instance
instance_self_link The URI of the master instance
instance_server_ca_cert The CA certificate information used to connect to the SQL instance via SSL
instance_service_account_email_address The service account email address assigned to the master instance
private_address The private IP address assigned for the master instance
root_password MSSERVER password for the root user. If not set, a random one will be generated and available in the root_password output variable.