Parameter groups

A parameter group is a named set of engine settings. Attach one parameter group to a database cluster at a time.

Concepts

• Parameter schema group — allowed parameters for an engine and version
• Parameter group — your values for that schema
• Database parameter group — the assignment of a group to a cluster

Default assignment

When you create a cluster, myStack attaches a default parameter group for the engine if one is configured.

To create a parameter group

1. Choose Databases, Parameter Groups, then create a group.
2. Enter a name.
3. Choose a parameter schema group (for example, MySQL 5.7).
4. Set parameter values.
5. Choose Save.

To attach a parameter group to a cluster

1. Open the cluster detail page.
2. In Parameter Group, choose a group (or No parameter group to detach).
3. Choose Save.
4. If attaching a group, choose whether to restart the engine when static parameters change.

Changing parameter values

Editing a parameter value in a parameter group that is already attached to one or more clusters does not automatically apply those changes to the existing clusters. This is intentional: it prevents accidental configuration changes from impacting production systems.

To apply updated parameters to a cluster

1. Open the parameter group and choose Copy.
2. Enter a name for the copy, then save.
3. In the copied group, change the parameter values you need.
4. Open the target cluster and assign the copied parameter group.
5. If static parameters changed, choose whether to restart the engine.