Backing Up DBService Data

Updated on 2022-08-12 GMT+08:00

View PDF

Scenario

To ensure system data security routinely or before and after a critical operation (such as upgrade and migration) on DBService, DBService data needs to be backed up. 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 impact on services.

System administrators can create a backup task in FusionInsight Manager to back up DBService data. Both automatic backup tasks and manual backup tasks are supported.

Prerequisites

If you want to back up data to the remote HDFS. A standby cluster for backing up data has been created. The mode of the standby cluster is the same as that of the active cluster. In other backup modes, you do not need to prepare the standby cluster.

If the active cluster is deployed in security mode and the active and standby clusters are not managed by the same FusionInsight Manager, configure system mutual trust. For details, see Configuring Cross-Manager Cluster Mutual Trust Relationships. If the active cluster is deployed in normal mode, do not configure mutual trust.
Cross-cluster replication has been configured for the active and standby clusters. For details, see Enabling Cross-Cluster Replication.
The time of the active cluster and standby cluster must be the same, and the NTP service in the active and standby clusters must use the same time source.
Based on the service requirements, plan the backup type, period, policy, and other specifications, and check whether Data path/LocalBackup/ has sufficient space on active and standby management nodes.
If you want to back up data to the NAS, you need to deploy the NAS server in advance.
If you want to back up data to the OBS, ensure that the current cluster is connected to OBS and you have the permission to access OBS.

Procedure

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

Set Mode to the type of the backup task.

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

**Table 1** Periodic backup parameters
Parameter Name	Description
Started	Indicates the time when the task is started for the first time.
Period	Indicates 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 time NOTE: Incremental backup is not supported when Manager data and component metadata are backed up. Only Full backup every time is supported. If Mode is set to Periodic and the Path Type is set to NFS or CIFS, the incremental backup function cannot be used. If incremental backup is used in this scenario, data in full backup will be updated in each incremental backup, and no recovery point will be generated.

Set Configuration to DBService.

NOTE:

If there are multiple DBServices, all DBServices are backed up by default. You can click Assign Service to specify the DBService to be backed up.
Set Path Type of DBService to a backup directory type.

The following backup directory types are supported:
- LocalDir: indicates that the backup files are stored on the local disk of the active management node and the standby management node automatically synchronizes the backup file.
  The default save path is Cluster data path/LocalBackup/, for example, /srv/BigData/LocalBackup.
  
  If you select this value, you need to set Maximum Number of Backup Copies to specify the number of backup files that can be retained in the backup directory.
- LocalHDFS: indicates that the backup files are stored in the HDFS directory of the current cluster.
  If you select this value, you need to set the following parameters:
  - Target Path: indicates the backup file save path in the HDFS. The save path cannot be an HDFS hidden directory, such as 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 files that can be retained in the backup directory.
  - Target NameService name: indicates the NameService name that corresponds to the backup directory. The default value is hacluster.
- RemoteHDFS: indicates that the backup files are stored in the HDFS directory of the standby cluster.
  If you select this value, you need to set the following parameters:
  - Destination NameService Name: indicates the NameService name of the standby cluster. You can set it to the NameService name (haclusterX, haclusterX1, haclusterX2, haclusterX3, or haclusterX4) of the built-in remote cluster of the cluster, or the NameService name of a configured remote cluster.
  - IP Mode: 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 NameNode service plane IP address of the standby cluster, supporting the active node or standby node.
  - Target Path: indicates the HDFS directory for storing standby cluster backup data. The save path cannot be an HDFS hidden directory, such as 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 files that can be retained in the backup directory.
  - Queue Name: indicates the name of the YARN queue used for backup task execution. The name must be the same as the name of the queue that is running properly in the source cluster.
- NFS: indicates that backup files are stored in the NAS over the NFS protocol.
  If you select NFS, set the following parameters:
  - IP Mode: 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.
  - Server IP Address: indicates the NAS server IP address.
  - Server Shared Path: indicates the configured shared directory on the NAS server.
  - Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
- CIFS: indicates that backup files are stored in the NAS over the CIFS protocol.
  If you select CIFS, set the following parameters:
  - IP Mode: 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.
  - Server IP Address: indicates the NAS server IP address.
  - Port: indicates the port ID used by the CIFS protocol to connect to the NAS server. The default value is 445.
  - Username: indicates the user name that is configured when setting the CIFS protocol.
  - Password: indicates the password that is configured when setting the CIFS protocol.
  - Server Shared Path: indicates the configured shared directory on the NAS server.
  - Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
- SFTP: Indicates that backup files are stored in the server using SFTP.
  If you select SFTP, set the following parameters:
  - IP Mode: 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.
  - Server IP Address: Enter the IP address of the server where the backup data is stored.
  - Port: Enter the port number used by the SFTP protocol to connect to the backup server. The default value is 22.
  - Username: Enter the username for connecting to the server using SFTP.
  - Password:Enter the password for connecting to the server using SFTP.
  - Server Shared Path: Enter the backup path on the SFTP server.
  - Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
- OBS: indicates that the backup files are stored in the OBS.
  If you select this value, you need to set the following parameters:
  - Target Path: indicates the OBS directory for storing backup data.
  - Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
    NOTE:
    
    MRS 3.1.0 and later versions support backing up data to OBS.
Click OK to save the settings.
In the Operation column of the created task in the backup task list, choose More > 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 backup task name_task creation time, and the subdirectory is used to save data source backup files. The format of the backup file name is version_data source_task execution time.tar.gz.

Parent topic: Backing Up Data

Previous topic: Backing Up OMS Data

Next topic: Backing Up HBase Metadata

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot