Black Lives Matter
Mission stands in protest, for equality and humanity, and against racism
Read our CEO's Statement

Why You Should Always Use a Custom DB Parameter Group When Creating an RDS Instance

Before spinning up a new Amazon RDS instance, it’s critical to first make sure you have a new custom DB parameter group ready to use with it. If you don’t, it might become necessary to perform an RDS instance restart to replace the default DB parameter group, even though the database parameter you’d like to change is modifiable and dynamic.

For AWS RDS instances, you manage your database engine configuration through the use of parameters in a DB parameter group. DB parameter groups act as a container for engine configuration values that are applied to one or more DB instances.

A default DB parameter group is created if you make a database instance without specifying a custom DB parameter group. This default group contains database engine defaults and Amazon RDS system defaults based on the engine, compute class, and allocated storage of the instance.

Now, let’s say you need to modify the AUTOCOMMIT DB parameter of your MySQL 5.6 RDS instance. Because it’s modifiable and dynamic, it seems like you can just go ahead and change it and it’ll just take effect, right?

Not so fast. You cannot just modify the parameter settings of a default DB parameter group — you must create your own DB parameter group to change parameter settings from their default value.

For example, this is what happens if you go to the default MySQL 5.6 parameter group and click the “Edit Parameters” button.

With the intention of replacing the default DB parameter group, you proceed to modify the RDS instance and select to apply the changes immediately.

However, this doesn’t mean you’re done. Your RDS instance will now wait for the next reboot before making the DB parameter group replacement effective, even though you just told it to “apply immediately.” The parameter group will show “applying” and then “pending-reboot,” which will clear after you bounce the instance.

The superior method here is to create a new DB Parameter Group before creating the RDS instance, in anticipation of your future needs. Even though you didn’t plan on changing any of the DB parameters at the time, preparing a custom DB parameter group for any new RDS instance provides the flexibility to rapidly realize necessary modifications down the road.

Join Our AWS Community

Bringing the AWS computing community together to connect and learn from AWS professionals.

See Upcoming Events
Written by

Related Stories

AWS Instance Scheduler: Tips and Tricks for Optimizing Costs

Learn some quick tips for how to lower your costs on AWS using the AWS Instance Scheduler.

How to Meet California Consumer Privacy Act (CCPA) Requirements with AWS

Businesses preparing to comply with CCPA can benefit by doing so via AWS tools with the assistance from an experienced managed service provider.

The Advantages of Running SQL Server on AWS

Running SQL Server on AWS has several advantages over running SQL Server in on-premises data centers. This blog lists the reasons to give businesses confidence in making the move and seeking the guidance of an AWS partner.