Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

What is option group and parameter group in RDS ?

01 March,2023 by Rambler

Question: What is the difference in an AWS option group and AWS parameter group?

Answer: The definitions of Parameter Groups and Option Groups are as follows

                              Parameter group stores engine configuration values and can be used as a container mapped to one or more instances. If you do not specify a customer-created parameter group than a default parameter group is created containing typical defaults for RDS including engine, storage allocation , compute class. 

You can create a customer parameter group using either the AWS interface or AWS CLI . For AWS CLI use the  create-db-parameter-group   

                               Option Groups  enables and configure additional features. An option group can specify features, called options, that are available for a particular Amazon RDS DB instance.When you map a DB with an option group , the DB instance will inherit the features . For example - if you want to enable TDE for RDS SQL Server - add TDE as an option in the Option group.

You can create a customer parameter group using either the AWS interface or AWS CLI . For AWS CLI use the  create-option-group  

If you want to check the details of the option group 

aws rds describe-option-groups --option-group-name sqlserver-tde
{
    "OptionGroupsList": [
        {
            "OptionGroupName": "sqlserver-tde",
            "OptionGroupDescription": "TDE test ",
            "EngineName": "sqlserver-ee",
            "MajorEngineVersion": "15.00",
            "Options": [
                {
                    "OptionName": "TDE",
                    "OptionDescription": "SQL Server - Transparent Data Encryption",
                    "Persistent": true,
                    "Permanent": false,
                    "OptionSettings": [],
                    "DBSecurityGroupMemberships": [],
                    "VpcSecurityGroupMemberships": []
                }
            ],
            "AllowsVpcAndNonVpcInstanceMemberships": false,
            "OptionGroupArn": "arn:aws:rds:xxxxxxxxxxxxxxxxxxxxxx"
        }
    ]
}




Read more on AWS 

AWS CLI Cheatsheet 

 


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on What is option group and parameter group in RDS ?


dba-ninja.com