Configuring a Cold Table

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 > TaurusDB.
4. On the Instances page, click the instance name.
5. In the navigation pane, click Cold and Hot Data Separation.
6. Click on the right of Cold and Hot Data Separation. In the displayed dialog box, click OK.
   Figure 1 Enabling cold and hot data separation
   

7. On the Cold Tables tab, click Create Cold Table.
   Figure 2 Creating a cold table
   

8. In the displayed dialog box, search for the name of the database, table, or partition to be archived as cold data.
9. Select the tables or partitions to be archived as cold data.
   Figure 3 Selecting the tables to be archived
   

10. Click OK.
11. After the cold table is created, view its details.
    Figure 4 Viewing details about a cold table
    

12. If you need to modify a cold table or frequently query the table, click Migrate Back in the Operation column to migrate the table back to the DB instance.
    

    You are advised to migrate back cold tables during off-peak hours because this operation can take a long time.

    Figure 5 Migrating back a cold table
    

13. Confirm the task and click OK.

When configuring a cold table using SQL statements, you need to use DAS or a client (such as the mysql client) to connect to your TaurusDB instance and then run the corresponding SQL statements. The following procedure uses DAS as an example.

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 > TaurusDB.
4. On the Instances page, click the instance name.
5. In the navigation pane, click Cold and Hot Data Separation.
6. Click on the right of Cold and Hot Data Separation. In the displayed dialog box, click OK.
   Figure 6 Enabling cold and hot data separation
   

7. On the Basic Information page, click Log In in the upper right corner.

   Alternatively, return to the Instances page, locate the instance, and click Log In in the Operation column.

   Figure 7 Logging in to an instance
   

8. On the displayed page, enter the username and password and click Test Connection. After the connection is successful, click Log In.
   Figure 8 Login page
   

9. Choose SQL Operations > SQL Query.
   Figure 9 SQL Operations
   

10. Configure a cold table using SQL statements.
    • Creating a cold table

      CALL dbms_schs.make_io_transfer("start", "database_name", "table_name", "partition_name", "", "obs");

      Example:

      CALL dbms_schs.make_io_transfer("start", "test", "table1", "", "", "obs");

      Figure 10 Creating a cold table
      

11. Query the archiving or migration status.

    CALL dbms_schs.show_io_transfer("database_name", "table_name", "partition_name");

    Example:

    CALL dbms_schs.show_io_transfer("test", "table1", "");

    Figure 11 Querying the archiving or migration status
    

12. (Optional) Query all cold tables on an instance as user root.

    CALL sys.schs_show_all( "database_name", "table_name", "partition_name");

    Examples:

    • Querying all cold tables on an instance

      CALL sys.schs_show_all( "", "", "");

    • Querying all cold partitions or cold tables whose database name is test

      CALL sys.schs_show_all( "test", "", "");

    • Querying cold partitions or cold tables whose database name is test and table name is table1

      CALL sys.schs_show_all( "test", "table1", "");

13. Migrate back a cold table.

    CALL dbms_schs.make_io_transfer("start", "database_name", "table_name", "partition_name", "obs", "");

    Example:

    CALL dbms_schs.make_io_transfer("start", "test", "table1", "", "obs", "");

    Figure 12 Migrating back a cold table