Конференция Arenadata
Новое время — новый Greenplum
Мы приглашаем вас принять участие в конференции, посвященной будущему Open-Source Greenplum 19 сентября в 18:00:00 UTC +3. Встреча будет проходить в гибридном формате — и офлайн, и онлайн. Онлайн-трансляция будет доступна для всех желающих.
Внезапное закрытие Greenplum его владельцем — компанией Broadcom - стало неприятным сюрпризом для всех, кто использует или планирует начать использовать решения на базе этой технологии. Многие ожидают выхода стабильной версии Greenplum 7 и надеются на её дальнейшее активное развитие.
Arenadata не могла допустить, чтобы разрабатываемый годами Open-Source проект Greenplum прекратил своё существование, поэтому 19 сентября мы представим наш ответ на данное решение Broadcom, а участники сообщества получат исчерпывающие разъяснения на все вопросы о дальнейшей судьбе этой технологии.

На конференции вас ждёт обсуждение следующих тем:

  • План возрождения Greenplum;
  • Дорожная карта;
  • Экспертное обсуждение и консультации.
Осталось до события

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).

    • 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 Qquery DB in Arenadata DB Control overview), the minimal required versions of these databases are:

    • ClickHouse 22.8

    • PostgreSQL 12.7

  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.

  4. ADB needs Java 11 for some services (e.g. PXF, ADB Control, ADBM). No additional Java installation is needed. Java comes with the main operating system repository. The following Java path is used by default:

    • /usr/lib/jvm/jre-11-openjdk

    If you use Java 11 with a path different from the default one, fill in the JAVA_HOME field when configuring the ADB cluster (this parameter is available in ADB 6 starting with ADB 6.25.2.52).

IMPORTANT

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

  1. 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

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

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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).

  8. 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.

  9. 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