Help Center> MapReduce Service> User Guide> FusionInsight Manager Operation Guide (Applicable to 3.x)> Backup and Recovery Management> Backing Up Data> Backing Up ClickHouse Service Data
Updated on 2024-04-11 GMT+08:00
View PDF

Backing Up ClickHouse Service Data

Scenario

To ensure ClickHouse service data security routinely or before a major operation on ClickHouse (such as upgrade or migration), you need to back up ClickHouse service data. The backup data can be used to recover the system if an exception occurs or the operation has not achieved the expected result, minimizing the adverse impacts on services.

You can create a backup task on FusionInsight Manager to back up ClickHouse service data. Both automatic and manual backup tasks are supported.

This function is supported only by MRS 3.1.0 or later.

Prerequisites

  • If data needs to be backed up to the remote HDFS, you have prepared a standby cluster for data backup. The authentication mode of the standby cluster is the same as that of the active cluster. For other backup modes, you do not need to prepare the standby cluster.
  • If the active and standby clusters are deployed in security mode and they are not managed by the same FusionInsight Manager, mutual trust must be configured. For details, see Configuring Cross-Manager Mutual Trust Between Clusters. If the active and standby clusters are deployed in normal mode, no mutual trust is required.
  • Time is consistent between the active and standby clusters and the NTP services on the active and standby clusters use the same time source.
  • You have planned the backup type, period, object, and directory based on service requirements.
  • The HDFS in the standby cluster has sufficient space. You are advised to save backup files in a custom directory.
  • In the active/standby cluster, if data is remotely backed up to HDFS, ensure that the value of HADOOP_RPC_PROTECTION of ClickHouse is the same as that of hadoop.rpc.protection of HDFS.

Procedure

  1. On FusionInsight Manager, choose O&M > Backup and Restoration > Backup Management.
  2. Click Create.
  3. Set Name to the name of the backup task.
  4. Select the cluster to be operated from Backup Object.
  5. Set Mode to the type of the backup task.

    Periodic indicates that the backup task is executed by the system periodically. Manual indicates that the backup task is executed manually.

    Table 1 Periodic backup parameters

    Parameter

    Description

    Started

    Indicates the time when the task is started for the first time.

    Period

    Indicates the task execution interval. The options include Hours and Days.

    Backup Policy
    • Full backup at the first time and incremental backup subsequently
    • Full backup every time
    • Full backup once every n times
    NOTE:
    • Incremental backup is not supported when Manager data and component metadata are backed up. Only Full backup every time is supported.

  6. In Configuration, select ClickHouse under Service Data.
  7. Set Path Type of ClickHouse to a backup directory type.

    Currently, only the RemoteHDFS type is available.

    RemoteHDFS: indicates that backup files are stored in HDFS of the standby cluster.

    This value option is available for MRS 3.1.0 or 3.1.2 clusters only after you configure the environment by referring to How Do I Configure the Environment When I Create a ClickHouse Backup Task on FusionInsight Manager and Set the Path Type to RemoteHDFS?.

    You also need to configure the following parameters for MRS 3.1.3 or later clusters:
    • Destination NameService Name: indicates the NameService name of the standby cluster, for example, hacluster. You can obtain it from the NameService Management page of HDFS of the standby cluster.
    • IP Mode: indicates the mode of the target IP address. The system automatically selects the IP address mode based on the cluster network type, for example, IPv4 or IPv6.
    • Destination Active NameNode IP Address: indicates the service plane IP address of the active NameNode in the standby cluster.
    • Destination Standby NameNode IP Address: indicates the service plane IP address of the standby NameNode in the standby cluster.
    • Destination NameNode RPC Port: indicates the value of dfs.namenode.rpc.port in the HDFS basic configuration of the destination cluster.
    • Target Path: indicates the HDFS directory for storing standby cluster backup data. The storage path cannot be an HDFS hidden directory, such as a snapshot or recycle bin directory, or a default system directory, such as /hbase or /user/hbase/backup.
    You also need to configure the following parameters for MRS 3.1.0 or 3.1.2 clusters:
    • Destination NameService Name: indicates the NameService name of the standby cluster, for example, hacluster. You can obtain it from the NameService Management page of HDFS of the standby cluster.
    • IP Mode: indicates the mode of the target IP address. The system automatically selects the IP address mode based on the cluster network type, for example, IPv4 or IPv6.
    • Target NameNode IP Address: indicates the IP address of the NameNode service plane in the standby cluster. It can be of an active or standby node.
    • Target Path: indicates the HDFS directory for storing standby cluster backup data. The storage path cannot be an HDFS hidden directory, such as a snapshot or recycle bin directory, or a default system directory, such as /hbase or /user/hbase/backup.
    • Maximum Number of Backup Copies: indicates the number of backup file sets that can be retained in the backup directory.
    • Maximum Number of Maps: indicates the maximum number of maps in a MapReduce task. The default value is 20.
    • Maximum Bandwidth of a Map (MB/s): indicates the maximum bandwidth of a map. The default value is 100.

  8. Set Maximum Number of Recovery Points to the number of snapshots that can be retained in the cluster.
  9. Set Backup Content to one or multiple ClickHouse tables to be backed up.

    You can select backup data using either of the following methods:

    • Adding a backup data file

      Click the name of a database in the navigation tree to show all the tables in the database, and select specified tables.

      MRS 3.2.0 or later:

      1. Click Add.
      2. Select the table to be backed up under File Directory, and click Add to add the table to Backup Content.
      3. Click OK.
    • MRS 3.2.0 or later: Regular expression filtering
      1. Click Query Regular Expression.
      2. Enter the logical cluster and database to which the ClickHouse table belongs in the first text box as prompted. The logical cluster and database must match the existing logical cluster and database, for example, /default_cluster/database.
      3. Enter a regular expression in the second box. Standard regular expressions are supported. For example, to filter all tables that contain the keyword test in the database, enter test.*.
      4. Click Refresh to view the displayed tables in Directory Name.
      5. Click Synchronize to save the result.
      • When entering regular expressions, click or to add or delete an expression.
      • If the selected table or directory is incorrect, click Clear Selected Node to deselect it.
    • Versions earlier than MRS 3.2.0: Regular expression filtering
      1. Click Query Regular Expression.
      2. Enter the database where the ClickHouse tables are located in the first text box as prompted. The database must be the same as the existing database, for example, default.
      3. Enter a regular expression in the second text box. Standard regular expressions are supported. For example, to get all tables in the database, enter ([\s\S]*?). To get tables named in the format of letters and digits, for example, tb1, enter tb\d*.
      4. Click Refresh to view the displayed tables in Directory Name.
      5. Click Synchronize to save the result.
      • When entering regular expressions, click or to add or delete an expression.
      • If the selected table or directory is incorrect, click Clear Selected Node to deselect it.

  10. Click Verify to check whether the backup task is configured correctly.

    The possible causes of the verification failure are as follows:

    • The target NameNode IP address is incorrect.
    • The directory or table to be backed up does not exist.
    • The name of the NameService is incorrect.

  11. Click OK.
  12. In the Operation column of the created task in the backup task list, click More and select Back Up Now to execute the backup task.

    After the backup task is executed, the system automatically creates a subdirectory for each backup task in the backup directory. The format of the subdirectory name is Data source_Task creation time, and the subdirectory is used to save latest data source backup files.

Parent topic: Backing Up Data