Parameter Group
A parameter group is a collection of engine configuration values that you set for your database instance. It contains the mapping of what you want each of these parameters to be set.
How to create Parameter Group
For creating a Parameter group, you need to click on Database from the side navigation bar.
After clicking on Database, click on Parameter Group from the sidebar and then click on the Add Parameter Group button.
After clicking on the Add Parameter Group, select a relevant plan for your database and give a name and description.
Different database engines have different Parameter groups available. You need to select the required database engine for which you want to create a Parameter group. Below is the list of database engines that we currently support:
- MariaDB - 10.4
- MySQL 5.6
- MySQL 5.7
- MySQL 8.0
- PostgreSQL 10.0
- PostgreSQL 11.0
- PostgreSQL 12.0
- PostgreSQL 13.0
- PostgreSQL 14.0
Fill in the details like this:
Click on the Create button.
After the parameter group is created, it will be shown like this:
Now, clicking on the Action button will give options like this:
Click on Edit Parameter Group to edit the DBaaS configuration.
After clicking on Edit Parameter Group, the user will see parameters like this:
Click on Edit Parameters on the top right corner of the page to edit the parameters options.
After clicking on Edit Parameters, change the parameter according to your requirements.
After changing the parameters, click on Save Changes to save the changes you have applied on the parameters.
After changing the parameters and saving those changes, click on the Back button.
After changing the parameters, click on Sync All to apply the changes the user has made to its parameter group so that it can be synced with the relevant database service.
Click on Delete Parameter Group to delete the Parameter Group.
How to attach Parameter group to your Database
After creating a DBaaS, the user will be able to see the Parameter Groups option in the bottom left corner of the page.
After clicking on the checkbox, the user will be able to see a box.
After clicking on the Select Group expansion panel, the user will be able to select the parameter group he/she wants to attach to its Database.
After selecting the desired parameter group, click on the Attach Group button to attach the group to the database.
After attaching the parameter group, the user will be able to see the attached group in the bottom of the Connection Details tab.
To detach the parameter group, click on the Detach Group button.