AWS RDS instance option groups

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In the last blog post, we have discussed AWS RDS instance parameter groups.

https://cloudaffaire.com/aws-rds-instance-parameter-groups

In this blog post, we will discuss AWS RDS option groups.

Option Groups:

Apart from parameter groups to define RDS instance type specific parameters, AWS RDS also support option groups. Options groups consist of optional features that can be added to your AWS RDS instance that are not already covered in parameter groups. Each AWS RDS instance type has its own set of options (parameter) that you can define using an option group.

By default, AWS RDS creates a default option group when you created your RDS instance. Like default parameter group, you cannot modify a default option group. To configure an option group, you need to create your own option group. Not all RDS instance type supports option group, for instance PostgreSQL does not support an option group.

Option groups options are of two types, persistent and permanent. Persistent options can’t be removed from an option group while DB instances are associated with the option group. On the other hand, permanent options cannot be removed event if no instance is associated.

Next, we are going to create an option group for MySQL RDS instance.

AWS RDS option groups:

Step 1: Login to AWS console and navigate to ‘RDS’.

Step 2: In the navigation pane, click ‘Option groups’ and click ‘Create group’.

Step 3: Provide a name, description and database engine type. Click ‘Create’.

Our option group for MySQL RDS successfully created.

Note: AWS RDS also created the default option group for MySQL automatically.

Next, we are going to add an option to this new option group.

Step 4: Select the option group and click ‘Add option’.

Step 5: Select the option and click ‘Add Option’.

To apply the option group, modify your AWS RDS instance and in ‘Database options’ section, select the new option group.

Hope you have enjoyed this article, In the next blog post, we will discuss AWS RDS subnet groups.

To get more details on AWS RDS, please refer below AWS documentation

https://docs.aws.amazon.com/rds/index.html