Parameter groups and option groups in AWS - Mini Project: Build & Apply

AWS RDS Parameter Groups and Option Groups Setup

📖 Scenario: You are setting up an AWS RDS database instance for a small business application. To customize the database behavior and enable additional features, you need to create a parameter group and an option group.This setup helps you control database settings and add extra capabilities like encryption or monitoring.

🎯 Goal: Create an AWS RDS parameter group with specific parameters, then create an option group with a chosen option, and finally associate both groups with a new RDS instance.

📋 What You'll Learn

Create a DB parameter group named mydb-parameter-group for MySQL 8.0

Set the parameter max_connections to 150 in the parameter group

Create a DB option group named mydb-option-group for MySQL 8.0

Add the option MEMCACHED to the option group

Create an RDS DB instance named mydbinstance using the created parameter and option groups

💡 Why This Matters

🌍 Real World

Customizing RDS instances with parameter and option groups is common in real projects to meet application requirements and enable features.

💼 Career

Understanding how to configure parameter and option groups is essential for cloud engineers managing AWS RDS databases.

1

Create the DB parameter group

Create a DB parameter group named mydb-parameter-group for engine mysql version 8.0.

AWS

# Your code here to create the DB parameter group

Need a hint?

Use the aws_db_parameter_group resource with the exact name and family values.

2

Add a parameter to the parameter group

Add a parameter to aws_db_parameter_group.mydb_parameter_group setting max_connections to 150.

AWS

resource "aws_db_parameter_group" "mydb_parameter_group" {
  name        = "mydb-parameter-group"
  family      = "mysql8.0"
  description = "Custom parameter group for MySQL 8.0"

  # Add parameter block here
  # Your code here
}

Need a hint?

Add a parameter block inside the parameter group resource with the exact name and value.

3

Create the DB option group

Create a DB option group named mydb-option-group for engine mysql version 8.0 and add the option MEMCACHED.

AWS

resource "aws_db_parameter_group" "mydb_parameter_group" {
  name        = "mydb-parameter-group"
  family      = "mysql8.0"
  description = "Custom parameter group for MySQL 8.0"

  parameter {
    name  = "max_connections"
    value = "150"
  }
}

# Create the DB option group with the MEMCACHED option
# Your code here

Need a hint?

Use the aws_db_option_group resource with the exact name, engine_name, major_engine_version, and add an option block with option_name = "MEMCACHED".

4

Create the RDS instance with parameter and option groups

Create an RDS DB instance named mydbinstance using engine mysql version 8.0, and associate it with the parameter group mydb-parameter-group and option group mydb-option-group.

AWS

resource "aws_db_parameter_group" "mydb_parameter_group" {
  name        = "mydb-parameter-group"
  family      = "mysql8.0"
  description = "Custom parameter group for MySQL 8.0"

  parameter {
    name  = "max_connections"
    value = "150"
  }
}

resource "aws_db_option_group" "mydb_option_group" {
  name                     = "mydb-option-group"
  engine_name              = "mysql"
  major_engine_version     = "8.0"
  option_group_description = "Option group with MEMCACHED"

  option {
    option_name = "MEMCACHED"
  }
}

# Create the RDS instance with the parameter and option groups
# Your code here

Need a hint?

Create an aws_db_instance resource with the exact identifier, engine, engine_version, and link the parameter and option groups by their names.