ByteHouse offers data backup capabilities, which address problems with data recovery after accidental deletion or modification and also provide disaster recovery functions in extreme circumstances. ByteHouse supports both complete and incremental backups. You can configure backup strategies as needed to ensure data security, enhancing data recovery efficiency.

• Version Requirements:
  • Before using complete and incremental backups, please ensure that your ByteHouse engine version is v2.7.1.61 or above.
  • You can access the ByteHouse Console>Manage clusters>Cluster List>Cluster details>basic information>Version Path, View the current cluster’s Version.
• Already requested the ByteHouse team to enable the white list function.

Create Backup Strategy #

1. After logging in to the ByteHouse Corporate Edition Console, go to Manage Clusters>Cluster List>Cluster Details, and click on the "Data Backup" page at the top. A welcome reminder will appear during the first visit, as shown below.
2. Click on the "Backup Strategy" tab and then the "Create Backup Strategy" button.
3. In the pop-up page, fill in the information to create a backup strategy.
   1. Fill in the basic information, including the name of the backup strategy, and select the compute group to use.
      The strategy name must meet the following conditions: supports numbers, letters, and underscores but cannot start with a number, have a maximum of 64 characters, and not be duplicated with the name of an existing task.
   2. Select the backup targets, supporting the entire cluster, whole database, or specific table dimensions for backup based on actual backup needs.
   3. Confirm the backup plan. Choose either a complete backup or a combination of complete and incremental backup.
   • Total backup: Complete data backup for the cluster.
   • Total and incremental backup: For the initial backup of the cluster, a complete backup is used, followed by subsequent incremental backups. Incremental backups are based on a previous complete backup or the last incremental backup under the same strategy.
4. Click "create."
5. Tasks saved successfully will appear in the "backup strategy" list.
6. Click the "backup set" tab. When the scheduled time arrives, the backup task will automatically execute.

View backup set status #

After the automatic execution of the backup task, you can view the status of the backups in the backup set. If a backup is unsuccessful, you can click on the corresponding backup set task to view task details, including the range of data that failed to back up and the reasons for the failure.

View Backup Set Storage Usage #

After the backup task starts, you can view the storage space occupied by all backup sets and estimate the storage costs at Data Backup Backup Set.

After performing the backup task, we can restore the data in the backup set.

1. Access the "Data Backup Backup Set" page, and click the "Restore" button next to the data you need to restore.
2. Select the databases and tables you need to restore.
3. Click "Confirm" to start data restoration.
4. After a successful restoration, you can view the history of restored data on the "Restoration Record" tab.

You can view all executed backup sets in the backup set tab, and for redundant backup sets that are no longer useful, click the delete button behind the corresponding backup set to reduce storage costs.