Skip to content

Latest commit

 

History

History
89 lines (64 loc) · 4 KB

mysql8_0.html.md

File metadata and controls

89 lines (64 loc) · 4 KB
Raw
layout page_title sidebar_current description
gridscale
gridscale: gridscale_mysql8_0
docs-gridscale-resource-mysql8_0
Manage a MySQL 8.0 service in gridscale.

gridscale_mysql8_0

Provides a MySQL 8.0 resource. This can be used to create, modify, and delete MySQL 8.0 instances.

Example

The following example shows how one might use this resource to add a MySQL 8.0 service to gridscale:

resource "gridscale_mysql8_0" "terra-mysql-test" {
  name = "my mysql"
	release = "8.0"
	performance_class = "insane"
  max_core_count = 20
	mysql_default_time_zone = "Europe/Berlin"
}

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 mysql release of this instance. For convenience, please use gscloud to get the list of available mysql service releases.

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

  • mysql_sql_mode - (Optional) mysql parameter: SQL Mode. Default: "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION".

  • mysql_max_connections - (Optional) mysql parameter: Max Connections. Default: 4000.

  • mysql_default_time_zone - (Optional) mysql parameter: Server Timezone. Default: UTC.

  • mysql_max_allowed_packet - (Optional) mysql parameter: Max Allowed Packet Size. Format: xM (where x is an integer, M stands for unit: k(kB), M(MB), G(GB)). Default: 64M.

  • 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.

  • max_core_count - (Optional) Maximum CPU core count. The mysql instance's CPU core count will be autoscaled based on the workload. The number of cores stays between 1 and max_core_count.

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.
  • mysql_sql_mode - See Argument Reference above.
  • mysql_max_connections - See Argument Reference above.
  • mysql_default_time_zone - See Argument Reference above.
  • mysql_max_allowed_packet - See Argument Reference above.
  • username - Username for PaaS service. It is used to connect to the mysql instance.
  • password - Password for PaaS service. It is used to connect to the mysql instance.
  • listen_port - The port numbers where this mysql service accepts connections.
    • name - Name of a port.
    • host - Host address.
    • listen_port - Port number.
  • 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 mysql 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.
  • max_core_count - See Argument Reference above.
  • labels - See Argument Reference above.