In-place Upgrade

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.
   Figure 2 Instances
   
   Alternatively, click the target instance name to go to the Basic Information page. In the Configuration area, click Upgrade Instance in the DB Engine Version field.

   Figure 3 Basic information
   
3. In the Upgrade Instance dialog box, select In-place for Upgrade Method, select the target version, enter confirm, and click OK.
   Figure 4 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 whether the value of DB Engine Version in the Configuration area is the target version.
3. Check that the automated backup triggered after the upgrade is successfully created.
   1. On the Instances page, click the name of the target instance to go to the Basic Information page.
   2. In the navigation pane, choose Backups. Check that a backup has been created and the backup status is Completed.
4. 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 7 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 8 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;