All Products
Search
Document Center

Lindorm:Automatic backup of data in Lindorm wide tables

Last Updated:Mar 05, 2024

You can enable the backup and restoration feature for a Lindorm instance to back up incremental or full data in Lindorm wide tables to Object Storage Service (OSS). This way, the backup data does not occupy the storage capacity of the Lindorm instance. After you enable the backup and restoration feature, full data in wide tables of the instance is automatically backed up at the default interval. You can modify the interval and data range of full data backup in the Lindorm console. You do not need to make additional settings for the backup and restoration feature. Incremental data is automatically backed up at the specified interval.

Prerequisites

The backup and restoration feature is enabled for the Lindorm instance. For more information, see Enable backup and restoration.

Billing

You are charged for the storage capacity used to store backups on a pay-as-you-go basis.

Perform automatic full backup

  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 Create Backup Settings.

  7. In the Create Backup Settings dialog box, configure backup parameters described in the following table based on your business requirements.

    Parameter

    Description

    Tables for Backup

    Tables in which data you want to back up is stored.

    • If you want to back up all data in a database, enter an asterisk (*).

    • If you want to back up data in specific tables, specify the table in the default:test format. The value "default" indicates the namespace and the value "test" indicates the prefix of the tables.

    Full Backup Cycle (Days)

    By default, full backups are performed at an interval of seven days. You can set this parameter to a value that ranges from 3 to 10 days. If you specify a short period, the backup task may fail to be complete in the specified time period. If you specify a long period, the time that is required to restore the data may increase.

    Perform Next Full Backup At

    The point in time when you want the next full backup to start. We recommend that you set the full backup time to a point in time during off-peak hours.

    Full Backup Reserved

    The number of full backup files that you want to retain. Valid values: 3 to 12.

  8. Click OK.

Perform automatic incremental backup

After you enable the backup and restoration feature, incremental data is automatically backed up to OSS at the specified interval. You do not need to make additional settings.

You can view the information about incremental backup in the Incremental Backup section of the Backup & Recovery tab.image

Related operations

You can restore backup data to the current instance. For more information, see Restore backup data to the instance that corresponds to the original data.