Lindorm:Restore an instance by using its backup data

Usage notes

• Lindorm New Edition and single-node Lindorm instances do not support the backup and restoration feature.

• Lindorm restores data to an instance by writing its backup data to the tables of the instance. Therefore, we recommend that you delete the data in a Lindorm table before you restore backup data to the table,

Procedure

1. Log on to the Lindorm console.

2. In the upper-left corner of the page, select the region where the instance is deployed.

3. On the Instances page, click the ID of the instance that you want to manage or click Manage in the Actions column corresponding to the instance.

4. In the left-side navigation pane, click Wide Table Engine.

5. Click the Backup & Recovery tab.

6. In the Full Backup section, click Initiate Data Recovery.

7. In the Recovery dialog box, configure related parameters based on your requirements. The following table describes the parameters that you can configure.

   Parameter	Description
   Cluster for Recovery	The name of the Lindorm instance to which you want to restore your backup data. Important The backup data generated for a Lindorm instance cannot be restored to the instance after the instance is upgraded to a later version.
   Point in Time	Specify a point in time to which you want to restore backup data.
   Full Database Recovery	Select Yes.
   Tables for Recovery	If you select No for Full Database Recovery, specify the tables to which you want to restore backup data. Enter one table with its namespace in each line. Asterisks (*) are not supported. To restore backup data to a single table, you can specify the value in the namespace:table format. For example, you can specify default:testTable as the value of this parameter. To restore data in a table to another table, you can specify the value in the namespace:table/namespace:table2 format. For example, you can specify default:testTable/default:testTable2 as the value of this parameter.

8. Click OK. On the Recovery List tab, you can click Details in the Actions column corresponding to the restoration task to view its progress.

FAQ

• What is the most recent point in time to which I can restore data?

  If no pending tasks exist, the most recent point in time varies based on the cycle in which the system backs up write-ahead logs (WAL) to Object Storage Service (OSS). By default, the system backs up WAL data at an interval of 30 seconds or performs a backup operation for each 30 MB of WAL data. If a failure occurs, you may fail to restore the data that is written to a Lindorm instance within the 30-second period before the present time.

• How much time does the system require to restore data?

  The period of time that the system requires to restore data varies based on the data size and bandwidth.

  • Full data restoration: Backup data can be read from OSS at a speed up to 1 GB/s. Each Lindorm Tunnel Service (LTS) node can write backup data to a Lindorm instance at a speed of 100 MB/s.

  • Incremental data restoration: Backup data can be written to each node in a Lindorm instance at a speed of 30 MB/s to 40 MB/s. Each LTS node can write backup data to a Lindorm instance at a speed of 100 MB/s.

• Can I restore backup data to a single table?

  Yes, you can restore backup data to a single table. If a table with the same name already exists, you can restore the backup data to another table.