Create Local Archive Volume
This section explains how to create a local archive volume.
This procedure is carried out using ConfD.
Procedure
The following examples use the command-line tool confd_client in a Linux terminal connected to a database node. For more information about how to use this tool, see ConfD.
Create a local archive volume
To create a local archive volume, use the ConfD job st_volume_create and set the parameters described in the following table.
Some parameters values for the new archive volume must match the corresponding values for the data volume. To find out the values used by the data volume, use the ConfD jobs db_info and st_node_list.
st_node_list
[root@n11 ~]# confd_client st_node_list
'0':
hdd_free_space:
disk1: 93.5566 GiB
hdds:
name: /dev/nvme2n1
type: disk1
...
name: /dev/nvme3n1
type: disk1
...
name: n11
...
'1':
hdd_free_space:
disk1: 93.5566 GiB
hdds:
name: /dev/nvme2n1
type: disk1
...
name: /dev/nvme3n1
type: disk1
...
name: n12
...
'2':
hdd_free_space:
disk1: 93.5566 GiB
hdds:
name: /dev/nvme2n1
type: disk1
...
name: /dev/nvme3n1
type: disk1
...
name: n13
...
'3':
hdd_free_space:
disk1: 93.5566 GiB
hdds:
name: /dev/nvme2n1
type: disk1
...
name: /dev/nvme3n1
type: disk1
...
name: n14
...
Required parameters
Parameter Name |
Data type |
Value |
---|---|---|
|
string |
The disk name in Exasol for the storage disk where the data volume resides. |
|
tuple, list |
Owner tuple (or list of tuples) for the data volume. |
|
list |
List of node IDs in the data volume. |
num_master_nodes
|
integer |
The number of master nodes (active nodes) in the data volume. |
|
string |
A name for the new archive volume. |
|
integer |
The redundancy level of the archive volume. |
|
string |
Volume size for the archive volume as a string, with unit (MiB, GiB, or TiB). The size value depends on the database size and the backup schedule. |
|
string, integer |
|
|
boolean |
|
|
string |
|
block_size
|
string | 512 KiB
|
stripe_size
|
string | 512 KiB
|
Master Nodes
The parameter num_master_nodes
defines the number of master nodes that the volume will use. The number of master nodes must match the number of active nodes in the cluster. For example: in a cluster that will have 4 active nodes and 1 reserve node (4+1), the number of master nodes is 4.
In the following example, we create a 1 TiB data volume with the name LocalArchiveVolume1 on the storage disk disk1 with 4 master nodes and redundancy 2. The command returns the volume ID for the new volume (vid: 3
).
confd_client -c st_volume_create -a '{"name": "LocalArchiveVolume1", "disk": "disk1", "type": "archive", "size": "1 TiB", "num_master_nodes": 4, "nodes": [11, 12, 13, 14], "redundancy": 2, "partition_size": 274877906944, "shared": true, "owner": [500,500]}'
# ConfD will return the volume ID of the new archive volume:
vid: 3
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 the properties of the new local archive volume, use the ConfD job st_volume_info with the volume ID: