» flexibleengine_rds_instance_v1

Manages rds instance resource within FlexibleEngine

» Example Usage: Creating a PostgreSQL RDS instance 

data "flexibleengine_rds_flavors_v1" "flavor" {
    region = "eu-de"
    datastore_name = "PostgreSQL"
    datastore_version = "9.5.5"
    speccode = "rds.pg.s1.large.ha"
}

resource "flexibleengine_compute_secgroup_v2" "secgrp_rds" {
  name        = "secgrp-rds-instance"
  description = "Rds Security Group"
}

resource "flexibleengine_rds_instance_v1" "instance" {
  name = "rds-instance"
  datastore {
    type = "PostgreSQL"
    version = "9.5.5"
  }
  flavorref = "${data.flexibleengine_rds_flavors_v1.flavor.id}"
  volume {
    type = "COMMON"
    size = 200
  }
  region = "eu-de"
  availabilityzone = "eu-de-01"
  vpc = "c1095fe7-03df-4205-ad2d-6f4c181d436e"
  nics {
    subnetid = "b65f8d25-c533-47e2-8601-cfaa265a3e3e"
  }
  securitygroup {
    id = "${flexibleengine_compute_secgroup_v2.secgrp_rds.id}"
  }
  dbport = "8635"
  backupstrategy = {
    starttime = "04:00:00"
    keepdays = 4
  }
  dbrtpd = "Huangwei!120521"
  ha = {
    enable = true
    replicationmode = "async"
  }
  depends_on = ["flexibleengine_compute_secgroup_v2.secgrp_rds"]
}

» Example Usage: Creating a SQLServer RDS instance 

data "flexibleengine_rds_flavors_v1" "flavor" {
    region = "eu-west-0"
    datastore_name = "SQLServer"
    datastore_version = "2014 SP2 SE"
    speccode = "rds.mssql.s1.2xlarge"
}

resource "flexibleengine_compute_secgroup_v2" "secgrp_rds" {
  name        = "secgrp-rds-instance"
  description = "Rds Security Group"
}

resource "flexibleengine_rds_instance_v1" "instance" {
  name = "rds-instance"
  datastore {
    type = "SQLServer"
    version = "2014 SP2 SE"
  }
  flavorref = "${data.flexibleengine_rds_flavors_v1.flavor.id}"
  volume {
    type = "COMMON"
    size = 200
  }
  region = "eu-west-0"
  availabilityzone = "eu-west-0a"
  vpc = "c1095fe7-03df-4205-ad2d-6f4c181d436e"
  nics {
    subnetid = "b65f8d25-c533-47e2-8601-cfaa265a3e3e"
  }
  securitygroup {
    id = "${flexibleengine_compute_secgroup_v2.secgrp_rds.id}"
  }
  dbport = "8635"
  backupstrategy = {
    starttime = "04:00:00"
    keepdays = 4
  }
  dbrtpd = "Huangwei!120521"
  depends_on = ["flexibleengine_compute_secgroup_v2.secgrp_rds"]
}

» Example Usage: Creating a MySQL RDS instance 

data "flexibleengine_rds_flavors_v1" "flavor" {
    region = "eu-west-0"
    datastore_name = "MySQL"
    datastore_version = "5.6.30"
    speccode = "rds.mysql.s1.medium"
}

resource "flexibleengine_compute_secgroup_v2" "secgrp_rds" {
  name        = "secgrp-rds-instance"
  description = "Rds Security Group"
}

resource "flexibleengine_rds_instance_v1" "instance" {
  name = "rds-instance"
  datastore {
    type = "MySQL"
    version = "5.6.30"
  }
  flavorref = "${data.flexibleengine_rds_flavors_v1.flavor.id}"
  volume {
    type = "COMMON"
    size = 200
  }
  region = "eu-west-0"
  availabilityzone = "eu-west-0a"
  vpc = "c1095fe7-03df-4205-ad2d-6f4c181d436e"
  nics {
    subnetid = "b65f8d25-c533-47e2-8601-cfaa265a3e3e"
  }
  securitygroup {
    id = "${flexibleengine_compute_secgroup_v2.secgrp_rds.id}"
  }
  dbport = "8635"
  backupstrategy = {
    starttime = "04:00:00"
    keepdays = 4
  }
  dbrtpd = "Huangwei!120521"
  ha = {
    enable = true
    replicationmode = "async"
  }
  depends_on = ["flexibleengine_compute_secgroup_v2.secgrp_rds"]
}

» Argument Reference

The following arguments are supported:

  • name - (Required) Specifies the DB instance name. The DB instance name of the same type is unique in the same tenant. The changes of the instance name will be suppressed in HA scenario.

  • datastore - (Required) Specifies database information. The structure is described below.

  • flavorref - (Required) Specifies the specification ID (flavors.id in the response message in Obtaining All DB Instance Specifications). If you want to enable ha for the rds instance, a flavor with ha speccode is required.

  • volume - (Required) Specifies the volume information. The structure is described below.

  • region - (Required) Specifies the region ID.

  • availabilityzone - (Required) Specifies the ID of the AZ.

  • vpc - (Required) Specifies the VPC ID. For details about how to obtain this parameter value, see section "Virtual Private Cloud" in the Virtual Private Cloud API Reference.

  • nics - (Required) Specifies the nics information. For details about how to obtain this parameter value, see section "Subnet" in the Virtual Private Cloud API Reference. The structure is described below.

  • securitygroup - (Required) Specifies the security group which the RDS DB instance belongs to. The structure is described below.

  • dbport - (Optional) Specifies the database port number.

  • backupstrategy - (Optional) Specifies the advanced backup policy. The structure is described below.

  • dbrtpd - (Required) Specifies the password for user root of the database.

  • ha - (Optional) Specifies the parameters configured on HA and is used when creating HA DB instances. The structure is described below. NOTICE: RDS for Microsoft SQL Server does not support creating HA DB instances and this parameter is not involved.

The datastore block supports:

  • type - (Required) Specifies the DB engine. Currently, MySQL, PostgreSQL, and Microsoft SQL Server are supported. The value is MySQL, PostgreSQL, or SQLServer.

  • version - (Required) Specifies the DB instance version.

  • Available value for attributes

type version
PostgreSQL 9.5.5
9.6.3
9.6.5
MySQL 5.6.33
5.6.30
5.6.34
5.6.35
5.7.17
SQLServer 2014 SP2 SE

The volume block supports:

  • type - (Required) Specifies the volume type. Valid value: It must be COMMON (SATA) or ULTRAHIGH (SSD) and is case-sensitive.

  • size - (Required) Specifies the volume size. Its value must be a multiple of 10 and the value range is 100 GB to 2000 GB.

The nics block supports:

  • subnetId - (Required) Specifies the subnet ID obtained from the VPC.

The securitygroup block supports:

  • id - (Required) Specifies the ID obtained from the securitygroup.

The backupstrategy block supports:

  • starttime - (Optional) Indicates the backup start time that has been set. The backup task will be triggered within one hour after the backup start time. Valid value: The value cannot be empty. It must use the hh:mm:ss format and must be valid. The current time is the UTC time.

  • keepdays - (Optional) Specifies the number of days to retain the generated backup files. Its value range is 0 to 35. If this parameter is not specified or set to 0, the automated backup policy is disabled.

The ha block supports:

  • enable - (Optional) Specifies the configured parameters on the HA. Valid value: The value is true or false. The value true indicates creating HA DB instances. The value false indicates creating a single DB instance.

  • replicationmode - (Optional) Specifies the replication mode for the standby DB instance. The value cannot be empty. For MySQL, the value is async or semisync. For PostgreSQL, the value is async or sync.

» Attributes Reference

The following attributes are exported:

  • region - See Argument Reference above.
  • name - See Argument Reference above.
  • flavorref - See Argument Reference above.
  • volume - See Argument Reference above.
  • availabilityzone - See Argument Reference above.
  • vpc - See Argument Reference above.
  • nics - See Argument Reference above.
  • securitygroup - See Argument Reference above.
  • dbport - See Argument Reference above.
  • backupstrategy - See Argument Reference above.
  • dbrtpd - See Argument Reference above.
  • ha - See Argument Reference above.
  • status - Indicates the DB instance status.
  • hostname - Indicates the instance connection address. It is a blank string.
  • type - Indicates the DB instance type, which can be master or readreplica.
  • created - Indicates the creation time in the following format: yyyy-mm-dd Thh:mm:ssZ.
  • updated - Indicates the update time in the following format: yyyy-mm-dd Thh:mm:ssZ.

» Attributes Reference

The following attributes can be updated: