Modifying GaussDB Instance Parameters

Precautions

• Parameters for data redistribution can be modified only for distributed instances of version V2.0-2.6 or later.
• Parameters of read replicas can be modified only for centralized (1 primary + 2 standby) instances of version V2.0-2.7.1 or later.

Modifying Common Parameters of the Current Instance

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, click the name of the target instance to go to the Basic Information page.
5. In the navigation pane on the left, choose Parameters.
   Figure 1 Parameters
   
   • You can modify and query the parameters applied to the instance on this page. After modifying parameters, you can preview the changes or cancel the modification.

     After confirming that all changes are correct, click Save.

     

     The modification of some parameters takes effect only after the instance is rebooted. After you modify a parameter value, view the value in the Effective upon Reboot column.

     • If the value is Yes and the instance status on the Instances page is Parameter change. Pending reboot, you must reboot the instance for the modifications to take effect.
     • If the value is No, the modifications take effect immediately for the instance.
   • You can click Replicate to save the parameters of the instance as a parameter template. You can view the parameter template under the Custom Templates tab of the Parameter Templates page. For details, see Managing Parameter Templates for GaussDB Instances.
   • You can click Export to download the parameters of the instance to your local PC.
   • You can click Compare to compare the parameter template applied to the current instance with an existing parameter template.

Modifying Common Parameters of Multiple Instances at a Time

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. In the navigation pane on the left, choose Parameter Templates. Click the Custom Templates tab, and click the name of the target parameter template.
5. Modify parameters as needed.
   Figure 2 Modifying parameters
   
   • Click Save. In the displayed dialog box, click Yes to save the modification.
   • To cancel your changes, click Cancel.
   • To preview your changes, click Preview.

6. After the parameters are modified, click Change History to view what changes have been made.
   

   The changes take effect only after you apply the parameter template to instances. For details, see Applying a Parameter Template.

Modifying Data Redistribution Parameters of the Current Instance

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, click the name of the target instance to go to the Basic Information page.
5. In the navigation pane on the left, choose Parameters. On the displayed page, click Change Parameters for Scale-out or Change Parameters for Redistribution.
   Figure 3 Parameters
   
   Figure 4 Changing parameters for scale-out
   
   Figure 5 Changing parameters for redistribution
   

6. Enter required parameter values, enter confirm in the text box, select the confirmation check box, and click OK.