No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FusionInsight HD 6.5.0 Administrator Guide 02

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Backing Up Hive Data

Backing Up Hive Data

Scenario

To ensure system data security routinely or before and after a critical operation (such as upgrade and migration) on Hive, Hive 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 Hive data. Both automatic backup tasks and manual backup tasks are supported.

  • The Hive backup and recovery function cannot identify the service and structure relationships of objects such as Hive tables, indexes, and views. When executing backup and recovery tasks, the user needs to manage a unified recovery point based on the service scenario to ensure proper service running.
  • The Hive backup and recovery function does not support Hive on RDB data tables. The original data tables need to be backed up and recovered in the external database independently.
  • Assume that a Hive backup task has been created and includes Hive on HBase tables, and the current backup data in the standby cluster is lost. The next incremental task will fail and a new Hive backup task needs to be created. The next full backup task will be normal.

Prerequisites

  • 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. For details, see the Software Installation.
  • If the active cluster employs the security mode, cross-cluster trust relationship has been configured for the active and standby clusters. For details, see Configuring Cross-Cluster Mutual Trust Relationships. If the active cluster employs the normal mode, no cross-cluster trust relationship is required.
  • 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 backup policies, such as the backup task type, period, backup object, and YARN queue that required by the backup task.
  • Check whether HDFS of the standby cluster has sufficient space. It is recommended the directory for storing backup files be a user-defined directory.
  • On the HDFS client, run hdfs lsSnapshottableDir as user hdfs to check the list of directories for which HDFS snapshots have been created in the current cluster. Ensure that the HDFS parent directory or subdirectory where data files to be backed up are stored does not have HDFS snapshots. Otherwise, the backup task cannot be created.
  • You have logged in to FusionInsight Manager. For details, see Logging In to the Management System.
  • If you want to back up data to the NAS, you need to deploy the NAS server in advance.

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. 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.

    To create a periodic backup task, set the following parameters in addition to the preceding parameters:

    • Start Time: indicates the time when the task is started for the first time.
    • Period: indicates task execution interval. The options include By Hours and By Days.
    • Backup Policy: indicates the volume of data to be backed up in each task execution. The options include Full backup at the first time and incremental backup subsequently, Full backup every time, and Full backup once every n times. When the parameter is set to Full backup once every n times, n must be specified.

  5. Set Configuration to Hive.
  6. Set Path Type of Hive to a backup directory type.

    The following backup directory types are supported:

    • 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:
      • 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 cluster.
      • Maximum Number of Maps: indicates the maximum number of maps in a MapReduce task. The default value of this parameter is 20.
      • Maximum Bandwidth of a Map (MB/s): indicates the maximum bandwidth of a map. The default value of this parameter is 100.
      • NameService Name: indicates the NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.
    • NFS: indicates that backup files are stored in the NAS over the NFS protocol. If you select NFS, set the following parameters:
      • Server IP address: indicates the NAS server IP address.
      • Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
      • Server shared Path: indicates the configured shared directory on the NAS server.
      • 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 cluster.
      • Maximum Number of Maps: indicates the maximum number of maps in a MapReduce task. The default value of this parameter is 20.
      • Maximum Bandwidth of a Map (MB/s): indicates the maximum bandwidth of a map. The default value of this parameter is 100.
      • NameService Bame: indicates the NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.
    • CIFS: indicates that backup files are stored in the NAS over the CIFS protocol. If you select CIFS, set the following parameters:
      • 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.
      • Maximum Number of Backup Copies: indicates the number of backup files that can be retained in the backup directory.
      • Server Shared Path: indicates the configured shared directory on the NAS server.
      • 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 cluster.
      • Maximum Number of Maps: indicates the maximum number of maps in a MapReduce task. The default value of this parameter is 20.
      • Maximum Bandwidth of a Map (MB/s): indicates the maximum bandwidth of a map. The default value of this parameter is 100.
      • NameService Name: indicates the NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.

  7. Set Maximum number of recovery points to the number of snapshots that can be retained in the cluster.
  8. Set Backup object to one or multiple Hive tables to be backed up.

    The following methods are supported to select backup data:

    • Select directly

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

    • Select using regular expressions
      • Click Query Regular Expression.
      • Enter the database where the Hive tables are located in the first text box as prompted. The database must be the same as the existing database, for example, default.
      • Enter a regular expression in the second text box. Standard regular expressions are supported. For example, if all tables in the database need to be filtered, enter ([\s\S]*?). If tables of which the names consisting of letters and digits, such as tb1, need to be filtered, enter tb\d*.
      • Click Refresh to view the selected tables in Directory Name.
      • Click Synchronize to save the result.
    NOTE:
    • When entering regular expressions, you can click or to add or delete an expression.
    • If the selected table or directory is incorrect, click Clear Selected Node to deselect it.

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

    The possible causes of check failure are as follows:

    • Target NameNode IP address is incorrect.
    • The queue name is incorrect.
    • The HDFS parent directory or subdirectory where data files to be backed up are stored has HDFS snapshots.
    • The directory or table to be backed up does not exist.

  10. Click OK to save the settings.
  11. 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_data source_task creation time, and the subdirectory is used to save latest data source backup files. All the backup file sets are saved to the related snapshot directories.

Download
Updated: 2019-05-17

Document ID: EDOC1100074522

Views: 5927

Downloads: 12

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next