Configuration parameters

Daria Barysheva

This article describes the parameters that can be configured for ADB services via ADCM. To read about the configuring process, refer to the relevant articles: Online installation, Offline installation.

NOTE
Some of the parameters become visible in the ADCM UI after the Show advanced flag being set.

ADB

Main
Parameter Description Default value

Name of default database

A name of the database created by default. This database is maintained by crontab scripts (garbage collection, transaction wraparound, etc.)

adb

Use segment mirroring

Enables synchronous replication for primary data segments, i.e. adds mirror segments to the cluster. As a result, mirror segments provide higher availability for the stored data, but require twice more space. When the cluster has enough hosts, it uses spread mirroring policy, otherwise — group mirroring policy

true

ADB MADlib Extension

Whether or not to install the ADB MADlib Extension. MADlib is an open-source library for scalable in-database analytics that provides data-parallel implementations of mathematical, statistical, and machine-learning methods for structured and unstructured data. It provides a suite of SQL-based algorithms for machine learning, data mining, and statistics, that run at scale within a database engine with no need for transferring data between ADB and other tools

false

ADB PostGIS Extension

Whether or not to install the PostGIS Extension. PostGIS is a spatial database extension for PostgreSQL that allows GIS (Geographic Information Systems) objects to be stored in the database. The PostGIS extension includes support for GiST-based R-Tree spatial indexes and functions for analysis and processing of GIS objects

false

ADB GPperfmon Extension

Whether or not to install the ADB GPperfmon Extension. GPperfmon is a built-in activity monitor that populates tables in the gpperfmon database with a variety of info, including a list of slow queries, database usage statistics, system properties, and various other metrics

true

ADB Auto Core Dump Service

Whether or not to install Auto Core Dump Service — a plugin that enables core dump files for ADB processes. This feature is useful for debugging purposes. If enabled, the system collects core dumps and saves them in the following directory: /var/lib/systemd/coredump/. When the maximum storage size is reached (1 GB), old files will be deleted. The parameter is available starting with ADB version 6.21.1.36

false

Diskquota Extension

Whether or not to install the Diskquota Extension. The Diskquota module allows Arenadata DB administrators to limit the amount of the disk space used by schemas or roles in the database

false

PL/Python3u Extension

Whether or not to install the PL/Python3u Extension

false
Advanced
Parameter Description Default value

Number of segments per host

A number of primary segments on each Segment host. If the parameter is not set, then (<Number of CPU cores>) / 2 is used. When you customize a number of primary segments per host, remember that the more parallel SQL queries you plan to run simultaneously — the less segments per host you need

(<Number of CPU cores>) / 2

Segment host data directories

Directories that are used to store data on Segment hosts. The Number of segments per host should be a multiple of the number of directories. Directory names should be specified in the first column. In the second, optionally, it is possible to specify the devices that should be formatted and mounted in the corresponding directories on the Segment hosts, e.g. sdc (without the /dev prefix). Device names should be the same on all Segment hosts

/data1

Use nobarrier for segments

Whether or not to use the nobarrier option on Segment hosts. This option turns off I/O barriers. It is not recommended to use barriers in XFS

false

Masters host data directory

Directories that are used to store data on Master and Standby Master hosts

/data1

Mount master storage device for data

Whether or not to mount block storage devices to data directories on Master and Standby Master hosts. If no block storage devices are listed in the Master server storage device field, then nothing to be done

false

Master server storage device

Master storage devices, e.g. sdb (without the /dev prefix). Should be the same on all Master hosts (including Master and Secondary Master)

 — 

Use nobarrier for master

Whether or not to use the nobarrier option on Master hosts. This option turns off I/O barriers. It is not recommended to use barriers in XFS

false

Arenadata configs directory name

A name of the folder that contains Arenadata configuration files. It is located in the system user home directory

arenadata_configs

Sysctl parameters

Linux kernel parameters that are needed for ADB

 — 

System user GID

A unique identifier of the group that the system user belongs to. A system user should be created with the same UID and GID across all cluster servers in order to reduce problems with access to the common network storages, containing ADB backup files

2042

System user name

A system user name for ADB

gpadmin

System user UID

A unique identifier of the system user. A system user should be created with the same UID and GID across all cluster servers in order to reduce problems with access to the common network storages, containing ADB backup files

2042

Disable firewall

Whether or not to disable firewalld on the cluster hosts

true

Edit /etc/hosts

Whether or not to edit the /etc/hosts file during ADB installation to provide short host names instead of FQDN for the correct ADB work

true

Amount of shared memory

The amount of shared memory allocated for query metrics (in KB). The maximum size is 131072. Restart ADB to apply changes

5120

Maximum scan node’s instrumentations

The maximum number of scan node’s instrumentations per query (in shmem). Restart ADB to apply changes

300
Use dedicated cluster network
Parameter Description Default value

Cluster network

A subnet that is to be used for cluster nodes interconnection. Requires the "subnet/netmask" notation, for example 192.168.1.0/24. If this parameter is not set, then ADCM uses addresses with the default route. A host must have exactly one address in the range. Run Reinstall ADB to apply changes

 — 
Crontab
Parameter Description Default value

Crontab maintenance scripts

Crontab maintenance scripts of the ADB system user gpadmin. For more information, see Work with arenadata_toolkit

 — 

Delete old maintenane script logs

A number of days after which maintenance script logs should be deleted

30
Other
Parameter Description Default value

Custom pg_hba section

A custom part of the pg_hba.conf file

 — 

ADB Control

External ADB Control server parameters
Parameter Description Default value

External ADB Control server parameters

Whether or not to use an external ADB Control server

false

ADB Control address

An external ADB Control address. The property becomes available after setting the External ADB Control server parameters flag

 — 
UI component parameters
Parameter Description Default value

ADB user name

A user name that is used by ADB Control for connecting to ADB. Such access is required to obtain information about the cluster topology and to cancel requests initiated by users

adcc

Service password

The service API user password for interaction between ADB Control and ADCM. It is recommended to change the default value

 — 

Servername

A server name for connecting to the ADB Control via HTTP

 — 

Listening port

A port on which ADB Control UI is available via HTTP

81

Xmx ram parameter

A maximum Java heap size for the UI component

8

Log level

A logs level that is used by the UI component. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
HTTPS parameters enable
Parameter Description Default value

HTTPS parameters enable

Wether or not to enable ADB Control UI via HTTPS

false

Listening port

A port on which ADB Control UI is available via HTTPS

8443

Server certificate

Server certificate contents in the CRT format (*.crt file)

 — 

Server private key

Server private key contents (*.key file)

 — 

Verify system endpoints' certificates

A flag that indicates whether to verify certificates of system endpoints

false

Server JKS keystore path

A path to the keystore file in the JKS format for the ADB Control server part. For example, /opt/adcc/ssl/keystore.jks

 — 

Server JKS keystore password

A password that is used for connecting to Server JKS keystore path

 — 

Server JKS truststore path

A path to the truststore file in the JKS format for the ADB Control server part. For example, /opt/adcc/ssl/truststore.jks

 — 

Server JKS truststore password

A password that is used for connecting to Server JKS truststore path

 — 

Client JKS keystore path

A path to the keystore file in the JKS format for the ADB Control client part (ADB Control/ADBM agents). For example, /opt/ssl/keystore.jks

 — 

Client JKS keystore password

A password that is used for connecting to Client JKS keystore path

 — 

Client JKS truststore path

A path to the truststore file in the JKS format for the ADB Control client part (ADB Control/ADBM agents). For example, /opt/ssl/truststore.jks

 — 

Client JKS truststore password

A password that is used for connecting to Client JKS truststore path

 — 
UI LDAP authentication
Parameter Description Default value

UI LDAP authentication

Whether or not to use LDAP authentication

false

Type

A type of the LDAP server. Possible values:

  • MSAD — Microsoft Active Directory;

  • FreeIPA — 389 Directory server as a part of FreeIPA.

MSAD

URI

A URI for connecting to the LDAP server(-s). For example, ldap://example.com:389. A domain name can be used. Also, the name can be resolved to the addresses of several LDAP servers

 — 

Users baseDN

A limitation of the search scope of objects in the LDAP directory that is used in users search requests

 — 

Groups baseDN

A limitation of the search scope of objects in the LDAP directory that is used in groups search requests

 — 

Users OUs

A list of OU for user search. If the option is set, users will be searched only in the specified OUs, otherwise — within full Users baseDN. Enter each OU value on a separate line using the ou=<name> format (e.g. ou=users1)

 — 

Groups OUs

A list of OU for group search. If the option is set, groups will be searched only in the specified OUs, otherwise — within full Groups baseDN. Enter each OU value on a separate line using the ou=<name> format (e.g. ou=groups1)

 — 

Group

A group name that is used for service requests to the LDAP server

 — 

Login

A user name that is used for service requests to the LDAP server

 — 

Password

A user password that is used for service requests to the LDAP server

 — 

Size limit

A maximum number of records that can be returned by the LDAP server

1000

Lowercase login

Whether or not to convert user names to lowercase

false
Backend parameters
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for the backend component

8

Log level

A logs level that is used by the backend component. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
Registry parameters
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for the registry component

2

Log level

A logs level that is used by the registry component. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
Database parameters
Parameter Description Default value

Database name

A name of the PostgreSQL database where ADB Control stores data (Query DB)

adcc

Username

A user name that is used for connecting to the PostgreSQL database

postgres

Password

A user password that is used for connecting to the PostgreSQL database

 — 

Listening port

A listening port for the PostgreSQL database

5433

Data dir

A full path to the directory where ADB Control stores PostgreSQL data. ADB Control uses the default Docker volume directory unless otherwise specified

 — 
CAUTION

The Data dir directory should be empty before database initialization during ADB Control installation.
External database parameters
Parameter Description Default value

External database parameters

Whether or not to use an external PostgreSQL database as Query DB for ADB Control

false

Server ip

An IP address of the server where the external PostgreSQL database is stored

 — 

External database port

A listening port of the server where the external PostgreSQL database is stored

5432

Database name

A name of the external PostgreSQL database

adcc

Username

A user name that is used for connecting to the external PostgreSQL database

postgres

Password

A user password that is used for connecting to the external PostgreSQL database

 — 
Database migration parameters
Parameter Description Default value

Migration completion timeout

A migration completion timeout (in minutes)

5
ADQM database parameters
Parameter Description Default value

Data dir

A full path to the directory where ADB Control stores ClickHouse data. ADB Control uses the default Docker volume directory unless otherwise specified

 — 

Database name

A name of the ClickHouse database that is used as Metrics DB in ADB Control

adcc

Username

A user name that is used for connecting to the ClickHouse database

default

Password

A user password that is used for connecting to the ClickHouse database

 — 
External ADQM parameters
Parameter Description Default value

External ADQM parameters

Whether or not to use an external ClickHouse database as Metrics DB for ADB Control

false

ADQM address

An IP address of the server where the external ClickHouse database is stored

 — 

External ADQM port

A listening port of the server where the external ClickHouse database is stored

8123

Database name

A name of the external ClickHouse database

adcc

Username

A user name that is used for connecting to the external ClickHouse database

 — 

Password

A user password that is used for connecting to the external ClickHouse database

 — 
Agent parameters
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for ADB Control agents

2

Log level

A logs level that is used by ADB Control agents. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO

Servers list update timeout

A timeout between refreshing information about available ADB Control Backend Servers instances (in ms)

5000
ADB Control scheduler param
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for ADB Control scheduler

2

Log level

A logs level that is used by ADB Control scheduler. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
Advanced parameters
Parameter Description Default value

Backend app parameters

Application parameters of the ADB Control backend

 — 

Backend logback parameters

Logback parameters of the ADB Control backend

 — 

Registry app parameters

Application parameters of the ADB Control registry

 — 

Registry logback parameters

Logback parameters of the ADB Control registry

 — 

UI server app parameters

Application parameters of the ADB Control UI

 — 

UI server logback parameters

Logback parameters of the ADB Control UI

 — 

Scheduler app parameters

Application parameters of the ADB Control scheduler

 — 

Scheduler logback parameters

Logback parameters of the ADB Control scheduler

 — 

Migration app parameters

Properties of the migration application

 — 

ADB Control agent properties

Properties of the ADB Control agent

 — 

ADB Control agent logback parameters

Logback parameters of the ADB Control agent

 — 

ADB Control agent override parameters

Override parameters of the ADB Control agent

 — 

ADB Control agent service config parameters

Service configuration parameters of the ADB Control agent

 — 

ADBM

Backend parameters
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for the ADBM backend

8

Log level

A logs level that is used by the ADBM backend. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
Agent parameters
Parameter Description Default value

Xmx ram parameter

A maximum Java heap size for the ADBM agent

2

Log level

A logs level that is used by the ADBM agent. Possible values are TRACE, DEBUG, INFO, WARN, ERROR

INFO
External database parameters
Parameter Description Default value

External database parameters

Whether or not to use an external PostgreSQL database for ADBM

false

Server ip

An IP address of the server where the external database is stored

 — 

External database port

A listening port of the server where the external database is stored

5432

Database name

A name of the external database

adbm

Username

A user name that is used for connecting to the external database

postgres

Password

A user password that is used for connecting to the external database

 — 
Database migration parameters
Parameter Description Default value

Migration completion timeout

A migration completion timeout (in minutes)

3

Xmx ram parameter GB

The maximum memory pool allocated for a Java Virtual Machine (JVM) in GB

1
Advanced parameters
Parameter Description Default value

Backend app parameters

Application parameters of the ADBM backend

 — 

Backend logback parameters

Logback parameters of the ADBM backend

 — 

Backend auth properties

Authorization properties of the ADBM backend

 — 

ADBM agent properties

Properties of the ADBM agent

 — 

ADBM agent logback parameters

Logback parameters of the ADBM agent

 — 

ADBM agent override parameters

Override parameters of the ADBM agent

 — 

ADBM agent service config parameters

Service configuration parameters of the ADBM agent

 — 

Chrony

Parameter Description Default value

NTP servers

Addresses of valid NTP servers. For example, 0.ru.pool.ntp.org, 1.ru.pool.ntp.org. If this parameter is set, then Master takes the time from NTP servers, Secondary Master — from Master or NTP servers, Segment hosts — from Master or Secondary Master. If the parameter is not set or all NTP servers become unavailable, then Master uses its local clocks, Secondary Master uses the Master or local clocks, and Segment Hosts get the time from Master or Secondary Master

 — 

Monitoring Clients

Parameter Description Default value

Protocol

A transport protocol for sending metrics to the monitoring cluster. Possible values are TCP and UDP. A UDP protocol is supported by monitoring clusters of the 2.8 version or later

TCP

Enable echo ADB-specific metrics

Whether or not to echo ADB-specific metrics to the output of the /home/gpadmin/arenadata_configs/arenadata_segments_monitor.sh monitoring script

false

Check adb monitoring

Whether or not to check if monitoring agents are installed on the ADB service hosts

true

PXF

Parameter Description Default value

Use custom JAVA_HOME

Whether or not to use a custom JAVA_HOME path

false

JAVA_HOME

A custom JAVA_HOME path. Should lead to the working JAVA. The property becomes available after setting the Use custom JAVA_HOME flag. If empty, then the default system value is used:

  • /usr/lib/jvm/jre-11-openjdk (for all operating systems)

 — 

PXF_JVM_OPTS

Sets PXF_JVM_OPTS

-Xmx2g -Xms1g

PXF log4j properties

log4j properties for PXF

 — 

Use custom PXF_BASE

Whether or not to use a custom PXF_BASE path

false

PXF_BASE

A custom PXF_BASE path for PXF installation. The property becomes available after setting the Use custom PXF_BASE flag

/var/lib/pxf

Encryption

Whether or not to use encryption

false

Keystore file

An absolute path to the JKS keystore file. For example, /var/lib/pxf/conf/pxfkeystore.jks

 — 

Keystore password

A JKS keystore password

 — 

Encryption key alias

An encryption key alias. Do not enter a private key in this field

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