Skip to content

Latest commit

 

History

History
89 lines (64 loc) · 4.12 KB

sqlserver.html.md

File metadata and controls

89 lines (64 loc) · 4.12 KB
Raw
layout page_title sidebar_current description
gridscale
gridscale: gridscale_sqlserver
docs-gridscale-resource-sqlserver
Manage a MS SQL server service in gridscale.

gridscale_sqlserver

Provides a MS SQL server resource. This can be used to create, modify, and delete MS SQL server instances.

Example

The following example shows how one might use this resource to add a MS SQL server service to gridscale:

resource "gridscale_sqlserver" "terra-sqlserver-test" {
  name = "test"
  release = "2019"
  performance_class = "standard"
  labels = ["test"]
}

Argument Reference

The following arguments are supported:

  • name - (Required) The human-readable name of the object. It supports the full UTF-8 character set, with a maximum of 64 characters.

  • release - (Required) The MS SQL server release of this instance. For convenience, please use gscloud to get the list of available MS SQL server service releases.

  • performance_class - (Required) Performance class of MS SQL server service. Available performance classes at the time of writing: standard, high, insane, ultra.

  • labels - (Optional) List of labels in the format [ "label1", "label2" ].

  • network_uuid - (Optional) The UUID of the network that the service is attached to.

  • security_zone_uuid - DEPRECATED (Optional, Forcenew) The UUID of the security zone that the service is attached to.

  • s3_backup - (Optional) Allow backup/restore MS SQL server to/from a S3 bucket.

    • backup_bucket - (Required) Object Storage bucket to upload backups to and restore backups from.

    • backup_retention - (Optional) Retention (in seconds) for local originals of backups. (0 for immediate removal once uploaded to Object Storage (default), higher values for delayed removal after the given time and once uploaded to Object Storage).

    • backup_access_key - (Required) Access key used to authenticate against Object Storage server.

    • backup_secret_key - (Required) Secret key used to authenticate against Object Storage server.

    • backup_server_url - (Optional, Default: "https://gos3.io/") Object Storage server URL the bucket is located on. Note: Currently, only object storage host "https://gos3.io/" is supported.

Timeouts

Timeouts configuration options (in seconds): More info: terraform.io/docs/configuration/resources.html#operation-timeouts

  • create - (Default value is "15m" - 15 minutes) Used for creating a resource.
  • update - (Default value is "15m" - 15 minutes) Used for updating a resource.
  • delete - (Default value is "15m" - 15 minutes) Used for deleting a resource.

Attributes

This resource exports the following attributes:

  • name - See Argument Reference above.
  • release - See Argument Reference above.
  • performance_class - See Argument Reference above.
  • username - Username for PaaS service. It is used to connect to the MS SQL server instance.
  • password - Password for PaaS service. It is used to connect to the MS SQL server instance.
  • listen_port - The port numbers where this MS SQL server service accepts connections.
    • name - Name of a port.
    • host - Host address.
    • listen_port - Port number.
  • s3_backup - See Argument Reference above.
    • backup_bucket - See Argument Reference above.
    • backup_access_key - See Argument Reference above.
    • backup_secret_key - See Argument Reference above.
    • backup_server_url - See Argument Reference above.
  • security_zone_uuid - See Argument Reference above.
  • network_uuid - The UUID of the network that the service is attached to or network UUID containing security zone.
  • service_template_uuid - PaaS service template that MS SQL server service uses.
  • service_template_category - The template service's category used to create the service.
  • usage_in_minutes - Number of minutes that PaaS service is in use.
  • change_time - Time of the last change.
  • create_time - Date time this service has been created.
  • status - Current status of PaaS service.
  • labels - See Argument Reference above.