Amazon RDS - Creating/Modifying Parameter Groups

The steps below will guide you through creating a new parameter group and applying it to your instance.

(This requires that you already have the RDS tools installed on your system and all environmental variables and authentication setup as well.)

1. Create new parameter group. (Replace MySQL5.5 with the appropriate value)

rds-create-db-parameter-group MyParamGroupName -f MySQL5.5 -d "Parameter group for testing"

     2. Set values for new parameter group.

rds-modify-db-parameter-group MyParamGroupName --parameters "name=max_allowed_packet, value=33554432, method=immediate"

      3. Change parameter group for existing DB instance.

rds-modify-db-instance MyDBInstance --db-parameter-group-name=MyParamGroupName

      4. Reboot DB instance to apply changes.

rds-reboot-db-instance MyDBInstance

      5. Check status of db instance.

rds-describe-db-instances