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

EXASolution backup/restore processes for use with Amazon AWS S3™ buckets

    XMLWordPrintable

    Details

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

      Starting with version 5.0.14, EXASolution is capable of storing and retrieving backups to/from Amazon S3™ buckets.

      To use this feature, the following steps need to be done:

      1. create an Amazon S3™ bucket with appropriate permissions
      2. configure one or more DNS servers in EXAoperation (Network -> System)
      3. configure your network appropriately to be able to access the Amazon S3™ webservices from the database cluster
      4. add a new remote volume to the cluster in EXAoperation (EXAStorage -> Add Remote Volume):
        1. use your Amazon S3™ bucket URL in the URL field (something like https://$bucket.s3.amazonaws.com)
        2. In case of using a key/secret combination: Use key as User and secret as Password. Otherwise (in case of using EC2 app roles for the database nodes) leave those fields empty.
        3. Enter users in the Allowed Users and Read-only Users lists.
        4. Click the Add button.

      Afterwards, you will be able to use the newly created remote volume for database backups.

      For best experience with EXASOL and S3 as remote archive volume for backups we recommend to use S3 endpoints. Please note that in case of using S3 endpoints, the EXASOL cluster and the S3 endpoint has to be located in the same availability zone.

      Amazon Web Services, the “Powered by Amazon Web Services” logo and Amazon S3 are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.

      Show
      Starting with version 5.0.14, EXASolution is capable of storing and retrieving backups to/from Amazon S3™ buckets. To use this feature, the following steps need to be done: create an Amazon S3™ bucket with appropriate permissions configure one or more DNS servers in EXAoperation (Network -> System) configure your network appropriately to be able to access the Amazon S3™ webservices from the database cluster add a new remote volume to the cluster in EXAoperation (EXAStorage -> Add Remote Volume): use your Amazon S3™ bucket URL in the URL field (something like https://$bucket.s3.amazonaws.com ) In case of using a key/secret combination: Use key as User and secret as Password. Otherwise (in case of using EC2 app roles for the database nodes) leave those fields empty. Enter users in the Allowed Users and Read-only Users lists. Click the Add button. Afterwards, you will be able to use the newly created remote volume for database backups. For best experience with EXASOL and S3 as remote archive volume for backups we recommend to use S3 endpoints. Please note that in case of using S3 endpoints, the EXASOL cluster and the S3 endpoint has to be located in the same availability zone. Amazon Web Services, the “Powered by Amazon Web Services” logo and Amazon S3 are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.
    • Category 1:
      Plattform Support - EXASOL on AWS
    • Category 2:
      Cluster Administration - Backup

      Attachments

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated: