Skip to content

intel/terraform-intel-aws-postgresql-parameter-group

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits

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 Postgresql module

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

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-postgresql-parameter-group" {
  source   = "intel/terraform-intel-aws-postgresql-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" "example" {
  identifier                = "my-postgresql-db"
  engine                    = "postgres"
  engine_version            = "14.7"
  instance_class            = "db.m5i.large"
  allocated_storage         = 20
  storage_type              = "gp2"
  publicly_accessible       = false
  db_subnet_group_name      = aws_db_subnet_group.example.name
  vpc_security_group_ids    = [aws_security_group.example.id]
  name                      = "testpostgresql"
  username                  = "myusername"
  password                  = "var.db_password"
  parameter_group_name      = module.aws-postgresql-parameter-group.db_parameter_group_name
}

Considerations

Requirements

Name Version
terraform >=1.3.0
aws ~> 4.36.0
random ~>3.4.3

Providers

Name Version
aws ~> 4.36.0
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, "64424509440") # 60 Gigabytes #Calculator https://convertlive.com/u/convert/gigabytes/to/bytes
        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 PostgreSQL Parameter Group

Resources

Readme

License

Apache-2.0 license

Code of conduct

Code of conduct

Security policy

Security policy
Activity
Custom properties

Stars

1 star

Watchers

5 watching

Forks

0 forks
Report repository

Releases 2

v1.1.0 Latest
Feb 7, 2024
+ 1 release

Packages

No packages published

Contributors 5

Languages