aws_db_option_group

Provides an RDS DB option group resource. Documentation of the available options for various RDS engines can be found at: * MariaDB Options * Microsoft SQL Server Options * MySQL Options * Oracle Options

Example Usage

resource "aws_db_option_group" "example" {
  name                     = "option-group-test-terraform"
  option_group_description = "Terraform Option Group"
  engine_name              = "sqlserver-ee"
  major_engine_version     = "11.00"

  option {
    option_name = "Timezone"

    option_settings {
      name  = "TIME_ZONE"
      value = "UTC"
    }
  }

  option {
    option_name = "SQLSERVER_BACKUP_RESTORE"

    option_settings {
      name  = "IAM_ROLE_ARN"
      value = "${aws_iam_role.example.arn}"
    }
  }

  option {
    option_name = "TDE"
  }
}

Argument Reference

The following arguments are supported:

  • name - (Optional, Forces new resource) The name of the option group. If omitted, Terraform will assign a random, unique name. Must be lowercase, to match as it is stored in AWS.
  • name_prefix - (Optional, Forces new resource) Creates a unique name beginning with the specified prefix. Conflicts with name. Must be lowercase, to match as it is stored in AWS.
  • option_group_description - (Optional) The description of the option group. Defaults to "Managed by Terraform".
  • engine_name - (Required) Specifies the name of the engine that this option group should be associated with.
  • major_engine_version - (Required) Specifies the major version of the engine that this option group should be associated with.
  • option - (Optional) A list of Options to apply.
  • tags - (Optional) A mapping of tags to assign to the resource.

Option blocks support the following:

  • option_name - (Required) The Name of the Option (e.g. MEMCACHED).
  • option_settings - (Optional) A list of option settings to apply.
  • port - (Optional) The Port number when connecting to the Option (e.g. 11211).
  • version - (Optional) The version of the option (e.g. 13.1.0.0).
  • db_security_group_memberships - (Optional) A list of DB Security Groups for which the option is enabled.
  • vpc_security_group_memberships - (Optional) A list of VPC Security Groups for which the option is enabled.

Option Settings blocks support the following:

  • name - (Optional) The Name of the setting.
  • value - (Optional) The Value of the setting.

Attributes Reference

In addition to all arguments above, the following attributes are exported:

  • id - The db option group name.
  • arn - The ARN of the db option group.

Timeouts

aws_db_option_group provides the following Timeouts configuration options:

  • delete - (Default 15 minutes)

Import

DB Option groups can be imported using the name, e.g.

$ terraform import aws_db_option_group.bar mysql-option-group

© 2018 HashiCorp
Licensed under the MPL 2.0 License.
https://www.terraform.io/docs/providers/aws/r/db_option_group.html