Create Local Archive Volume

Procedure

This procedure is carried out using ConfD.

The ConfD examples are written in Bash on a Linux terminal running the Exasol tool confd_client, which is accessed by connecting to EXAClusterOS on the database nodes using Exasol Deployment Tool (c4). You can also interact with ConfD from an external tool using Python and XML-RPC. For more information, see ConfD.

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

Create a local archive volume

To create a local archive volume, use the ConfD job st_volume_createThe following input parameters must be set:

Input parameter

 Data type

Value

disk

string

The name of the data volume.

name

string

Enter a name for the new local archive volume.

nodes

list

List of node IDs in the data volume.
num_master_nodes integer

The number of master nodes in the data volume.

owner

tuple, list

Owner tuple (or list of tuples) for the data volume.

redundancy

integer

Redundancy level of the data volume.

size

string

Volume size with unit in string format.

The value depends on the database size and the backup schedule.

partition_size

string, integer

4294967296 for volumes <250 GiB

34359738368 for volumes ≥ 250 GiB and <1TiB

274877906944 for volumes ≥ 1 TiB

shared

boolean

true

type

string

archive

block_size string 512 KiB
stripe_size string 512 KiB

To get the necessary parameter values for the data volume, use the ConfD job st_volume_list to find the name or ID of the data volume, then use st_volume_info to get the details for that volume. For example:

confd_client -c st_volume_list
...
name: DataVolume1
...
confd_client -c st_volume_info -a '{"vname": "DataVolume1"}'
...
disk: disk1
group: 500
id: 0
name: DataVolume1
nodes:
- 11
num_master_nodes: 1
owner: 500
redundancy: 1
...

Example:

confd_client -c st_volume_create -a '{"name": "LocalArchiveVolume1", "disk": "disk1", "type": "archive", "size": "1 TiB", "num_master_nodes": 1, "nodes": [11], "redundancy": 1, "partition_size": 274877906944, "shared": true, "owner": [500,500]}'

The ConfD job st_volume_create does not necessarily use the specified size, but does internal rounding. Use the ConfD job st_volume_info to check the actual size of the archive volume after creation to see if it is acceptable. If the rounding takes up too much space, contact Support.

Enable optimizations

To enable optimizations for the local archive volume, use the ConfD job st_volume_add_label

confd_client -c st_volume_add_label -a '{"vname": "LocalArchiveVolume1", "label": "useinitopt"}'
confd_client -c st_volume_add_label -a '{"vname": "LocalArchiveVolume1", "label": "usesearchopt"}'

Verification

To verify that the new local archive volume has been added with the desired configuration, use the ConfD jobs st_volume_list and st_volume_info as described above.