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 |
---|---|---|
|
string |
The name of the data volume. |
|
string |
Enter a name for the new local archive volume. |
|
list |
List of node IDs in the data volume. |
num_master_nodes
|
integer |
The number of master nodes in the data volume. |
|
tuple, list |
Owner tuple (or list of tuples) for the data volume. |
|
integer |
Redundancy level of the data volume. |
|
string |
Volume size with unit in string format. The value depends on the database size and the backup schedule. |
|
string, integer |
|
|
boolean |
|
|
string |
|
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_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.