The data backup and restoration feature can minimize the loss that is caused by accidental operations performed on databases. This topic describes how to restore backup data to the instance that corresponds to the original data.

Prerequisites

Procedure

  1. Log on to the Lindorm console.
  2. In the upper-left corner of the page, select the region in which the instance is located.
  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 the parameters that are used to restore data based on your business requirements. The following table describes the parameters.
    ParameterDescription
    Cluster for RecoverySpecify the name of the Lindorm instance to which you want to restore your backup data.
    Important If the version of LindormTable is updated, you cannot use the backup data that is generated before the update is performed to restore data for your Lindorm instance.
    Point in TimeSpecify a point in time to which you want to restore your data.
    Full Database RecoverySelect Yes.
    Tables for RecoveryIf you select No for Full Database Recovery, configure the Tables for Recovery parameter. Enter one namespace on each line. Asterisks (*) are not supported.
    • You can specify a value in the namespace:table format to restore a table. For example, you can specify default:testTable as the value of this parameter.
    • You can specify a value in the namespace:table/namespace:table2 format to restore data in a table to another table. 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 to view the progress of data restoration.

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: The maximum speed of OSS is 1 GB/s and each Lindorm Tunnel Service (LTS) node can write data at a speed of 100 MB/s.
    • Incremental data restoration: Each node in a Lindorm cluster can receive 30 MB to 40 MB data per second and each LTS node can write data at a speed of 100 MB/s.
  • Can I restore a single table?

    Yes, you can restore a single table. If a database contains tables whose names are the same, you can restore the data in one of these tables to another table.