Arenadata Documentation
Our passion is to build efficient flexible solutions that scale up to dozens of petabytes
ADB
ADH
ADQM
ADS
ADPG
ADCM
ADPS
ADSCONTROL
Showing results: 5 of 16. See all results...
Products
Explore our range of solutions in the world of Big Data

Arenadata DB

Arenadata DB (ADB) is an open-source massively parallel relational DBMS that is based on PostgreSQL and intended for column storages with flexible horizontal scalability. Due to its architectural features and powerful query optimizer, ADB demonstrates a special reliability and high speed of SQL query processing against large data volumes, so it is widely used for Big Data analytics on an industrial scale.
For more convenient operation and launching practical tasks of any complexity, Arenadata DB comes with a number of additional tools that provide integration with external data storages, binary backup management, and real-time query monitoring. This functionality allows users to build solutions with full coverage of all processes related to business system maintenance.
Use cases
Advanced data analytics

The advanced analytics provided by ADB is being used across many verticals, including finance, manufacturing, automotive, government, energy, education, retail, and so on, to address a wide variety of problems.

Some of the Arenadata DB analytics capabilities include the ability to analyze a multitude of data types, leverage existing SQL knowledge, and train more models in less time by using the MPP architecture.

Additionally, ADB provides in-database analytics which allows you to run analytics directly in the database vs exporting and running your data in an external analytics engine.

Machine learning

Arenadata DB is an excellent database for machine learning – the study of computer algorithms that improve automatically through experience. Apache MADlib is an open-source, SQL-based machine learning library that runs in-database on ADB, as well as on PostgreSQL.

This combination helps to improve the parallelism, scalability, and predictive accuracy of a machine learning deployment. Data transformation and feature engineering capabilities are also available through MADlib for machine learning, including descriptive and inferential statistics, pivoting, sessionization, and categorical variables encoding.

Artificial intelligence

With ADB ability to ingest large volumes of data at high speeds, it makes this database a powerful tool for smart applications that need to interact intelligently based on an unlimited number of unique scenarios.

For example, a telecom company may use Arenadata DB AI capabilities in IoT (Internet of Things) systems with smart sensors to analyze and process events for maintenance, security, and operational efficiency purposes.

Enterprise
Community
Core Greenplum functionality
gpbackup/gprestore
PXF
Deploy & upgrade automation
Monitoring & Alerting
Offline installation
WAL Backup management
x86
Technical support 24/7
Corporate training courses
Tailored solutions
Available integrations
ADQM
Arenadata QuickMarts
ADB ClickHouse connector provides the possibility of high-speed, parallel data exchange between Arenadata DB and Arenadata QuickMarts (ADQM).
ADS
ADS
Writing data from Arenadata DB to Arenadata Streaming (ADS) is provided by PXF plugin. To read data there is an extension for Arenadata DB that implements transactional data load from ADS.
ADPG
ADPG
Two-way data exchange with Arenadata Postgres (ADPG) is available via PXF JDBC connector.
Kafka
Kafka
Writing data from Arenadata DB to Kafka is provided by PXF plugin. To read data there is an extension for Arenadata DB that implements transactional data load from Kafka.
Oracle
Oracle
Two-way data exchange with Oracle Database is available via PXF JDBC connector with support of Oracle-specific features like parallel query execution.
S3
S3
PXF service provides a connector to the S3 object store.
HBase
HBase
PXF HBase connector reads data stored in HBase tables and supports filter push-down.
HDFS
HDFS
PXF is compatible with generic Apache Hadoop distributions including Arenadata Hadoop. PXF is installed with HDFS, Hive, and HBase connectors. You can use these connectors to access varied formats of data from the above Hadoop distributions.
JDBC
JDBC
PXF provides access to this data via PXF JDBC connector. It can read data from and write data to different SQL databases.
Hive
Hive
PXF is compatible with generic Apache Hadoop distributions including Arenadata Hadoop. PXF is installed with HDFS, Hive, and HBase connectors. You use these connectors to access varied formats of data from the above Hadoop distributions.
Operating systems
Alt Linux
Alt Linux 8 SP is supported
CentOS
CentOS 7 is supported
RedHat
RedHat 7 is supported
Astra Linux
Astra Linux SE 1.7 Orel is supported
Ubuntu
Ubuntu 22.04.2 LTS is supported
Core Greenplum functionality
gpbackup/gprestore
PXF
Deploy & upgrade automation
Monitoring & Alerting
Offline installation
WAL Backup management
x86
Technical support 24/7
Corporate training courses
Tailored solutions
Available integrations
ADQM
Arenadata QuickMarts
Available only for Enterprise
ADS
ADS
Available only for Enterprise
ADPG
ADPG
Two-way data exchange with Arenadata Postgres (ADPG) is available via PXF JDBC connector.
Kafka
Kafka
Available only for Enterprise
Oracle
Oracle
Two-way data exchange with Oracle Database is available via PXF JDBC connector with support of Oracle-specific features like parallel query execution.
S3
S3
PXF service provides a connector to the S3 object store.
HBase
HBase
PXF HBase connector reads data stored in HBase tables and supports filter push-down.
HDFS
HDFS
PXF is compatible with generic Apache Hadoop distributions including Arenadata Hadoop. PXF is installed with HDFS, Hive, and HBase connectors. You can use these connectors to access varied formats of data from the above Hadoop distributions.
JDBC
JDBC
PXF provides access to this data via PXF JDBC connector. It can read data from and write data to different SQL databases.
Hive
Hive
PXF is compatible with generic Apache Hadoop distributions including Arenadata Hadoop. PXF is installed with HDFS, Hive, and HBase connectors. You use these connectors to access varied formats of data from the above Hadoop distributions.
Operating systems
Alt Linux
Available only for Enterprise
CentOS
CentOS 7 is supported
RedHat
RedHat 7 is supported
Astra Linux
Available only for Enterprise
Ubuntu
Ubuntu 22.04.2 LTS is supported
Features
Performance
ADB can scale horizontally without degrading query performance on petabytes of data
Safety
Built-in audit of user actions on a cluster: authentication, LDAP configuration, resource group configuration
Reliability
Mirroring, safe backup management, ddboost plugin for gpbackup/gprestore utilities
Convenience
Flexible deployment and configuration, upgrades with tested binaries and migrations for all the components
Contribution
Our team is one of the main Greenplum contributors. In addition, we maintain our own documentation and keep it up-to-date
ADB Control
Arenadata DB query monitoring system
It is designed for in-depth research of command execution processes or utilities that work with ADB clusters.
Monitoring is based on real-time information of the query-level resource consumption and the progress of the query plan execution. Additionally, it is possible to monitor the execution of queries in the context of transactions.
The monitoring system has a convenient user interface with the ability to connect several Arenadata DB clusters to it, collect statistics, view its graphical representation, and export metrics.
Arenadata DB Backup Manager
Service for ADB binary backup management
The main feature is asynchronous launch of binary backups on a running cluster.
There is a user interface built into ADB Control, from which you can work with several ADB clusters and for each of them:
  • configure backup schedules;
  • manage backup configurations;
  • create backups of different types (full, incremental, differential) on-demand;
  • restore cluster databases from existing backups;
  • perform audit of actions related to backups.
Connectors
ADB Spark Connector
Multifunctional connector with support for parallel read/write operations between Apache Spark and Arenadata DB. Based on it, you can easily build ETL solutions and perform in-memory data analysis.
Provides a flexible configuration and many features:
  • high data transmission speed;
  • automatic data schema generation;
  • flexible partitioning;
  • support for push-down operators;
  • support for batch operations.
Read documentation
ADB Kafka Connector
Special connector for Apache Kafka integration with Arenadata DB.
Features:
  • ability to read and write AVRO data from Kafka topics;
  • support for CSV and text formats in data read operations;
  • support for transactions when writing data to Arenadata DB.
Read documentation
ADB PXF Connector
Framework for parallel and high performance access to heterogeneous data sources from Arenadata DB based on built-in connectors.
The data is accessed through the mechanism of external tables, which allows to build complex federal queries.
To connect external data storages, the following connectors are provided: JDBC, S3, Hive, HDFS, and HBase. Authentication may include Kerberos and/or SSL.
ADB ClickHouse Connector
FDW connector for data transmission from Arenadata DB to Arenadata QuickMarts or ClickHouse.
Features:
  • transactionally load data by automatic creation of staging tables;
  • use multiple table engine families in ClickHouse;
  • flexibly distribute and parallelize the write load.
Read documentation
ADB to ADB Connector
Provides two-way interaction between ADB clusters. The connector is implemented on the basis of a foreign data wrapper and parallel retrieve cursors.
ADB to ADB Connector has the following features:
  • segments of a local cluster have the ability to select data directly from segments of a remote cluster in a parallel mode;
  • transactional data insertion from local to remote clusters in the "master-master" mode is available.;
  • ADB to ADB Connector supports the ability to calculate the number of query executors (QE) automatically.
Read documentation

ADB 7 based on Greenplum 7

New Community version

With powerful enhancements and advanced capabilities, ADB 7 opens the door for a new era of Big Data analytics. The product update enhances data reliability, security, and control by giving organizations tools for quick and effective analysis. Companies can enhance their analytical capabilities and accelerate decision-making with the help of ADB 7, which offers new levels of performance and ease of management.

In addition, this version is perfect for those who are looking for a reliable and high-performance open-source solution. Join our community to access new capabilities for effective data management and analysis.

ADB 7 Features
Modern core based on PostgreSQL 12
ADB 7 is based on PostgreSQL 12, which provides improved compatibility and access to the new features provided by this PostgreSQL version.
Significant performance increase
The introduction of JIT compilation, support for new index types, improvements to AO/CO table indexing, addition of optimizer hints and parameterized queries, as well as other improvements in GPORCA provide a significant increase in productivity.
Advanced administration and resource management tools
The updated cluster management capabilities make the administration process more flexible and efficient, allowing you to better manage your resources and provide smooth operation even under high load.
Increased security measures
Access management and data protection tools in ADB 7 have been supplemented by enhanced access control, row-level security, and built-in audit mechanisms, which makes the system more secure.
Enhanced integration
Integration with different systems is improved by additional tools for foreign tables (FDW), resulting in more flexible and efficient interaction with external data sources.
Improved cloud support
ADB 7 offers enhanced cloud support, including optimization for clouds and hybrid infrastructure, which provides greater flexibility and scalability for modern enterprise applications.
Product comparison

Arenadata DB

Compare with

Compare with

Infrastructure
Management system, including easy installation, update, and upgrade
Yes
No
Yes
Yes
Yes
Cluster expansion
Yes
Yes

Only CLI.

Yes
Yes
Yes
Monitoring system
Yes
Yes
Yes
Yes
Yes
Backup/DR system with UI
Yes
No
No
No
Yes
IT landscape support
Ability to deploy various combinations of bare metal, cloud
Yes
Yes
Yes
Yes
Yes
PaaS support for cloud providers
VK Cloud;
Cloud.ru (in development).
AWS;
Azure;
Google Cloud Platform.
AWS;
Azure;
Google Cloud Platform.
AWS;
Azure;
Google Cloud Platform.
Oracle Cloud.
Domestic OS support
Alt Linux
Yes
No
No
No
No
Astra Linux
Yes
No
No
No
No
RED OS
Available soon
No
No
No
No
Ubuntu
Yes
Yes
Yes
Yes
Yes
Features
Physical data backup/recovery
Yes
No
Yes
Yes
Yes
Cluster monitoring
Yes
Yes
Yes
Yes
Yes
Query monitoring
Yes
Yes
Yes
Yes

Possible performance degradation.

Yes
Integrations
Kafka
Yes

ADB Kafka Connector.

Yes
Yes
Yes

Possible performance degradation.

Yes

At extra charge (not available in Russia).

ClickHouse
Yes

ADB ClickHouse Connector.

Yes

PXF only, manual integration.

Yes

JDBC only.

Yes

JDBC only.

Yes

At extra charge, manual integration (not available in Russia).

Hadoop
Yes

ADB PXF Connector.

Yes
Yes
Yes
Yes

At extra charge (not available in Russia).

Spark
Yes

ADB Spark Connector.

Yes
Yes

JDBC only.

Yes
Yes

At extra charge (not available in Russia).

Cluster-to-cluster
Yes

ADB to ADB Connector.

Yes
Yes
Yes
Yes

At extra charge (not available in Russia).

Security settings
SSL between client and server
Yes
Yes
Yes
Yes
Yes
Synchronization with LDAP
Yes
Yes
Yes
Yes
Yes
External secret storage
In development
No
Yes
Yes
Yes
Additionally
Technical support 24x7
Yes
No
Yes

(not available in Russia).

Yes

(not available in Russia).

No
Fastest release of bug fixes, new features, and optimization
Yes
No
No
No
No
Training/workshops
Yes
No
Yes

(not available in Russia).

Yes

(not available in Russia).

No
Community version
Yes
Yes
No
Yes

With limitations.

No
Documentation in Russian
Yes
No
No
No
No
Registration in the register of domestic software
Yes
No
No
No
No
FSTEC certification
Yes
No
No
No
No

ADB Control & Backup Manager

Compare with

Compare with

Infrastructure
Management system
Arenadata Cluster Manager (ADCM)
No
Teradata Vantage
Oracle Enterprise Manager Cloud Control
Centralized upgrade
Yes

Via ADCM.

No
No
Yes
IT landscape support
Ability to deploy various combinations of bare metal, cloud
Yes
Yes
Yes
Yes
Domestic OS support
Alt Linux
Yes
No
No
No
Astra Linux
Yes
No
No
No
Features
Integration with other products
ADB
Tanzu Greenplum
Teradata
Oracle
User interface with role-based access control
Yes
Yes
Yes
Yes
Work with multiple clusters of different types (with/without Standby and mirroring) via UI
Yes
No
Yes
Yes
Ability to load monitoring metrics to an external database via UI
Yes
No
No
No
Monitoring of SQL queries and transactions. Ability to view queries history via UI
Yes
Yes
Yes
Yes
Ability to track plans and execution of SQL queries via UI
Yes
Yes
Yes
Yes
Resource prioritization via UI
Yes
Yes
Yes
No
Launch of binary backups on a running cluster via UI
Yes
No
No
Yes
Backup management via UI: configure, launch on schedule and manually, view, delete, create restore points
Yes
No
No
Yes
Support for S3 and Posix compatible backups
Yes
No
Yes
Yes
Disaster recovery
Yes (asynchronous)
No
On-premises
Yes
Security settings
SSL encryption
Yes
Via ADCM.
Yes
Yes
Yes
Standard access separation based on Role Base Access Control
Yes
Yes
Yes
Yes
Logging of user and system actions
Yes
Yes
Yes
Yes
Additionally
Technical support 24x7
Yes
No
Not available for Russia
Not available for Russia
Training/workshops
Yes

Full training on working with Arenadata products.

No
Not available for Russia
Not available for Russia
Community version
No
No
No
No
Documentation
Yes
Yes
Yes
Yes
Registration in the register of domestic software
Yes
No
No
No
Successful deployments
Yes
Yes
Yes
Yes
Release history with descriptions
Yes

Complete release history with service versions and description of the upgraded functionality is available in the open domain.

Yes
Yes
Yes

“Product comparison” section is relevant on the date of 13.05.2024.

Releases
2023
ADB 7.2.0.1
  • Official support for Ubuntu 22.04 on x86-64 platform has been added
  • Updated JIT support to enhance query performance in GPDB
  • Enhanced stability and speed optimization
Read more
ADB 6.27.1.57
  • The performance and scope of PXF pushdown have been significantly enhanced and extended
  • The restoration process from backup now runs more smoothly
Read more
ADB Control 4.9.1
  • Added integration with HashiCorp Vault
  • Added display of blocked sessions and waiting commands
  • Improved the layout of charts on the Dashboard page
  • Extended filtering and sorting by segment system metrics on the command details page
Read more
ADBM 2.1.2
  • Added integration with HashiCorp Vault
  • Implemented new parameters for S3 in backup configurations
  • Added a history of backup status changes
Read more
ADB 6.27.1.56
  • ADB now supports Ubuntu OS
  • The ADB to Kafka connector now supports SSL
  • Temp table storage is now separated from temp file storage
Read more
ADB Control 4.8.8
  • The planchecker service now has a configuration file
  • Added support for clustered ClickHouse as an external database for ADB Control installation
  • Reworked the Configuration -> Clusters tab
Read more
ADBM 2.0.4
  • Added ADBM CLI to simplify backup and restore processes
  • Enabled the feature of block-level incremental backups: the corresponding flag is added to the backup configuration page
Read more
ADB 6.26.2.55
  • Added the PXF cluster option to reload profiles
  • Added the option to change the PXF_BASE directory
  • Added the parallel_processes option to the Redistribute cluster action
  • Reset ADB on Astra Linux from default Axiom Java to openjdk
  • Replaced Java 8 with Java 11 in all components of Arenadata DB
Read more
ADB Control 4.7.5
  • Query tagging feature was introduced in ADB, tags are now visible in ADB Control
  • Detailed plan progress view was refactored for convenience
  • Added session management of ADB Control users
  • Added GUC setting options
Read more
ADBM 1.7.3
  • Copy Streaming option for Disaster Recovery was added
  • Cleanup logic was updated
  • Fixed Copy restore fails after stopping one of source cluster segments
Read more
ADB 6.26.0.53
  • Added new metrics for PXF Monitoring: pxf status and uptime
  • Added the ability to choose a strategy for vacuuming in arenadata_toolkit
  • Added support for plpython3u
Read more
ADB Control 4.6.4
  • Introduced an option to configure SSL/TLS for interaction of ADB Control/ADBM services
  • Modified TTL (time-to-live) for ClickHouse tables to provide lower disk space consumption
  • Added the Application name parameter for each session on the Monitoring → Sessions tab
  • Implemented dynamic loading of an LDAP group list based on the user input on the Users → LDAP group mapping tab
Read more
ADBM 1.6.3
  • Added new statuses for management of backup configurations
  • Added handling of repository unavailability to the process of backup status determination
  • Implemented changes in the Cleanup action to support modifications of a repository type or path, and to protect backups during Disaster Recovery (DR) copy stream
Read more
ADB 6.25.2.52
  • Added support for Astra Linux 1.7 SE "Orel"
  • Added support for Docker CE
  • Added the option to choose custom JAVA_HOME for cluster
  • Added the Parameter archiving feature
Read more
ADB Control 4.5.3
  • Added the Sessions tab to the Monitoring page with the session termination option
  • Improved a process of filtering in agents for gathering system metrics
  • Added an automated cluster archivation when a new cluster with the same JDBC URL is added
  • Removed the Create connection button from the Configuration → Clusters page
  • Support for SSL/TLS in gRPC services was added
Read more
ADBM 1.5.2
  • Implemented the ability to restore mirrors from binary backups in parallel with primary segments — via the Restore mirrors field.
  • Verifying the repository accessibility was added for a copy stream command flow
  • Added the Warning status for ADBM actions
  • Date filter defaults were changed to the last day on the Backups and Restores pages
  • Added the forced Skip validation flag display to the Restore modal window for restoring data in stopped ADB clusters
Read more
ADB 6.25.1.51
  • Implemented ADB to ADB Connector 1.0.0
  • Added the Uninstall action for Madlib
  • Fixed the error that occurred when the session on the master node was ended, while the sessions on the segments continued to work
Read more
ADB Control 4.4.0
  • The custom timezone setting is now available on the Configuration tab
  • New parameters for the metrics offloading job (Export job) were added
  • Changed the order of side menu items
  • Deleting the last user with the Owner role is now prohibited
  • Fixed the error of filtering by Job group on the Jobs → Audit page
Read more
ADBM 1.4.0
  • CIFS repository support was added
  • Added the option of automated backup copying to a target cluster when a new backup on a source cluster is completed
  • Auto detection of an active master host was added to support a backup process after switching to standby
  • Fixed: Self-restore (via the Restore action) failed after changing roles on mirrors
Read more
ADB 6.25.1.49
  • Added LDAP integration and synchronization with ADB from bundle
  • Added the pgbouncer-adb6 RPM with LDAP native authentication
  • gpbackup: added the --report-dir parameter to gprestore
Read more
ADB Control 4.3.3
  • ADB is now available as a target database for exporting metrics
  • Filters on operations/authorizations audit pages for Object name, Username, Host are now case insensitive and partial
  • Fixed: Password for offload database was shown on Audit Operations page
  • Fixed: Sorting by columns was not available on Jobs page
  • Fixed: After selecting a cluster, agents for other clusters were displayed on Information page
Read more
ADBM 1.3.3
  • Added restore with mirrors option for DR copy process
  • Repository validation step was added before saving backup configuration
  • Backup topology is now sorted by segment_id
  • Fixed: Restores list was empty for clusters with spaces in names
Read more
ADB 6.24.3.48
  • Postgres config files are backed up for the purpose of ADBM Copy (Disaster Recovery)
    • Fixed:
  • Cluster was marked Down in ADBM when master was on the same host as segment
Read more
ADB Control 4.3.2
  • New tables and filters were implemented
    • Fixed:
  • Execution time was not shown in plan nodes after the command finished
  • Error when changing the user role
  • Error when launching the metrics offload job
Read more
ADBM 1.3.2
  • Restore for standby master was implemented
  • Automatic checking of ADB versions compatibility on source and target clusters was added
  • Availability check for a backup configuration on a target cluster was added
    • Fixed:
  • Could not restore a backup on DR cluster with a number of datanodes different from a source cluster
  • Choosing particular databases from the database list caused the Disaster Recovery (DR) copy process to fail
    • Read more
    ADB 6.24.3.47
    • Upgraded gpbackup to 1.28
    • Upgraded pxf to 6.6
    • ADB ClickHouse connector went out of beta to GA
    • Implemented the adb_collect_table_stats function to handle a problem with NULL values in db_files_current
    • Implemented the adb_skew_coefficients view to monitor data skews as opposed to gp_toolkit.gp_skew_idle_fractions
    Read more
    ADB Control 4.3.1
    • Audit for unsuccessful ADB logon attempts and Audit for ADB Control users management actions are available now
    • Added an archiving action for a cluster to stop monitoring of the selected cluster with the ability to activate it again
    • Added filtering of queries shorter than a threshold on the adcc-agent side to improve agents stability
    • SQL signature (sql_id) was added for every command
      • Fixed:
    • Cluster information data didn’t update immediately after switching the cluster on Actions, Backups, Restores tabs
    Read more
    ADBM 1.3.1
    • Implemented Disaster Recovery with Cold Standby — ability to recover a cluster from a backup located on another cluster (Beta-version)
    • Added pgbackrest options (-delta, --force, --max-process) for the restore action
    • Added an option to save a backup configuration without schedule for running backups on request
    • ADBM action tree view was enhanced
    • Fixed: the Apply backup config action failed when S3 was selected
    Read more
    ADB 6.23.5
    • Upgraded diskquota to 2.2.1
    • Limited the find command depth when diskquota upgrading
    • Fixed diskquota 2.x to allow a huge number of rows in diskquota.table_size
    • Fixed: PXF curl error buffer: a transfer closed with external read data remaining
    • Fixed: diskquota hung and blocked the cluster stopping
    Read more
    ADB 5.29.11
    • Upgraded tkh-connector and gptkh to the latest PXF 5 versions
    • Fixed FATAL: could not open relation after the segments switchover
    • Fixed the gptkh extension creation when extension scripts dropped anything
    • Fixed ERROR: gp_relation_node has more entries than pg_aocsseg for relations
    Read more
    ADB 6.23.3
    • Implemented Tkhemali connector 2.0
    • Started to process the IN predicate for filter push-down purposes in PXF JDBC
    • Enabled SSL between Client and Master
    • Added PXF Monitoring Grafana Dashboards
    Read more
    ADB Control 4.2.1
    • Arenadata DB Command Center (ADBCC) is renamed to Arenadata DB Control (ADB Control)
    • Optimized storage space with the ability to export metrics to an external database for a long-term storage
    • Improved security with CSRF (Cross-Site Request Forgery) protection support
    • Improved authentication security with forced password change at first login and user account blocking after several failed authentication attempts
    • Added the ability to view total monitoring metrics as well as current-time recalculations for active commands
    Read more
    ADBM 1.2.1
    • Ability to use ADBM on PowerPC
    • Ability to restore cluster without mirror segments
    • Improved filtering for Restore actions
    Read more
    ADB 6.22.1
    • Synced with upstream Greenplum Database 6.22.1
    • Upgraded pgbouncer to 1.18
    • Upgraded gpbackup to 1.27
    • Upgraded plcontainer to 2.2
    • Implemented a buffer parameter in the gpcheckperf utility
    Read more
    ADBM 1.1.0
    • Ability to restore from backups on a stopped cluster
    • Ability to delete the last backup from the stanza
    • Ability to restore specific databases from backups
    Read more
    ADB Control 4.1.0
    • Added the ability to use ADB Control along with gpperfmon within the same ADB cluster
    • LDAP search in several Organizational Units (OU) during authentication
    • Flexible sorting on query and transaction monitoring pages
    Read more
    ADB 6.22.0
    • Synced with upstream Greenplum Database 6.22.0
    • Added support for Alt Linux 8.4 SP
    • Added Data Domain Boost 1.0.0
    • PXF: allowed setting of Oracle parallel instructions
    • Refactored Planchecker to use an external ADB Control database
    • gpbackup: fixed the metadata order so that now gprestore can restore functions after the tables that are used in functions as a returning type
    • gptkh: fixed fetching of the actual system.tables columns in ClickHouse (according to the ClickHouse version)
    Read more
    ADB Control 3.7.0
    • Added new performance metrics for commands and transactions: Cpu usage total, Read bytes total, Write bytes total
    • Added the ability to repeatedly change a resource group for a transaction
    • Fixed calculating the number of tuples affected by the request
    • Included the Planchecker database objects into migration
    Read more
    ADB 6.21.1
    • Synced with upstream Greenplum Database 6.21.1
    • Enabled core dump files for ADB processes
    • Fixed the problem with loss of resource group slots when moving a query
    • Added a Planchecker image to the ADCC service (docker-compose) in the ADB bundle
    Read more
    ADB Control 3.6.0
    • Added the ability to cancel a transaction
    • Added the ability to reassign queries to another resource group
    • Added the ability to filter commands by a planner
    Read more
    ADB 6.21.0
    • Synced with upstream Greenplum Database 6.21.0
    • Optimized DML queries against partitioned tables to avoid further planning if a partition was pruned
    • Excluded the gpmon background process from the shared memory user list
    • Implemented a fallback to PostgreSQL for an empty target list in CTE producer
    • ADB bundle: added the ability to specify a cluster network
    Read more
    ADB Control 3.5.1
    • A non-blocking socket is now used to communicate with an agent
    • Added monitoring of transactions
    • Added monitoring of SQL statement groups: DDL, DML, DCL, and TCL
    • Added Spill and Spill Skew calculation
    Read more
    ADB 6.20.1
    • Synced with upstream Greenplum Database 6.20.1
    • PXF: added PXF 6.3.0 to the ADB bundle (with ability to upgrade from PXF 5.x)
    • PXF: activated a PXF cluster sync command
    • PXF: added the ability to override data types mapping in external tables for PXF
    • Added ADB ClickHouse connector 1.0.1
    Read more
    ADB Control 3.4.0
    • The actual statistics from EXPLAIN ANALYZE for finished queries is processed now
    • Integrated the average cluster query metrics
    • Implemented compression for huge queries
    Read more
    ADB 6.19.3
    • Synced with upstream Greenplum Database 6.19.3
    • Added ADB Loader tools for RHEL 8
    • Added the ability to deploy maintenance scripts for several databases
    • Enabled the backlog_lock_waits GUC
    Read more
    ADB Control 3.3.1
    • Data audit support
    • Added the Background jobs history page
    • Support for virtual process memory in system metrics of commands
    • Service load ratio support
    Read more
    ADB 6.18.2
    • Synced with upstream Greenplum Database 6.18.2
    • Implemented archive_mode always
    • Added Kafka ADB connector 1.0.4
    Read more
    ADB Control 3.2.5
    • HTTPS support
    • Implemented the backpressure mechanism relative to the memory volume occupied in heap on the agent
    Read more
    ADB 6.18.0
    • Synced with upstream Greenplum Database 6.18.0
    • gpbackup: added an explicit order of tables by using pg_class.relpages
    • PXF: added the partitioning query support for Sybase
    Read more
    ADB Control 3.2.4
    • Multi-clusters
    • New system metrics in the query context: CPU, RAM, IO
    • Actualization for hanging queries
    • Adding columns dynamically to the History and Monitoring pages
    Read more
    ADB 6.17.5
    • Synced with upstream Greenplum Database 6.17.5
    • ADB bundle: added the Ready to upgrade status for a bundle upgrade action
    • Fixed low CPU performance on Power with newly added CGLAGS build options
    • Added a build for Power8 LE platform (ppc64le arch)
    Read more
    ADB Control 3.1.3
    • Added an agent build for Power8 LE platform (ppc64le arch)
    Read more
    ADB 6.17.1
    • Synced with upstream Greenplum Database 6.17.1
    • ADB bundle: external database connection for ADB Control
    • Fixed: PostgreSQL query optimizer built a bad plan for replicated tables with indexes
    • adcc-extension: started to retrieve and send an error text
    Read more
    ADB Control 3.1.0
    • New user interface
    • Ability to cancel and terminate queries
    • Time-based Retention Policy
    • Extended information on errors
    • LDAP authentication
    Read more
    ADB 6.16.2
    • Synced with upstream Greenplum Database 6.16.2
    • Shrinking of relation segment files to zero on TRUNCATE and DELETE
    • PXF: removed the tuple count check for JDBC queries INSERT
    • Kafka ADB Connector: allowed users to set custom librdkafka options
    • Implemented the diskquota extension update
    • Added the gp_enable_gpperfmon=on parameter to Master and Segment servers
    Read more
    ADB Control 2.1.1
    • Added JVM arguments for logging
    ADB 6.15.0
    • Synced with upstream Greenplum Database 6.15.0
    • Implemented switchover from Master to Standby via ADCM
    • Added the $PXF_CONF and the $PXF_HOME environment variables to PXF hosts
    • Kafka ADB connector: implemented signal handlers to interrupt consuming
    • Ported ADB to Alt Linux 8.2
    Read more
    ADB Control 2.0.3
    • Support for horizontal scaling of ADB Control backend
    • Added the UDS unlink processing, updated the library build for CentOS 7
    • Added the innerQueueCapacity parameter that defines the internal message queue size for an agent
    ADB 6.14.1
    • Synced with upstream Greenplum Database 6.14.1
    • Removed online loading of static resources from the ADB Control web interface
    Read more
    ADB 6.14.0
    • Synced with upstream Greenplum Database 6.14.0
    Read more
    ADB 6.13.0
    • Synced with upstream Greenplum Database 6.13.0
    • Supported auxiliary relations for append-optimized tables to be used by the pgstattuple extension to exactly estimate the bloat of those relations
    • ADB ClickHouse connector: avoided the intermediate conversion to a byte array
    • Removed the obsolete batching options in ADQM connector (since the TEXT is used now)
    Read more
    ADB 6.12.1
    • Synced with upstream Greenplum Database 6.12.1
    • Added the offset function to Kafka connector
    • Added the rest committed function to Kafka ADB connector
    • Implemented the text format for Kafka ADB connector
    • Provided the JVM_OPTS setting for PXF
    • Supported AVRO logical types in Kafka ADB connector
    • Started to use rd_kafka_query_watermark_offsets to validate partition-offset pairs in Kafka ADB connector
    Read more