Software requirements

Daria Barysheva

Overview

The software requirements for Arenadata DB installation are listed below:

  1. ADB supports the following operating systems:

    • RHEL 7.9.

    • CentOS 7.9.

    • Ubuntu 22.04 (in ADB 6 starting with ADB 6.27.1.56).

    • AltLinux 8.4 SP (for the Enterprise edition of ADB).

    • RED OS 7.3 Certified edition (for the Enterprise edition of ADB 6, starting with the version 6.27.1.58).

    • Astra Linux 1.7 "Orel" SE (for the Enterprise edition of ADB 6, starting with the version 6.25.2.52). See Requirements for Astra Linux below.

  2. If you use ClickHouse or PostgreSQL as external storage systems for ADB Control/ADBM (see Metrics DB and Query DB in Arenadata DB Control overview), the minimal required versions of these databases are:

    • ClickHouse 22.8

    • PostgreSQL 12.20

  3. ADB uses Docker as a containerization platform for some services (e.g. ADB Control, ADBM, Monitoring, Enterprise Tools). ADB supports Docker versions built by Linux vendors for the purpose of their operating systems. Starting with 6.25.2.52, ADB 6 supports Docker CE (Community Edition) and allows you to use a pre-installed Docker by setting the Use existing docker flag when configuring the ADB cluster.

    For CentOS, you need the following Docker version: docker-1.13.1-210.git7d71120.el7.centos.x86_64.

    IMPORTANT

    Starting with ADB 6.27.1.56, ADB Control rewrites Docker settings in the /etc/docker/daemon.json file for security purposes. Thus, if you need to modify this file, set the Use existing docker option when configuring ADB. This option will also allow you to use Docker in the rootless mode.

  4. ADB needs Java 17 for some services (e.g. PXF, ADB Control, ADBM). In all operating systems except CentOS and Astra Linux, no additional Java installation is needed since Java comes with the main operating system repository. In CentOS and Astra Linux, before ADB installation, you should install Java manually and fill in the Java path in the JAVA_HOME field when configuring the ADB cluster (this parameter is available in ADB 6 starting with ADB 6.25.2.52). This step is also necessary in other operating systems if you use Java 17 with a path different from the default one.

    The default Java paths for supported operating systems are listed below.

  • Ubuntu

  • RHEL

  • AltLinux

/usr/lib/jvm/java-17-openjdk-amd64

/usr/lib/jvm/jre-17-openjdk

/usr/lib/jvm/jre-17

IMPORTANT

  • If you plan to use custom Java (such as Axiom), Java 17 is required for installation.

  • For CentOS and Astra Linux, the JAVA_HOME field is mandatory starting with ADB 6.27.1.58.

  1. Starting with ADB 6.27.1.58, the minimal ADCM version is 2.0.0.

  2. Starting with ADB 6.27.1.58, the minimal Yandex hostprovider version is 3.11.

  3. ADB requires the en_US.utf8 operating system locale on all cluster hosts. Yet you do not need to select this locale as default. To view available locales, run the following command:

    $ localectl list-locales

  4. ADB requires the XFS file system. Other file systems (including EXT4) are not supported.

  5. It is recommended to switch off any antivirus software before ADB installation and during the ADB operation process. In case of using antivirus, please contact your antivirus software vendor to find out the settings necessary to allow ADB.

  6. When selecting an ADB database name, do not use cyrillic or the following reserved characters: ", &, ',   (space), (, ), ;, <, >, \, `, |. If such characters are present, Arenadata DB Backup Manager will not be able to backup/restore a database.

  7. During ADB installation, a bundle assigns the necessary permissions to the specific files and directories it creates, regardless of the umask value on cluster hosts.

  8. During ADB installation, the following changes are made at the operating system level. Do not change any of the objects listed below.

    • The following system files are modified:

      • /etc/fstab

      • /etc/hosts

      • /etc/hostname

      • /etc/chrony.conf

      • /etc/ssh/sshd_config

      • /etc/selinux/config

      • /etc/security/limits.conf

    • Some new files are created in the following folders:

      • /usr/lib/systemd/system/

      • /etc/cgconfig.d/

    • The SELinux service becomes disabled.

  9. The installation process creates a new file in the /var/spool/cron/ folder for ADB system user (by default, gpadmin). All technical accounts should be able to change that file as well (via crontab -e -u gpadmin).

  10. For online installation of ADB, all cluster hosts should have access to Arenadata repositories specified on the Configuration tab in the ADB cluster menu available via ADCM UI (see Arenadata repo url and Monitoring repo url fields). For offline installation, provide access to the host where the Enterprise Tools cluster is installed.

  11. For both online and offline installation, all cluster hosts should have access to the repositories that are listed below (or local mirrors should be created).

  • RHEL/CentOS

  • AltLinux

  • Astra Linux

Requirements for Astra Linux

  1. For the correct operation of ADB under Astra Linux, it is necessary to install cgroup v1. There are two options for switching hosts to cgroup v1:

    • Manually. If your operating system uses cgroup v2, you can switch to cgroup v1 in advance before you start ADB installation/upgrade.

    • Automatically. Starting with 6.26.0.53, ADB 6 supports automatic switching to cgroups v1. To do this, select the Reboot cluster servers after installation checkbox when installing/upgrading ADB.

      CAUTION

      If the Reboot cluster servers after installation flag is not set and manual switching is not performed, you will get an error when attempting to install/upgrade ADB under Astra Linux.

  2. ADB, like other analytical DBMS, is optimized to work with generic cores. Using the lowlatency cores may not provide optimal performance for tasks that are typical for analytical data processing. Due to this, for proper operation of ADB under Astra Linux, it is recommended to use generic cores only.

  3. You should also consider version compatibility. Starting with 6.26.2.55, ADB 6 supports only Astra Linux 1.7.5.

Found a mistake? Seleсt text and press Ctrl+Enter to report it