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

HUAWEI CLOUD Stack 6.5.0 Backup and Restoration Guide 03

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).
Analytic DataBase Service

Analytic DataBase Service

Backup Mode

Local Backup

ADS has a small volume of data to be backed up. Backup files are stored in /opt/gaussdbcore/back_up_data of the EIS_PublicVM_service VM. You can obtain backup files from this path to restore data.

Backing Up a Database

Scenarios

This backup and restoration solution applies only to backend GaussDB on the management plane.

Databases on the management plane are the gausscore database. The active and standby gausscore databases are deployed on two VMs separately.

The gausscore databases support active/standby switchover. After the active/standby switchover, the original standby database becomes the active database. The backup function is also required for the new active database. Therefore, a backup and restoration package must be deployed on both the active and standby gausscore databases.

Restrictions

The backup of the two-node GaussDB cluster can be performed only on the active database but not on the standby database.

Installing the Backup Tool

The backup tool has been automatically installed during ADS deployment and you do not need to manually install it.

Automatic Backup
  1. Use PuTTY to log in to the active database node and go to the path storing the application.properties configuration file.

    Default username: ads; default password: Cloud12#$

    cd /opt/dbs/ads/

  2. Edit database backup configurations in the application.properties file.

    NOTE:

    Retain the default parameter values in the file.

    • on_database: Indicates whether to enable automatic database backup. The value can be on or off.
    • gauss_pwd: Indicates the gaussdb password. Use the password that has been encrypted using WCC.
    • db_name: Indicates the database name, which does not need to be changed.
    • db_user: Indicates the database username, which does not need to be changed.
    • backup_file_name: Indicates the backup file name.
    • db_backup_sh_path: Indicates the default path storing the backup tool. The path does not need to be changed since it is created during deployment.
    • root_pwd: Indicates the password of the root user for the node where EIS_PublicVM_Service is deployed. Use the password that has been encrypted using WCC.

  3. The system automatically backs up data at 02:00 every day.
Manual Backup

Perform the following operations to back up data.

  1. Use PuTTY to log in to the active database node and go to the ads directory.

    Default username: ads; default password: Cloud12#$

    cd /opt/dbs/ads/

  2. Run the following command to back up database:

    sh DBbackup.sh adsdb adsdb Eis@Remote123 ads.sql Cloud12#$ 7 ads SFTP_USER SFTP_IP UPLOAD_PATH SFTP_PASSWORD

    • adsdb: indicates the first adsdb is the gaussdb database name, which corresponds to db_name in the application.properties file.
    • adsdb: indicates the second adsdb is the gaussdb username, which corresponds to db_user in the application.properties file.
    • Eis@Remote123: indicates the gaussdb plaintext password, corresponding to the plaintext for gauss_pwd in application.properties.
    • ads.sql: indicates the name of the backup file, corresponding to backup_file_name in the application.properties file.
    • Cloud12#$: indicates the plaintext password of the root account, corresponding to the plaintext for root_pwd in the application.properties file.
    • 7: indicates the number of backup data copies. The default value is 7.
    • ads: indicates the name of the current service.
    • SFTP_USER: indicates the username of the SFTP server for uploading database backup files.
    • SFTP_IP: indicates the IP address of the SFTP server for uploading database backup files.
    • UPLOAD_PATH: indicates the path for storing backup files on the SFTP server. (This path must exist.)
    • SFTP_PASSWORD: indicates the user password of the SFTP server for uploading database backup files.

  3. Check whether the backup has been successfully performed.

    Method 1: Check the output of the backup command.

    Method 2: Switch to the root user and then the gausscore user. Then, run the cd /opt/gaussdbcore/back_up_data command to view the ads.sql_xxx.tar.gz backup file.

Translation
Download
Updated: 2019-06-14

Document ID: EDOC1100062366

Views: 833

Downloads: 10

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