Tantor DBMS

Main article: Database Management System (DMS)

Tantor PostgreSQL DBMS Russian is a production-based, high-performance, integrated administration and monitoring system. The product is included Register of Ministry of Digital Development of Russia in and suitable for use IT infrastructures in. OS Astra Linux

2024

"Tantor 4.0" with automated database operations

On May 17, 2024, Tantor Labs (part of the Astra Group) announced the release of an updated version of its flagship product designed to manage and monitor databases based on PostgreSQL - the Tantor 4.0 platform.

This is a "major" release in which developers offer users a number of functions. First of all, database operations are automated, which administrators have to perform regularly. Added Scheduler UI scheduler, which allows you to run deferred and scheduled operations on database instances. By "task" is meant a chain of actions that change depending on the behavior of the system. In this version, two types of such sequences are supported:

• Running programs;
• Execute SQL commands.

On the Tasks page of the Tantor 4.0 platform, you can set the start time for each task and configure its frequency, if necessary. In addition to running on a schedule, they can be turned on, off, and started and interrupted immediately. For each of them, the scheduler displays the current status.

The Tantor 3.0 version of the platform, which was released in 2023, has support for Patroni clusters, which provide automatic redistribution and load balancing between nodes, which contributes to fault-tolerant database operation. To the Patroni monitoring tools in the new version of the Tantor platform, a graph was added showing the history of changes in the roles of cluster instances, as well as a table showing the changing statuses of cluster instances. Regular tracking helps identify and analyze emerging problems. For example, frequent role switching may indicate performance or network stability problems. This analysis can help identify performance bottlenecks and optimize cluster configuration.

The updated version made a number of changes to the tool interface for configuration, maintenance, group management, and user management. They are aimed at optimizing, improving efficiency and improving the ergonomics of the Tantor 4.0 platform. A detailed list of innovations can be found here.

With each update, we try not only to improve the performance of existing functions, but also to provide our users with new tools for effective database management and monitoring. The Tantor 4.0 platform is the result of a desire for innovation and constant dialogue with our customers. We are confident that the added capabilities of task planning, monitoring and management of Patroni clusters, as well as interface updates will make working with databases even more comfortable and productive, "said Vadim Yatsenko, CEO of Tantor Labs.

FinAxio Compatibility

Tantor Labes"" (included in Astra Group"") and JSC Digital expertise"" officially confirmed the compatibility software of the "Treasury Management System" of the class (TMS Treasury Management System) FinAxio DBMS and Tantor, having successfully conducted a series of tests. Astra Group announced this on April 24, 2024. More. here

Directum Product Compatibility

Tantor Labes"" (included in Astra Group"") Directum and completed a series of Tantor compatibility checks DBMS in the Basic and Special Edition editions with the Directum product line. The developers guarantee that together with the Russian DBMS, it is possible ECMBPM to use/-system, Directum RX a product for intelligent processing of text information, Directum Ario One a system for managing personnel processes and documents and for Directum HR Pro ON managing projects and teams without restrictions. Directum Directum Projects announced this on April 19, 2024.

The specialists conducted tests that affected all the functionality of the systems, and were convinced of their correct operation in the bundle. The compatibility of Directum products with the domestic database Tantor will expand the capabilities of Russian business in creating an import-independent corporate infrastructure.

The key to the success of any company is people. To ensure efficient and efficient work with personnel, organizations have long used various specialized IT solutions, and when their vendors leave the market, it is important for us to provide our customers with products with similar functionality and quality. Such systems are used not separately, but always in conjunction with DBMS and other software, so it is very important to make them all compatible. We think that confirming the correct operation of a whole line of software from Directum in a single loop with Tantor will be good news for many customers, and thank our colleagues for their cooperation. In the future, our teams will continue to actively interact so that the most reliable and up-to-date technologies are always available on the Russian market, said Vadim Yatsenko, CEO of Tantor Labs.

{{quote 'author = Dmitry Petrov, Head of Technology Partners at Directum.|Understanding the business's need for the reliability of the IT landscape built on the basis of domestic software, we create our products in conjunction with other Russian software, developing their interaction. The compatibility of Directum products with the Tantor DBMS will allow even more Russian companies to build effective work on high-quality import-independent software, }}

Compatibility of Tantor v15.2.3 with CK-11 v. 11.7.1.5

and "Astra Group" JSC Monitor Electric completed a series of release certification activities software CK-11 (v. 11.7.1.5) under the Ready for Astra program. During the examination, it was confirmed that the CK-11 is fully compatible with the domestic DBMS Tantor version 15.2.3. Now energy companies can use this software package to effectively build automated systems of situational and operational-technological control in full compliance with the requirements for Governments of the Russian Federation issues. import substitution This was "Astra Group" announced on April 12, 2024. More. here

Compatibility of the Tantor SE 15 DBMS with the Navigator platform

DBMS Tantor SE 15 (product "Tantor LabsTantor Labs (Tantor Labs)," included in) "The Astra Group" and platform "" business analysts (Navigator product) Sberbank passed the compatibility test as part of the Ready for Astra program. Astra Group of Companies announced this on March 15, 2024. More. here

Tantor 3.3 with localization in Russian

Tantor Labs (part of the Astra Group) announces the release of an updated version of the Tantor platform, a tool for managing PostgreSQL-based databases. This was announced to the Astra Group on January 17, 2024. One of the main changes was localization in Russian. Previously, platform users could only work in the English-language interface, now they can choose Russian in the settings. Thus, the developers of Tantor 3.3 made the solution even more friendly and accessible to Russian customers.

Platform agents have the ability to support two or more instances DBMS on one, server including those launched in -. Dockercontainers A special window displays the number of instances managed by one agent. This allows the administrator to optimize work with several instances of databases at once. data When you reinstall an instance with the same - IP address or port, the modal window displays an information error message, improving understanding of the situation.

The HOST FQDN column has been added to the interface, displaying the full domain name on servers which the instance runs. This feature improves the transparency and control of the network infrastructure, providing a key information for various administrative and technical tasks.

By integrating with the Ansible open source application and Playbook technology, this version of the platform allows you to massively install and configure agents via the command line interface (CLI), without the need for a graphical platform interface.

On the Cluster Config page, tooltips describing the parameters are now available, with them the configuration of the Patroni cluster has become intuitive.

Optimized platform performance for use cases with more than 1,100 observed instances. If there are many clusters with the same instances, the system will independently detect that each instance belongs to the correct cluster. This innovation makes Tantor 3.3 an ideal choice for large-scale deployments.

We are actively working to make our product even more accessible and friendly for domestic customers, so we carefully listen to feedback. Many improvements to Tantor 3.3 were made precisely based on the wishes and comments of users. The interface in Russian, expanded support for multi-stations, improvements in agent performance, optimization of platform performance - all this will allow companies with an extensive database infrastructure to optimize their support, significantly reduce deployment and administration costs, - said Vadim Yatsenko, CEO of Tantor Labs.

2023

XSQUARE-LCDP support

XSQUARE-LCDP runs in a Tantor environment. Astra Group announced this on December 4, 2023. Read more here.

Tantor 3.1 with interface localization

On September 27, 2023, Tantor Labs (part of Astra Group of Companies) announced release of an updated version of the modular administration and monitoring platform DBMS based on PostgreSQL Tantor 3.1.

This is a minor release released a month after the global update of Tantor 3.0, the key change of which was the support of Patroni clusters, which allows you to provide high availability and automatic management of PostgreSQL databases. In this the developers simplified the process of installing the agent for the Patroni instance, and also added to the Switchover Master Server Switch Button Menu, Responsible for Role Switching "Wizard" from one cluster node to another. If there is a synchronous database replica, the operation Switchover can only be executed with it, otherwise the data can be transferred to any available replica.

The PAUSE/MAINTENANCE button appears in the cluster menu. With its help you can put cluster to pause for maintenance. This must be done regularly to optimize it performance, increased availability, reduced downtime, and reduced cost of maintenance. By pressing the same button again, the pause mode is disabled and the cluster again starts up.

Tantor 3.1 also implements Microsoft Active Directory integration. You can now create user groups through this directory service and use its external menu for authentication.

In addition, in Tantor 3.1, the developers took a serious step towards localizing the interface, adding the i18n transloco library. This is a set of convenient tools for choosing a language applications and other settings related to their localization.

A little more than a month after the release of the major release of the Tantor platform, we are pleased to present to our customers and partners an update in which we have implemented a number of new features and improved the existing functionality. I am confident that the work of the database running Tantor 3.1 will become more productive and reliable, and the emerging tools for localizing the interface and integration with Microsoft Active Directory will arouse interest and attract new users, "said Vadim Yatsenko, CEO of Tantor Labs.

Roomy bots compatibility

Tantor Labs (part of Astra Group of Companies) and Rumi LLC, a developer of a platform for intelligent search and automation of processes, began cooperation within the framework of the Ready for Astra IT manufacturers' technological cooperation program. The parties agreed to actively cooperate in terms of checking and ensuring the operability of their decisions. Astra Group of Companies announced this on August 10, 2023.

The comprehensive work of the two companies has already begun. So, in June 2023 testings , Tantor compatibility DBMS and RPA solutions were carried out ROOMY bots to automate repetitive algorithmic processes using software robots. The tests were passed successfully, which is confirmed by the issued certificate certifying the correctness of the specified solutions.

The presence of such a technological partner as the developer of IT solutions of Rumi LLC will allow our clients to use all the advantages of robotization of both simple and complex projects. Enterprise companies have already tried the capabilities and effectiveness of RPA platforms, and the departure of foreign vendors such as UiPath and Blue Prism has given an additional powerful impetus for the development of domestic solutions, "said Vadim Yatsenko, CEO of Tantor Labs. - Our cooperation will allow Russian companies to simplify and automate business processes, which will ultimately have a positive impact on the user experience of end customers.

As of August 2023, Russian business is extremely interested in solutions developed by Russian suppliers. For Rumi LLC, a partnership with Tantor Labs will provide our customers with access to a fully functional ecosystem that will seamlessly and quickly close the issues of both business applications and databases at the same time. This approach guarantees the high efficiency of such projects and shortens the time for their launch into productive operation, "said Svetlana Arkhipkina, General Director of Rumi LLC. - Our collaboration is aimed at improving the quality and efficiency of robotization projects through the use of the high-performance Tantor DBMS.

Tantor 3.0 with Patroni Cluster Lifecycle Management via GUI

On August 3, 2023, Tantor Labes"" announced the release of an updated version of the modular administration and monitoring platform DBMS based on Postrge SQL Tantor 3.0.

Key updates include support for integration and management of Patroni clusters. The Patroni software tool is used to ensure high availability databases and fault tolerance of PostgreSQL by automatically switching to redundant nodes in the event of a failure or failure of the main node. This allows for high availability and automatic management data of PostgreSQL databases. And this is an indispensable tool for enterprises that need to ensure the smooth operation of their applications and services - it makes it possible to maintain the integrity of data and avoid loss. information

Integration with the Patroni application is implemented using the PatroniAPI interface - the implementation and management of clusters has become much easier for users of the Tantor 3.0 platform. The following features are available in the updated version:

• Patroni Cluster Lifecycle Management via GUI
• a ready-made set of metrics, graphs, and triggers for monitoring cluster status;
• receiving notifications about occurrence of abnormal situations in the operation of the instance servers databases (), notifications come in case of availability of the cluster instance, replication lag and in case of other incidents.

Tantor 3.0 platforms have added the CLUSTERS tab in the Overview menu, which displays all clusters in the workspace and demonstrates the service information and configuration of the cluster (the total amount of logical CPU cores and RAM, the size of the occupied/shared disk space, the number of instances directly in the cluster itself).

It is also worth noting that the release implements a menu for working with clusters, which allows you to view detailed information about the work of each instance that is part of the cluster. It can be initialized, started and stopped. Platform users also have access to monitoring the operation of the cluster as a whole and the instances that make up it.

In working on our solution, we always focus on current market demands and feedback from customer companies. It is these two points that help us develop the product, increase its functionality. In particular, support for integration and management of Patroni clusters has appeared in the release of the Tantor 3.0 platform, - said Vadim Yatsenko, CEO of Tantor Labs. - The roadmap for the development of the Tantor platform is designed in such a way as to expand the ability of our products to work in the software ecosystem of Russian developers with each update and implement improvements that increase the quality and convenience of existing functionality.

Tantor 2.1 with the ability to update using the installer

On July 4, 2023, Tantor Labes"" announced the release of a modular administration and monitoring platform databases based on PostgreSQL Tantor 2.1. This version has added a number of features, as well as improved the operation of existing tools.

Developers have optimized mechanisms for controlling access to workspaces. With the updated flexible access differentiation system, Tantor administrators can now create groups to which you can add workspaces and users with shared access rights. Administrators can assign specific permissions to each user group to read and edit workspaces.

Now the Tantor platform using the installer from the official distribution can not only be installed, but also updated. Setup updates the version while maintaining all previously made user settings, and also prompts you to add additional modules if they have not already been activated.

To simplify and speed up the diagnostic process, users have become available to create a utility that collects information that helps them quickly find problems and errors.

In version 2.1, the functionality of the Advanced Analytics module has been improved. Now it is launched in a common operating interface, and not in a separate window. The mechanisms of work on IP have also been improved, recommendations for configuring logging parameters have been added. In addition, among the changes, it should be noted the optimization of the function regarding the configuration and editing of the account, and the configuration of the platform itself.

Most recently, a major version of the Tantor 2.0 platform was introduced, and we are cementing our success with the release of release 2.1. As always, we work closely with our partners and customers, analyze any offers and feedback. The updated version not only fixed bugs and optimized the work of existing tools and modules, but also added features that make the work of users and administrators easier, more convenient and safer, "said Vadim Yatsenko, General Director of Tantor Labs. - Our team has carried out serious work to eliminate vulnerabilities and increase the level of information security, fixed shortcomings found during authorization and in various product modules.

Compatibility of the Tantor SE v15.1 DBMS with the Ma-3 platform

National Platform and Tantor Labs conducted test tests of the joint operation of the Ma-3 ERP platform and the Tantor SE DBMS. This was announced on July 3, 2023 by Astra Group of Companies. Read more here.

Tantor Special Edition 15

Tantor Labs has released an updated version of the Tantor Special Edition 15 DBMS. This was announced on June 21, 2023 by the Astra Group of Companies.

The changes implemented in Tantor Special Edition 15 are aimed at improving performance, DB simplifying migration from DBMS Oracle and, MS SQL optimizing, data storage improving backup data the incremental and improving the convenience of the product for users.

The DBMS is based on an updated and improved version of PostgreSQL 15. The Tantor SE release includes additional functionality, as well as a full set of features added to the previously released Tantor Special Edition 14. The updated version of the DBMS supports all certified Russian operating systems, as well as most of the most popular platforms based on Open source code.

Key changes include support for a 64-bit transaction counter in the database to provide greater capacity and performance. This is especially important for large organizations with a high database load. The updated counter provides a more reliable and secure database operation, as it avoids problems with exceeding the transaction limit and data loss.

In this release, by adding the origin parameter to the CREATE SUBSCRIPTION command, it became possible to create bidirectional logical replication, which allows you to transfer changes from one database to another and vice versa, which ensures data synchronization in real time. Data can be synchronized between multiple databases on different physical servers. Thus, it is possible to achieve increased fault tolerance of the system and continuity of business processes in the event of a failure of one of the servers. In addition, load sharing between multiple servers improves database performance in general.

The Tantor SE 15 version provides support for compression in the libpq library. Its configuration now has the libpq_compression parameter, lz4 and zlib compression algorithms are supported. This significantly speeds up data transfer and application operation, reduces network load and memory consumption on the server, and saves disk space.

The improvements also affected the Tantor database engine: the SIMD (Single Instruction, Multiple Data) method has been introduced, which allows you to increase product performance. More efficient use of processor resources is especially noticeable when processing large amounts of data or complex data, such as texts and JSON. SIMD support speeds up queries that use mathematical operations by several orders of magnitude. Linear search is also optimized, SSE2 support is provided (SIMD for Intel and AMD x86 processors) and SIMD NEON (SIMD for ARM processors).

Among the changes, it is worth noting the ability to reserve connections for non-superuser users. This is done using the new reserved_connections configuration option available in the postgresql.conf file. Another change is the transaction_timeout parameter, which allows you to cancel any transaction if it lasts longer than a specified time interval, and applies to both explicit and implicit transactions.

In the updated version of the Tantor DBMS, support for offline transactions has appeared in PL/pgSQ: an extension of the PL/pgSQL language for offline transactions has been added, which makes it possible to independently capture or cancel a child transaction without affecting what is happening with the current one (for example, for maintaining an audit log). The extension implements offline transactions through a background process mechanism. In future releases, the developers plan to provide support for PL/Python and SQL extensions.

We did a lot of work in terms of optimizing the kernel for high loads: we added a 64-bit transaction counter and a set of important extensions, - said Vadim Yatsenko, CEO of Tantor Labs. - Our team is very responsible for all stages of product development and, already in beta testing, identifies errors and errors in order to provide our customers with a high-performance, reliable and convenient tool for working with data.

Tantor 2.0 with Advanced Analytics

On June 6, 2023, Tantor Labs introduced an updated version of the full-featured Tantor database monitoring and administration platform. Key changes included the Advanced Analytics module for advanced analysis of database events, 6 parameters for configuring monitoring conditions, as well as a trial license for the product as part of the distribution kit.

In this version, the Advanced Analytics module has been added, designed for advanced analysis of database events. It collects database logs according to pre-configured parameters and provides opportunities for searching and filtering archive and problem requests, including those with an incoming or outgoing traffic volume exceeding 1MB, errors, system actions and logs (requests within one PID, one host or a combination of both). Advanced Analytics can also offer recommendations for improving the data schema, adding indexes, and optimizing queries.

Changes and monitoring graphics were also affected: six parameters were added at once on the Charts tab of the web interface of the Tantor platform: Checksum failures and conflicts, Log files count, Total time avg, Replication lag, Processes and WAL files.

Another important change is that now, when installed from the official distribution, the platform includes a pre-installed trial license for 30 days, designed to use 128 CPU cores. You can now familiarize yourself with the licensing policy of the DBMS and Tantor platform directly in the product interface.

Also in release 2.0, work was optimized and a number of errors were fixed related to calculating the WAL size limits, issuing recommendations when working with the pg-explain tool, validation when changing settings in the instance configuration, servers PostgreSQL saving records in the request profiler archive, issuing rights to manage workspaces and updating the token for integration with Telegram.

{{quote 'We are pleased to present a comprehensive database management solution for government and commercial organizations. Release 2.0 is the result of the joint painstaking work of our developers with feedback from partners and customers. It is important for us to work to improve the product in the field of incident investigation, optimization of requests and the user interface in order to offer customers the best solution in the market, "said Vadim Yatsenko, CEO of Tantor Labs. - This version of the Tantor 2.0 platform includes a number of functional changes: from a new module for advanced analysis of DBMS events to an updated monitoring schedule. }}

Tantor 1.13

On April 6, 2023, Tantor Labs introduced the updated Tantor 1.13 database monitoring and administration platform.

This release implements support for the 1C load profile and configuration parameters for PostgreSQL 15, added a mechanism for automatic database recognition under the control of 1C. It is also now possible to install the latest version of the agent from the repository and a number of other improvements have been made that have increased the level of performance and convenience of the product.

The Tantor platform front has been moved to angular v15. This release is notable for optimizing the dialog box: the login page displays the platform version number and a pop-up notification area with detailed release information appears. The changes also affected the graphical user interface, which takes into account the wishes of customers to work on low-resolution screens.

In addition, the developer added the ability to process large plans in a query profile, which allows them to conduct a deeper analysis and optimize them if necessary. Other innovations include improved logging of the closure of websocket'a to improve the quality of agent and platform error handling, as well as improvements in the delay in the transfer of metrics to the platform.

The following functional changes were also made to the product:

• Improved performance when delivering metrics to Dashboard
• Resolved failure to display replication on Dashboard
• The values in the Maintenance history in the VALUES AFTER/ERROR column are now displayed correctly.
• Fixed the recommendations in the pg_explain module
• added a reset of tooltips when changing the monitoring period and transitions between tabs in the query profile;
• the installation of the platform and agent on Astra Linux 1.7.2 has been improved.

The established short release cycle allows us to effectively work on improving the functionality of the Tantor platform: quickly identify user needs and work out hypotheses in search of new solutions. This definitely positively affects the quality of the product. Release 1.13 includes a number of changes, in particular, support for configuration parameters for PostgreSQL v15 and the ability to apply licenses with the same or less date have been added. These updates are based on customer feedback. Each of them is important for us, we are primarily focused on solving specific problems, "said Vadim Yatsenko, General Director of Tantor Labs.

Tantor 1.12

On March 1, 2023, Tantor Labs announced the release of the next release of the Tantor database monitoring and administration platform version 1.12. One of the query plan analyzers based on the explain.tensor.ru service has been integrated into the product, with two options for displaying information.

Tantor 1.12

According to the company, the system can show any user plans of PostgreSQL queries copied from different sources, and those collected using the extension built into it. This integration allows you to analyze directly within Tantor, you no longer need to send requests and data to external services. Moreover, the platform collects and stores requests according to the established configuration, which facilitates their search by date, number of lines and other parameters.

Tantor 1.12

As for the explain.tensor.ru service, it retained all its functionality:

• Visibility of plans. In text form, it is not always convenient to analyze plans, especially when it comes to large complex queries (for example, queries for analytics, 1C, etc.):
• Piechart distribution of time by nodes.
• Tilemap time distribution by nodes.
• For the most complex choices, you can use a query execution diagram.
• Recommendations for optimizing the query plan.
• Statistics on the query plan.

These capabilities allow you to perform in-depth analysis of query plans and optimize them if necessary.

Other changes included optimized work of the Wraparound widget in the  Dashboard module, and also optimizing the display of the data available in this widget for a DBMS with a 64-bit transaction counter. A search appeared in the confirmation window for configuration changes, and if many parameters have changed, you can quickly find the desired one. The installation of the agent was optimized: now, when installing it on a machine with a database, you need to enter less information.

Tantor's fully functional modular platform is designed to administer and monitor enterprise databases based on. PostgreSQL The solution has a single user-friendly graphical interface and allows you to connect databases from third-party manufacturers. The product is included in "" and Unified Register of Russian Programs for Electronic Computers and Databases is suitable for, import-substituted IT infrastructures including on-base. OS Astra Linux

Platform users are public and private organizations that migrate or plan to switch to Postgres from Oracle, seek to optimize costs by automating routine activities, are going to create many clusters and use high-load servers. Tantor has implemented a number of changes for greater performance under increased loads, has functionality for fast seamless migration, operation in failover cluster mode, as well as centralized management and monitoring.

In release 1.12, we optimized the request for data collection about the work of autovacuum and the work of the agent when connecting over IP, optimized the speed of the user interface. In addition, the calculation of CPU utilization metrics and auto-filling of search fields on all screens when using browser extensions were adjusted, and the error of sending messages to e-mail when adding a user was also fixed. The Viewer role now allows you to view information about agents, and a user with Admin rights has the Acknowledge button in the Alerts section. commented Vadim Yatsenko, CEO of Tantor Labs

Compatibility of the Tantor SE version 14.4 DBMS running Astra Linux Special Edition with the Garda DB solution

On February 22, 2023 GC "Astra" , it was reported that as a result of a series of test tests under the Ready IT for manufacturing technology cooperation program Astra Linux , it was confirmed that the agent "" Gardaí DB correctly works with SE Database management system (DMS) Tantor version 14.4 under control OS Astra Linux Special Edition and can perform all declared functions. The corresponding one was received. certificate More. here

DBMS features

The Tantor platform is Tantor Labs' own development, allowing it to administer and monitor any PostgreSQL-based enterprise databases.

As advantages of Tantor, the developer highlights improvements in the kernel for greater database performance under increased loads, functionality for fast seamless migration, capabilities for working in failover cluster mode, centralized management and monitoring without a command line.

Automating routine operations reduces operating costs. And the graphical interface provides ease of use and administration. In addition, there is an integration of corporate databases and directory services for authentication and management of groups and users, the ability to upload metrics using the API, as well as integration with Astra Linux to protect against unauthorized access.

(data current as of February 2023)