Skip to content

intel/terraform-intel-aws-mysql-parameter-group

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits

.github

.github

 
 

examples

examples

 
 

images

images

 
 

.editorconfig

.editorconfig

 
 

.gitignore

.gitignore

 
 

.pre-commit-config.yaml

.pre-commit-config.yaml

 
 

CODE_OF_CONDUCT.md

CODE_OF_CONDUCT.md

 
 

CONTRIBUTING.md

CONTRIBUTING.md

 
 

LICENSE.md

LICENSE.md

 
 

NOTICE.md

NOTICE.md

 
 

README.md

README.md

 
 

main.tf

main.tf

 
 

outputs.tf

outputs.tf

 
 

policies.md

policies.md

 
 

security.md

security.md

 
 

terraform-docs-setup.md

terraform-docs-setup.md

 
 

variables.tf

variables.tf

 
 

versions.tf

versions.tf

 
 

Repository files navigation

Intel Logo

Intel® Optimized Cloud Modules for Terraform

© Copyright 2024, Intel Corporation

AWS RDS MySQL module

Configuration in this directory creates an Amazon RDS instance parameter group for MySQL. This module is leveraged in a pre-existing Amazon RDS MySQL module. This module exposes the Optimizations by Intel for MySQL.

Usage

See example folder for creating the AWS RDS Paremeter group.

In order to utilize add the following lines to your current module above the rds_resource group.

main.tf

module "aws-mysql-parameter-group" {
  source   = "intel/terraform-intel-aws-mysql-parameter-group/intel" 
  }

Within the main.tf aws_db_instance resource block, edit the parameter_group_name to use the "module.aws-mysql-parameter-group.db_parameter_group_name"

resource "aws_db_instance" "mysql" {
  allocated_storage    = 10
  db_name              = "testmysqlrds"
  engine               = "mysql"
  engine_version       = "8.0"
  instance_class       = "db.m6i.large"
  username             = "admin25"
  password             = "var.db_password"
  parameter_group_name = module.aws-mysql-parameter-group.db_parameter_group_name
  skip_final_snapshot  = true
}

Considerations

Requirements

Name Version
terraform >=1.3.0
aws >= 5.31
random >= 3.4.3

Providers

Name Version
aws >= 5.31
random >= 3.4.3

Modules

No modules.

Resources

Name Type
aws_db_parameter_group.rds resource
random_id.rid resource

Inputs

Name Description Type Default Required
db_engine Database engine version for AWS database instance. string "mysql" no
db_parameter_group_family Family identifier for the RDS database parameter group. string "mysql8.0" no
db_parameter_group_name Name for the RDS database parameter group. string "mysql" no
db_parameters Intel Cloud optimizations for Xeon processors 
object({
    mysql = object({
      table_open_cache = optional(object({
        value        = optional(string, "8000")
        apply_method = optional(string, "immediate")
      }))
      table_open_cache_instances = optional(object({
        value        = optional(string, "16")
        apply_method = optional(string, "pending-reboot")
      }))
      max_connections = optional(object({
        value        = optional(string, "4000")
        apply_method = optional(string, "immediate")
      }))
      back_log = optional(object({
        value        = optional(string, "1500")
        apply_method = optional(string, "pending-reboot")
      }))
      default_password_lifetime = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "pending-reboot")
      }))
      performance_schema = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "pending-reboot")
      }))
      max_prepared_stmt_count = optional(object({
        value        = optional(string, "128000")
        apply_method = optional(string, "immediate")
      }))
      character_set_server = optional(object({
        value        = optional(string, "latin1")
        apply_method = optional(string, "immediate")
      }))
      collation_server = optional(object({
        value        = optional(string, "latin1_swedish_ci")
        apply_method = optional(string, "immediate")
      }))
      transaction_isolation = optional(object({
        value        = optional(string, "REPEATABLE-READ")
        apply_method = optional(string, "immediate")
      }))
      innodb_log_file_size = optional(object({
        value        = optional(string, 1024 * 1024 * 1024)
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_open_files = optional(object({
        value        = optional(string, "4000")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_file_per_table = optional(object({
        value        = optional(string, "1")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_buffer_pool_instances = optional(object({
        value        = optional(string, "16")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_buffer_pool_size = optional(object({
        value        = optional(string, "{DBInstanceClassMemory*3/4}")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_log_buffer_size = optional(object({
        value        = optional(string, "67108864")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_thread_concurrency = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "immediate")
      }))
      innodb_flush_log_at_trx_commit = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "immediate")
      }))
      innodb_max_dirty_pages_pct = optional(object({
        value        = optional(string, "90")
        apply_method = optional(string, "immediate")
      }))
      innodb_max_dirty_pages_pct_lwm = optional(object({
        value        = optional(string, "10")
        apply_method = optional(string, "immediate")
      }))
      join_buffer_size = optional(object({
        value        = optional(string, 32 * 1024)
        apply_method = optional(string, "immediate")
      }))
      sort_buffer_size = optional(object({
        value        = optional(string, 32 * 1024)
        apply_method = optional(string, "immediate")
      }))
      innodb_use_native_aio = optional(object({
        value        = optional(string, "1")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_stats_persistent = optional(object({
        value        = optional(string, "ON")
        apply_method = optional(string, "immediate")
      }))
      innodb_spin_wait_delay = optional(object({
        value        = optional(string, "6")
        apply_method = optional(string, "immediate")
      }))
      innodb_max_purge_lag_delay = optional(object({
        value        = optional(string, "300000")
        apply_method = optional(string, "immediate")
      }))
      innodb_max_purge_lag = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "immediate")
      }))
      innodb_checksum_algorithm = optional(object({
        value        = optional(string, "none")
        apply_method = optional(string, "immediate")
      }))
      innodb_io_capacity = optional(object({
        value        = optional(string, "4000")
        apply_method = optional(string, "immediate")
      }))
      innodb_io_capacity_max = optional(object({
        value        = optional(string, "20000")
        apply_method = optional(string, "immediate")
      }))
      innodb_lru_scan_depth = optional(object({
        value        = optional(string, "9000")
        apply_method = optional(string, "immediate")
      }))
      innodb_change_buffering = optional(object({
        value        = optional(string, "none")
        apply_method = optional(string, "immediate")
      }))
      innodb_page_cleaners = optional(object({
        value        = optional(string, "4")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_undo_log_truncate = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_adaptive_flushing = optional(object({
        value        = optional(string, "1")
        apply_method = optional(string, "immediate")
      }))
      innodb_flush_neighbors = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "immediate")
      }))
      innodb_read_io_threads = optional(object({
        value        = optional(string, "16")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_write_io_threads = optional(object({
        value        = optional(string, "16")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_purge_threads = optional(object({
        value        = optional(string, "4")
        apply_method = optional(string, "pending-reboot")
      }))
      innodb_adaptive_hash_index = optional(object({
        value        = optional(string, "0")
        apply_method = optional(string, "immediate")
      }))
    })
  })
 
{
  "mysql": {
    "back_log": {},
    "character_set_server": {},
    "collation_server": {},
    "default_password_lifetime": {},
    "innodb_adaptive_flushing": {},
    "innodb_adaptive_hash_index": {},
    "innodb_buffer_pool_instances": {},
    "innodb_buffer_pool_size": {},
    "innodb_change_buffering": {},
    "innodb_checksum_algorithm": {},
    "innodb_file_per_table": {},
    "innodb_flush_log_at_trx_commit": {},
    "innodb_flush_neighbors": {},
    "innodb_io_capacity": {},
    "innodb_io_capacity_max": {},
    "innodb_log_buffer_size": {},
    "innodb_log_file_size": {},
    "innodb_lru_scan_depth": {},
    "innodb_max_dirty_pages_pct": {},
    "innodb_max_dirty_pages_pct_lwm": {},
    "innodb_max_purge_lag": {},
    "innodb_max_purge_lag_delay": {},
    "innodb_open_files": {},
    "innodb_page_cleaners": {},
    "innodb_purge_threads": {},
    "innodb_read_io_threads": {},
    "innodb_spin_wait_delay": {},
    "innodb_stats_persistent": {},
    "innodb_thread_concurrency": {},
    "innodb_undo_log_truncate": {},
    "innodb_use_native_aio": {},
    "innodb_write_io_threads": {},
    "join_buffer_size": {},
    "max_connections": {},
    "max_prepared_stmt_count": {},
    "performance_schema": {},
    "sort_buffer_size": {},
    "table_open_cache": {},
    "table_open_cache_instances": {},
    "transaction_isolation": {}
  }
}
 no
db_user_parameters "Customer provided db parameters. These should adhere to a similar structure as the above map.
db_user_parameters = {
db_param_user = {
"apply_method" = "immediate"
"value" = "1"
}
other_db_param = {
apply_method = "immediate"
value = "3.50"
}		 map(any) {} no

Outputs

Name Description
db_parameter_group_name Parameter group that was created

About

Intel Cloud Optimization Module - AWS MySQL Parameter Group

Resources

Readme

License

Apache-2.0 license

Code of conduct

Code of conduct

Security policy

Security policy
Activity
Custom properties

Stars

2 stars

Watchers

5 watching

Forks

0 forks
Report repository

Releases 4

v2.1.0 Latest
Feb 15, 2024
+ 3 releases

Packages

No packages published

Contributors 6

Languages