Create Remote Archive Volume

In Exasol, backups can be stored online in an archive volume (local archive volume) or on a remote archive volume. This section provides you with information on how to create a remote archive volume.

Prerequisites

You need the following to configure the remote backup :

  • All nodes must be able to reach the remote target.
  • The user must have read-write access to the remote server
  • The URL of the archive volume as described in Create Remote Archive Volume.

Procedure

This procedure is carried out using ConfD. For more information, see ConfD.

The following examples are written in Bash on a Linux terminal and use the tool confd_client, which is accessed by connecting to EXAClusterOS on the database nodes. You can also interact with ConfD using Python and XML-RPC. For more information, see ConfD.

Placeholder values are normally indicated with UPPERCASE characters. Replace the placeholders with your own values.

  1. To interact with ConfD, connect to EXAClusterOS on the database access node. For example:

    c4 connect -t1/cos

    When you are connected to EXAClusterOS you can run ConfD jobs using confd_client.

  2. To find the name of the database, use the ConfD job db_list. For example:

    confd_client -c db_list

  3. Each remote archive volume must be created with the same owner as the database which will write backups to the volume. To find the owner's name, use the ConfD job db_info and replace DATABASE_NAME with your database name. For example:

    confd_client -c db_info -a 'db_name: DATABASE_NAME' | grep owner -A 2

    4. The output is similar to the following:

    owner:
    - 500
    - 500

  4. To create a remote archive volume, use the ConfD job remote_volume_add and insert the appropriate values that you found in the previous steps. 

    confd_client -c remote_volume_add -a '{url: ARCHIVE_VOLUME_URL, vol_type: TYPE, username: VOLUME_USERNAME, password: VOLUME_PW, owner: OWNER_TUPLE}'

    For example, a remote archive volume to an S3 bucket looks like:

    confd_client -c remote_volume_add -a '{url: https://BUCKET_NAME.s3.amazonaws.com, vol_type: s3, username: ACCESS_KEY_ID, password: ACCESS_KEY, owner: [500,500]}'

Verification

You can verify the volume was created by finding the volume ID and then checking its properties. To find the volume ID, use the ConfD job remote_volume_list:

confd_client -c remote_volume_list

The output is similar to the following:

- r0001

To check the properties of the remote archive volume, use the ConfD job remote_volume_info and insert the name of the volume. For example:

confd_client -c remote_volume_info -a 'remote_volume_name: r0001'