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
active_directory_config Active domain that the SQL instance will join. map(string) {} no
additional_databases A list of databases to be created in your cluster
list(object({
name = string
charset = string
collation = string
}))
[] no
additional_users A list of users to be created in your cluster
list(object({
name = string
password = string
}))
[] 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
backup_configuration The database backup configuration.
object({
binary_log_enabled = bool
enabled = bool
point_in_time_recovery_enabled = bool
start_time = string
transaction_log_retention_days = string
retained_backups = number
retention_unit = string
})
{
"binary_log_enabled": null,
"enabled": false,
"point_in_time_recovery_enabled": null,
"retained_backups": null,
"retention_unit": null,
"start_time": null,
"transaction_log_retention_days": null
}
no
create_timeout The optional timeout that is applied to limit long database creates. string "15m" no
database_flags The database flags for the master instance. See more details
list(object({
name = string
value = string
}))
[] 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 timeout that is applied to limit long database deletes. string "30m" no
deletion_protection Used to block Terraform from deleting a SQL Instance. bool true no
disk_autoresize Configuration to increase storage size. bool true no
disk_autoresize_limit The maximum size to which storage can be auto increased. number 0 no
disk_size The disk size for the master instance. number 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({
authorized_networks = list(map(string))
ipv4_enabled = bool
private_network = string
require_ssl = bool
allocated_ip_range = string
})
{
"allocated_ip_range": null,
"authorized_networks": [],
"ipv4_enabled": true,
"private_network": null,
"require_ssl": null
}
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) [] 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
sql_server_audit_config Active domain that the SQL instance will join. map(string) {} no
tier The tier for the master instance. string "db-custom-2-3840" no
update_timeout The optional timeout that is applied to limit long database updates. string "15m" no
user_labels The key/value labels for the master instances. map(string) {} 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
additional_users List of maps of additional users and passwords
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
primary The google_sql_database_instance resource representing the primary 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.