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 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
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 Segment hosts)

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

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

 — 

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

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

Full ssl certificate path

A full path to the SSL certificate. For example, /opt/adcc/ssl/adcc.crt

 — 

Full ssl key path

A full path to the SSL key. For example, /opt/adcc/ssl/adcc.key

 — 
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 user ou for LDAP synchronization. Enter each ou value on a separate line using the ou=<name> format (e.g. ou=users1)

 — 

Groups OUs

A list of group ou for LDAP synchronization. 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 database where ADB Control stores data

adcc

Listening port

An ADB Control listening port

5433

Data dir

A full path to the directory where ADB Control stores data. By default, ADB Control uses the Docker adcc_data volume

 — 
External database parameters
Parameter Description Default value

External database parameters

Whether or not to use an external database

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. The ADB Control listening port is ignored

5432
Database migration parameters
Parameter Description Default value

Migration completion timeout

A migration completion timeout (in minutes)

3
External ADQM parameters
Parameter Description Default value

External ADQM parameters

Whether or not to use external ADQM

false

ADQM address

An external ADQM address

 — 

External ADQM port

An external ADQM listening port

8123
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

Analytic DB server IP

An external IP address for Analytic DB

 — 

Analytic DB server port

An external port for Analytic DB

 — 

Analytic DB name

An Analytic database name

 — 

Connection username

A name of the Analytic DB user

 — 

Connection password

A password of the Analytic DB user

 — 
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

 — 

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 database

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. The ADBM listening port is ignored

5432
Database parameters
Parameter Description Default value

Database name

A name of the database where ADBM stores data

adbm
Database migration parameters
Parameter Description Default value

Migration completion timeout

A migration completion timeout (in minutes)

3
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. If empty, then the default system value is used. The property becomes available after setting the Use custom JAVA_HOME flag

 — 

PXF_JVM_OPTS

Sets PXF_JVM_OPTS

-Xmx2g -Xms1g

Force enable monitoring

Whether to enable monitoring if it was previously disabled via /var/lib/pxf/conf/pxf-application.properties

false

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