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).
Recovering Hive Data

Recovering Hive Data

Scenario

Hive data needs to be recovered in the following scenarios: data is modified or deleted unexpectedly and needs to be restored. After an administrator performs critical data adjustment in Hive, an exception occurs or the operation has not achieved the expected result. All modules are faulty and become unavailable. Data is migrated to a new cluster.

System administrators can create a recovery task in FusionInsight Manager to recover Hive data. Only manual recovery tasks are supported.

Hive backup and recovery 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.

  • Data recovery can be performed only when the system version is consistent with that of data backup.
  • To recover data when the service is running properly, you are advised to manually back up the latest management data before recovering data. Otherwise, the Hive data that is generated after the data backup and before the data recovery will be lost.

Impact on the System

  • During data recovery, user authentication stops and users cannot create new connections.
  • After the data is recovered, the data produced between the backup time and restoration time is lost.
  • After the data is recovered, the Hive upper-layer applications need to be started.

Prerequisites

  • 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.
  • Plan the database for storing recovered data tables, the HDFS save path of data tables, and the list of users who can access recovered data.
  • The Hive backup file save path is correct.
  • The Hive upper-layer applications are stopped.
  • You have logged in to FusionInsight Manager. For details, see Logging In to the Management System.

Procedure

  1. On FusionInsight Manager, choose O&M > Backup and Restoration > Backup Management.
  2. In the Operation column of a specified task in the task list, click More > View History to view historical backup task execution records.

    In the displayed window, locate a specified success record and click View in the Backup Path column to view the backup path information of the task and find the following information:

    • Backup Object specifies the data source of the backup data.
    • Backup Path specifies the full path where the backup files are saved.

      Select the correct item, and manually copy the full path of backup files in Backup Path.

  3. On FusionInsight Manager, choose O&M > Backup and Restoration > Restoration Management.
  4. Click Create.
  5. Set Task Name to the name of the recovery task.
  6. Select Hive.
  7. 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:
      • Source NameNode IP Address: indicates the NameNode service plane IP address of the standby cluster, supporting the active node or standby node.
      • Source Path: indicates the full path of the HDFS directory for storing standby cluster backup data. For example, backup path/backup task name_data source_task creation time/.
      • Queue Name: indicates the name of the YARN queue used for backup task execution.
      • Recovery Point List: Click Refresh and select an HDFS directory that has been backed up in the standby cluster.
      • Target NameService Name: indicates the target NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.
      • 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.
    • 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.
      • Source Path: indicates the complete path of the backup file on the NAS server. For example, backup path/backup task name_data source_task creation time/.
      • Queue Name: indicates the name of the YARN queue used for backup task execution.
      • Recovery Point List: Click Refresh and select an HDFS directory that has been backed up in the standby cluster.
      • Target NameService Name: indicates the target NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.
      • 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.
    • 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.
      • Source Path: indicates the complete path of the backup file on the NAS server. For example, backup path/backup task name_data source_task creation time/.
      • Queue Name: indicates the name of the YARN queue used for backup task execution.
      • Recovery Point List: Click Refresh and select an HDFS directory that has been backed up in the standby cluster.
      • Target NameService Name: indicates the target NameService that corresponds to the selected backup directory. The default value of this parameter is hacluster.
      • 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.

  8. Set Backup Data in the Data Configuration to one or multiple backup data sources to be recovered based on service requirements. In the Target Database and Target Path columns, specify the target database and file save path after backup data recovery.

    Configuration restrictions:

    • Data can be recovered to the original database, but data tables must be stored in a new path that is difference from the backup path.
    • To recover Hive index tables, select the Hive data tables that correspond to the Hive index tables to be recovered.
    • If a new recovery directory is selected to avoid affecting the current data, HDFS permission must be manually granted so that users who have permission of backup tables can access this directory.
    • Data can be recovered to other databases. In this case, HDFS permission must be manually granted so that users who have permission of backup tables can access the HDFS directory that corresponds to the database.

  9. Set Force recovery to YES, which indicates to forcibly recover all backup data when a data table with the same name already exists. If the data table contains new data added after backup, the new data will be lost after the data recovery. If you set the parameter to NO, the recovery task is not executed if a data table with the same name exists.
  10. Click Verify to check whether the recovery task is configured correctly.

    • If the queue name is incorrect, the verification fails.
    • If the specified directory to be recovered does not exist, the verification fails.
    • If the forcibly replacement conditions are not met, the verification fails.

  11. Click OK to save the settings.
  12. In the recovery task list, locate a created task and click Start in the Operation column to execute the recovery task.

    • After the recovery is successful, the progress bar is in green.
    • After the recovery is successful, the recovery task cannot be executed again.
    • If the recovery task fails during the first execution, rectify the fault and click Retry to execute the task again.

Download
Updated: 2019-05-17

Document ID: EDOC1100074522

Views: 6339

Downloads: 12

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