Vertica Analytics Platform Version 9.2.x Documentation

Configure Storage

Use a dedicated Azure storage account for node storage.

Caution: Do not store your information on the root volume, especially your data and catalog directories. Storing information on the root volume may result in data loss.

When configuring your storage, make sure to use a supported file system. For details, see Recommended Storage Format Types.

Attach Disk Containers to Virtual Machines (VMs)

Using your previously created storage account, attach disk containers to your VMs that are appropriate to your needs.

For best performance, combine multiple storage volumes into RAID-0. For most RAID-0 implementations, attach 6 storage disk containers per VM.

Combine Disk Containers for Storage

If you are using RAID, follow these steps to create a RAID-0 drive on your VMs. The following example shows how you can create a RAID-0 volume named md10 from 6 individual volumes named:

  • sdc
  • sdd
  • sde
  • sdf
  • sdg
  • sdh
  1. Form a RAID-0 volume using the mdadm utility:
    $ mdadm --create /dev/md10 --level 0 --raid-devices=6 
      /dev/sdc /dev/sdd /dev/sde /dev/sdf /dev/sdg /dev/sdh
  2. Format the file system to be one that Vertica supports:
    $ mkfs.ext4 /dev/md10
  3. Find the UUID on the newly formed RAID volume:
    ls -l /dev/disk/by-uuid
  4. Copy the UUID and place it in the FSTAB file.
    $ sudo vi /etc/fstab
    UUID=<uuid here> /dev/md10 ext4 defaults , errors=remount-ro 0 1
  5. Create folders for your Vertica data and catalog.
    $ mkdir /vertica $ mkdir /vertica/data
  6. Mount the RAID volume to your data and catalog directories.
    $ mount /dev/md10 /home/dbadmin/vertica/data

Create a Swap File

In addition to storage volumes to store your data, Vertica requires a swap volume or swap file to operate.

Create a swap file or swap volume of at least 2 GB. The following steps show how to create a swap file within Vertica on Azure:

  1. Install devnull and swapfile:
    $ install -o root -g root -m 0600 /dev/null /swapfile
  2. Create the swap file:
    $ dd if=/dev/zero of=/swapfile bs=1024 count=2048k
  3. Prepare the swap file using mkswap:
    $ mkswap /swapfile
  4. Use swapon to instruct Linux to swap on the swap file:
    $ swapon /swapfile
  5. Persist the swapfile in FSTAB:
    $ echo "/swapfile swap swap auto 0 0" >> /etc/fstab

Repeat the volume attachment, combination, and swap file creation procedures for each VM in your cluster.

For More Information