The answer is very simple, we can change it from AWS console itself.
There are certain steps that we must follow to change the value of a global variable using a console.
Prerequisites:
If you are using a multi-AZ database then select Writer Instance.
Modification will be done in the running instances only.
Step 1: First, let’s look at the RDS dashboard.
In this, we can see RDS is offering lot of features and options related to Databases.
Step 2: There is one option on the left side called “Parameter Group” as mentioned below the image. You need to click on that.
After that, it will take you to the parameter group where you can find the default parameter for DB and DB clusters.
Step 3: As you can see in the below image RDS will create default parameter groups according to Database Family.
Now, you will think you can directly change the global variable value from this parameter’s group, but you cannot change default parameter’s global variable value.
Step 4: You need to create a custom parameter group. Click on Create parameter group.
Step 5: In this, you need to select Parameter group family, Type, Group name and Description according to your requirements.
Step 6: After that Click on Create.
As you can see our custom parameter group has been created successfully. You can follow the same process for the custom DB Cluster parameter group.
Step 7: Now, we need to select a custom parameter group by clicking on the parameter group name, or you can select Name for the Parameter search box.
Step 8: Now you can search for the required global variable name for which you want to change the value. And then you can select that parameter and click on the Edit parameter.
You can select a value range from the given value range in Allowed values.
Step 9: After editing the Values, click on Save changes and then Cancel Editing.
Step 10: Now you need to modify the settings of the RDS database. For that, you need to visit Database’s page. Select the database in which you want to do changes, and then click on modify.
Step 11: Then scroll down to Additional configuration, and you can see two options 1. DB cluster parameter group and 2. DB parameter group.
Step 12: We need to change the DB parameter group from Default to which we have created.
NOTE: For now, we have created only a Custom parameter group, not a Custom DB cluster parameter group.
Now scroll down to the end and select Continue.
Step 13: You can review your changes and select when to apply changes from the given options. Then you can click on Modify DB instance.
Step 14: It will redirect you to the database page with a successful modified message.
Step15: At last, you need to reboot your DB instance to apply changes in the database.
After successfully rebooted instance, when your DB instance come back to available state again you can verify changes by accessing your DB using third party applications.
