Hot Patch Update

Before an upgrade, check the instance status and whether monitoring metrics such as the CPU usage, memory usage, and disk usage of the instance are normal.

1. Check instance status.
   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, check whether the target instance is available.
      Figure 1 Instance status
      

      If the instance is in an abnormal state, contact Huawei Cloud technical support.

2. Check monitoring metrics.
   1. Click in the upper left corner of the page, and choose Management & Governance > Cloud Eye.
   2. In the navigation pane, choose Cloud Service Monitoring > GaussDB.
   3. On the Cloud Service Monitoring page, click the target instance to go to the metric monitoring page.
      • On the DB Instance tab, view the value of Instance Disk Usage to check whether the disk usage is insufficient.
      • On the Node tab, view the value of CPU Usage to check whether the CPU usage remains high for a long time.
      • On the Node tab, view the value of Memory Usage to check whether the memory usage increases sharply.

      If any of the metrics are abnormal, contact Huawei Cloud technical support.

[Method 1: upgrading a single instance]

1. Click in the upper left corner of the page and choose Databases > GaussDB.
2. On the Instances page, click More in the Operation column of the target instance and choose Upgrade.
3. In the Upgrade Instance dialog box, select Hot patch for Upgrade Method, enter YES, and click OK.
   

   All available patch versions are displayed in the Target Version area. If multiple patches are to be installed, they will be installed in ascending order of version numbers after the upgrade task is submitted.

   Figure 2 Upgrading an instance
   

4. Check the upgrade result on the Instances page.
   • During the upgrade, the instance status is Upgrading version.
   • After the upgrade is complete, the instance status changes to Available.

After the upgrade is complete, check the instance status, backup creation status, and instance connectivity, and whether you can add, delete, update, and query data in the instance.

1. On the Instances page, check whether Status of the target instance is Available.
2. On the Instances page, click the name of the target instance. On the Basic Information page that is displayed, check that the target versions are displayed in the Upgraded Hot Patch Version and Upgraded Kernel Hot Patch Version fields in the Configuration area.
3. Check that the instance is properly connected and you can add, delete, update, and query data in the instance.
   1. Log in to the database. For details, see Connecting to an Instance Through DAS.
   2. Go to the SQL Query page.
      Figure 5 SQL query
      
   3. Create a database.

      CREATE DATABASE database_name;

      In this example, run the following command to create a database named db_tpcds:

      CREATE DATABASE db_tpcds;

      Switch to the newly created database in the upper left corner.

      Figure 6 Switching to the new database
      
   4. Create a table and add, delete, update, and query data in the table.
      1. Create a schema.

         CREATE SCHEMA myschema;

      2. Create a table named mytable that has only one column. The column name is firstcol and the column type is integer.

         CREATE TABLE myschema.mytable (firstcol int);

      3. Insert data into the table.

         INSERT INTO myschema.mytable VALUES (100);

      4. View the data in the table.

         SELECT * FROM myschema.mytable;

            | firstcol | 
         ---+----------+
         1  |   100    |

      5. Update data in the table.

         UPDATE myschema.mytable SET firstcol = 200;

      6. View the data in the table again.

         SELECT * FROM myschema.mytable;

            | firstcol | 
         ---+----------+
         1  |   200    |

      7. Delete the table.

         DROP TABLE myschema.mytable;