Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-268

EXASOL on Azure: Backup

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Solution:
      Hide

      Pulling backups from a database cluster

      For this setup to work, please ensure that sufficient disk space has been added to the database system.
      This means that there must be enough space for the database data and for at least one full backup.

      1. Log into the EXAoperation web frontend.
      2. Follow the "EXAStorage" link on the left side and press the "Add Volume" button in the new form.
      3. Choose appropriate values for your archive volume. For a one-node instance, these could be
        • Redundancy: 1
        • Allowed users: {your EXAoperation user}
        • Volume Type: Archive
        • Volume Size (GiB): {an appropriate size, e.g. your database size for one level-0 backup}
        • Nodes List: {your node}
        • Number of Master Nodes: 1
        • Disk: d03_storage
      4. Press the "Add" button.
      5. Follow the "EXASolution" link on the upper left and choose your database, which will open a new form.
      6. Choose the action "Backup" (on the upper right) and press "Submit".
      7. Choose your newly created archive volume and press "Start Backup".
      8. You can monitor the progress of the backup by following the "Monitoring" link on the left side and choosing a logservice for this database.
      9. After the backup has been finished, you can download the backup files with your favorite tool via ports 2022 (SFTP) or 2443 (HTTPS). If unencrypted interfaces have not been disabled in EXAoperation, you could also use 2021 (FTP) or 2080 (HTTP).

      For further information about pulling/downloading backups, see the section "EXAStorage-based databases" in SOL-68.

      Pushing backups to a remote server

      For this setup to work you need a FTP server, reachable from the database system. There are several possibilities and online manuals about how to do this, e.g. via vsftpd on top of an Ubuntu system (https://help.ubuntu.com/community/vsftpd).
      A common misconfiguration is that write permissions have not been correctly issued on the server side. Please ensure that read/write access has been properly configured. This can be checked with your favorite tool.

      1. Log into the EXAoperation web frontend.
      2. Follow the "EXAStorage" link on the left side and press the "Add Remote Volume" button in the new form.
      3. Choose appropriate values:
        • Archive URL: Name of the server URL, e.g. "ftp://yourserver.yourdomain"
        • User/Password: Add appropriate server credentials
        • Allowed Users: List of EXAoperation users that are allowed to read/write onto this remote volume
      4. Press the "Add" button. In the next window, you will see the newly created remote archive volume with state "OK". If the state shows something else (e.g. "Connection problems"), please re-check your entered values.
      5. Follow the "EXASolution" link on the upper left and choose your database, which will open a new form.
      6. Choose the action "Backup" (on the upper right) and press "Submit".
      7. Choose your newly created remote archive volume and press "Start Backup".
      8. You can monitor the progress of the backup by following the "Monitoring" link on the left side and choosing a logservice for this database.
      9. After successful completion, you can check the consistency of the newly created backup on the server side by verifying the MD5 sums in the "metadata_{TIMESTAMP}" file.

      Additional Information

      Please also refer to the following video tutorials:

      How to create online backups with EXASolution
      How to restore a database from a backup with EXASolution

      Show
      Pulling backups from a database cluster For this setup to work, please ensure that sufficient disk space has been added to the database system. This means that there must be enough space for the database data and for at least one full backup. Log into the EXAoperation web frontend. Follow the "EXAStorage" link on the left side and press the "Add Volume" button in the new form. Choose appropriate values for your archive volume. For a one-node instance, these could be Redundancy: 1 Allowed users: {your EXAoperation user} Volume Type: Archive Volume Size (GiB): {an appropriate size, e.g. your database size for one level-0 backup} Nodes List: {your node} Number of Master Nodes: 1 Disk: d03_storage Press the "Add" button. Follow the "EXASolution" link on the upper left and choose your database, which will open a new form. Choose the action "Backup" (on the upper right) and press "Submit". Choose your newly created archive volume and press "Start Backup". You can monitor the progress of the backup by following the "Monitoring" link on the left side and choosing a logservice for this database. After the backup has been finished, you can download the backup files with your favorite tool via ports 2022 (SFTP) or 2443 (HTTPS). If unencrypted interfaces have not been disabled in EXAoperation, you could also use 2021 (FTP) or 2080 (HTTP). For further information about pulling/downloading backups, see the section "EXAStorage-based databases" in SOL-68. Pushing backups to a remote server For this setup to work you need a FTP server, reachable from the database system. There are several possibilities and online manuals about how to do this, e.g. via vsftpd on top of an Ubuntu system ( https://help.ubuntu.com/community/vsftpd ). A common misconfiguration is that write permissions have not been correctly issued on the server side. Please ensure that read/write access has been properly configured. This can be checked with your favorite tool. Log into the EXAoperation web frontend. Follow the "EXAStorage" link on the left side and press the "Add Remote Volume" button in the new form. Choose appropriate values: Archive URL: Name of the server URL, e.g. "ftp://yourserver.yourdomain" User/Password: Add appropriate server credentials Allowed Users: List of EXAoperation users that are allowed to read/write onto this remote volume Press the "Add" button. In the next window, you will see the newly created remote archive volume with state "OK". If the state shows something else (e.g. "Connection problems"), please re-check your entered values. Follow the "EXASolution" link on the upper left and choose your database, which will open a new form. Choose the action "Backup" (on the upper right) and press "Submit". Choose your newly created remote archive volume and press "Start Backup". You can monitor the progress of the backup by following the "Monitoring" link on the left side and choosing a logservice for this database. After successful completion, you can check the consistency of the newly created backup on the server side by verifying the MD5 sums in the "metadata_{TIMESTAMP}" file. Additional Information Please also refer to the following video tutorials: How to create online backups with EXASolution How to restore a database from a backup with EXASolution
    • Category 1:
      Plattform Support - EXASOL on Azure
    • Category 2:
      Cluster Administration - Backup

      Attachments

        Activity

          People

          • Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: