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

On December 11, 2024, Tantor Labs announced the release of an updated minor version of the Tantor 16.6 relational DBMSs.

The development team has added a pg_throttle extension that makes it possible to limit the speed of requests. It allows you to create user profiles for resource management by monitoring the load on the system. This functionality is especially useful in environments with multiple users and applications or analytical systems, where limiting server resource consumption to heavy analytical queries can significantly reduce the negative impact on the system.

Important updates include the pg_trace extension for deep analysis and profiling of SQL queries. This tool is especially relevant for users of the 1C platform. pg_trace enables technicians to quickly identify and solve performance issues by providing a simple and intuitive interface for query analysis.

The Tantor 16.6 DBMS release introduced a pg_archive extension designed to automatically archive historical data from registered tables. This extension transforms batches into more efficient storage methods, optimized to meet reading needs or predominantly readable data. Custom policies allow you to automatically archive out-of-date data based on specified timeslots in the background. Combined with the pg_throttle extension, this provides powerful tools for information life cycle (ILM) management. As of December 2024, the column access method is supported.

The team also introduced a pg_uuidv7 extension in release 16.6 that adds support for the UUIDv7 type. This UUIDv7 format reduces the volume of the transaction log and allows you to schedule data for this field. Unlike UUIDv4, which creates completely random values, UUIDv7 generates time-ordered values. This helps reduce index fragmentation and speed up write and read operations in indexed tables. The Tantor Special Edition 1C optimized the histogram-based selectivity estimation algorithm for requests with multiple join conditions. Also improved is an algorithm for selecting a suitable index that takes into account the selectivity of each index considered by the scheduler. This improvement increases the likelihood of using an index that covers all query conditions, which in turn allows you to speed up query execution and save computing resources.

All this functionality significantly complements the already available set of features presented in the major release of the Tantor 16 DBMS. For example, the Column extension introduced support for transactional execution of UPDATE and DELETE operations, as well as UPSERT and other ON CONFLICT expressions for INSERT operations, including the possibility of parallel queries. In addition, an extension of the transp_anon has been introduced to provide transparent anonymization, allowing for the masking or replacement of sensitive personal and commercially sensitive data in the database. The pipelinedb extension offers aggregation and calculations on real data, which reduces the load on the system due to the efficient processing of information as it is received. A pgl_ddl_deploy extension has also been added that automates and simplifies the process of implementing Data Definition Language (DDL) changes in logical replication or database clustering environments.

We have done a great job and are pleased to present to our customer a large minor update to the Tantor DBMS. It not only contains fixes for critical vulnerabilities and bugs fixed in PostgreSQL 16.6, on the basis of which our DBMS is built, but also a number of additional tools to optimize database performance, simplify the process of configuration, configuration and administration. With each new version, we strive to make our flagship product as convenient as possible for processing large amounts of data, for the most difficult and large-scale tasks, "said Vadim Yatsenko, CEO of Tantor Labs.

Compatibility of the Tantor SE 16.2.1 DBMS with Visiology 3.10

Astra Group and Visiology have completed compatibility tests of the latest version of the BI platform Visiology 3.10 with OCAstra Linux Special Edition 1.8 and DBMS Tantor SE 16.2.1. The reliability and operability of the integrated solution is confirmed by certificates No. 25732/2024 and No. 25733/2024, issued as part of the Ready for Astra IT manufacturers' cooperation program. Astra Group announced this on December 4, 2024. Read more here.

Compatibility with "Garda Masking"

The Garda Masking system is compatible with OCAstra Linux and the Tantor SE DBMS. Astra Group announced this on December 2, 2024. Read more here.

BPMSoft 1.5 Compatibility

Astra Group and BPMSoft on November 8, 2024 announced the certification of the current version of the BPMSoft 1.5 platform as part of the Ready for Astra technology partnership program. Experts tested the compatibility of the solution with two products at once: OCAstra Linux and the Tantor DBMS, and the results of the checks confirmed that the software stack works correctly, it can be used without restrictions. Read more here.

Tantor Basic 15.2.1 compatible with "KOTMI-14" version 2.3

The compatibility ON of KOTMI-14 version 2.3 OS Astra Linux 1.7 DBMS with and Tantor Basic 15.2.1 has been officially confirmed. Customers, businesses ENERGY INDUSTRY , and organizations from many other backgrounds industries can now be assured that a reliable technology stack is available to them to create high-performance, automated dispatch systems that can scale and adapt to their individual needs. This was GC Astra announced on November 1, 2024. More. here

Tantor 5 with Tantor Special Edition 16 base

The company Tantor Labes"" (included in Astra Group"") on October 24, 2024 announced the release of an updated version of the Tantor platform - a product designed for management and administration DBMS based on. PostgreSQL The major release of the Tantor 5.0 platform includes both additional tools useful for developers and database administrators () DB and improvements to previously added features.

Among the key innovations, it should be noted that the database built into the Tantor platform is updated data to Tantor Special Edition 16. Improved security and faster operation of the new database allows the platform to support more observed DBMSs.

The Database Browser tool allows you to work with the data schema of the observed database directly from the Tantor platform interface. It contains an auto-lookup SQL editor and displays detailed information about the structure of databases (tables, views, stored functions, and procedures).

Thanks to the parameter group management module, it became possible to save DBMS configurations for further use on other DBMS instances. This module also supports group modifiers, which are part of the configuration and allow you not to create a new configuration group too often, which saves administrators time.

The Anonymizer tool for data depersonalization and masking (pg_anon) allows you to analyze sensitive data using the user interface, anonymize it and get a dump for transfer to a non-production environment. This is critical for organizations working with sensitive information and looking to prevent it from leaking.

Also, version 5.0 added integration with the designer of analytical solutions "Triaflai 5.0" - the Russian no-code platform for building information and analytical systems that provides data collection, storage, analysis, calculations, visualization and reporting. The consumer will be able to build flexible reports based on the data collected by the platform and use ready-made solutions on this platform. This expands the capabilities of the product and provides customers with additional functionality.

A dark theme has appeared in the interface of the Tantor 5.0 platform, in great demand by developers, as well as people with impaired vision. It improves the user experience by providing an additional level of personalization.

As for improving the existing features of the Tantor platform, it should be noted API methods Datasets and instance filtering. They provide more flexibility with data, allowing developers to effectively interact with large amounts of data and filter them according to specified criteria. The updated table view provides users with the ability to customize tables for themselves, swapping columns in convenient order.

The development of our products does not stop for one day, and we are pleased to present to our current and future customers an updated version of the Tantor platform. Thanks to significant innovations in data visualization, as well as improvements in security, speed and personalization of the interface, users will be able to work more efficiently. The Tantor 5.0 platform offers advanced analytical capabilities and flexibility in tuning, which makes it an indispensable tool for developers and administrators looking to keep up with the times in the field of data management, "said Vadim Yatsenko, CEO of Tantor Labs.

RadioAccess 4 Compatibility

Astra Group and Mirtek have confirmed the compatibility of the Astra Linux operating system and Tantor DBMS with the RadioAccess 4 system . Based on the results of tests conducted within the framework of the Ready for Astra technological partnership program, a certificate was issued officially confirming the performance and correctness of the joint functioning of products as part of a single stack. Astra Group announced this on October 25, 2024. Read more here.

Compatibility with EDMS "Thesis" 5.3.1

EDMS THESIS 5.3.1 is officially certified under the Ready for Astra program. Experts have confirmed that the product works correctly in conjunction with the Tantor SE DBMS, and the complex solution can be used without restrictions. Its high performance, reliability and wide modern functionality allow you to successfully perform many business tasks, for the solution of which it was previously necessary to use foreign software. Astra announced this on October 9, 2024. More here.

Compatibility with ELMA365

DBMS Tantor SE has been officially confirmed to be compatible Low-code with the automation platform. business processes ELMA365 The use of a domestic comprehensive solution will allow many organizations to easily and effectively replace foreign ones for software managing projects, sales and improving customer service. This was Elma announced on October 1, 2024.

With the Low-code platform ELMA365 many organizations automate various workflows. Its integration with a secure DBMS gives corporate customers the opportunity to solve a wide range of problems and at the same time not depend on external circumstances and foreign software developers. The application of this software stack allows you to effectively establish document management, manage projects and sales, client service and other business processes.

The most heavily loaded component of the ELMA365 is the PostgreSQL DBMS, where business processes and platform application elements are stored. The Russian development of Tantor SE fully complies with the required SQL specification, and, in addition, includes a set of tools for database administration, which greatly simplifies the operation of DBMS and ELMA365 in general, "said Alexander Zakhvatkin, Lead DeadOps, ELMA.

Ensuring the compatibility of the Tantor DBMS with the ELMA365 platform was a significant step in the development of our IT ecosystem. Russian enterprises of any scale are actively looking for high-quality domestic solutions to replace foreign products, and as a vendor we are striving to saturate the market with holistic import-substituting technological stacks. The synergy of the Low-code platform ELMA365 and the Tantor DBMS will allow many companies not only to replace foreign corporate software, but also to increase the level of stability, efficiency and independence of their IT infrastructures, - said Vadim Yatsenko, CEO of Tantor Labs (part of Astra Group).

Turbo Platform Compatibility

On September 30, 2024, the Consist of Business Group and Astra Group announced the completion of a set of compatibility checks of the TURBO platform with the database management system (DMS) and OCAstra Linux. Read more here.

Obtaining the certificate of FSTEC of Russia

Tantor DBMS manufactured by Tantor Labs (part of Astra Group) has been certified by the FSTEC of Russia for the 4th class of DBMS protection. Read more here.

Compatibility with ACS "Ambulance"

Specialists of Astra Group and ICL Group conducted joint tests of the operability and correctness of the joint functioning of the Astra Linux special-purpose operating system, Tantor DBMS and the Ambulance ACS software product. Astra Group announced this on September 23, 2024. Read more here.

Compatibility with Cascade Zyfra Software

On September 13, 2024, Tantor Labs announced the achieved compatibility of CASCADE Zyfra software with Tantor database management system (DMS). Read more here.

Syntellect Tessa Compatibility

Tantor Labes"" (included in Astra Group"") SYNTELLECT and completed the test cycle, during which EDMS the compatibility/ECM platform TESSA DBMS with Tantor was confirmed. Based on the test results, the companies signed a certificate of compatibility. Astra Group announced this on September 3, 2024. More. here

Tantor 4.2 compatibility with Astra Linux 1.8

Tantor LabesAstra Group On September 2, 2024, the company "" (included in "") announced the release of an updated version of the Tantor modular platform designed for administering and monitoring clusters DBMS based on. PostgreSQL

Version 4.2 of the Tantor platform implements its compatibility with the latest version of Astra Linux 1.8, released in early August 2024. Thanks to this, users of the new (eighth) generation OS can effectively manage a protected DBMS, including that meets the requirements of the FSTEC of Russia.

Other features include adding profiles and external LDAP authentication. Adding and authorizing users from ALD Pro and FreeIPA directories, as well as supporting older AD directories, are now unified as an LDAP profile. The minimum possible length of the user name has also been reduced: if earlier it was five characters, now it is only two.

Agent management on the Tantor platform has become more convenient - in the Agents tab on the Overview page of the workspace, you can delete agents through the user interface. In the search bar for finding agents, a hint was added to enter the necessary parameters.

The Swagger UI API documentation visualization tool that appeared in the previous release added more detailed descriptions of API methods and fixed an error related to setting incorrect default values. This makes the procedure for integrating the Tantor platform with other systems more accessible.

Also in the Tantor 4.2 version, many operations related to managing licenses, passwords and user accounts were finalized.

The roadmap for the development of the Tantor platform is formed, on the one hand, from an assessment of the requirements of our customers to improve the existing functionality and the emergence of a new one. On the other hand, we closely monitor the market and respond to current changes regarding the integration capabilities of the platform. In this case, the Tantor platform is also fully available to all users who have already switched to Astra Linux 1.8, "said Vadim Yatsenko, CEO of Tantor Labs.

Compatibility with "Forsyth. Analytical Platform "

Russian BI-vendor Forsythe"" and, "Astra Group" developer of the system and, infrastructure software on August 15, 2024, announced the completion of a set of compatibility checks of their solutions - the current version "Forsyth. Analytical Platform " DBMS with Tantor and. All OS Astra Linux these products are included in, register of domestic software provide a high level of protection, and are universal solutions that can be used by customers from any industry. More. here

Compatibility with "Sakura" software complex

The companies IT EXAMINATION"" and Tantor Labes"" on July 17, 2024 announced the expansion of their cooperation. As part of this partnership, technicians from both companies completed the comprehensive testing DBMS Tantor and. of "SAKURA" software system More. here

The ability to isolate groups of workspaces

The Tantor 4.1 platform supports multi-tenancy. Tantor Labs announced this on July 4, 2024.

Now the platform supports the isolation of groups of workspaces using tenants - logical objects provided to clients, which include computing resources, repositories and users. In a multi-tenant architecture, each tenant has its own data and settings, but they all use the same infrastructure and software. This allows you to efficiently manage resources, simplify system maintenance, and ultimately reduce maintenance costs.

The page with tenants became the first screen that users see after authorization. It displays the names of all available tenants, the number of workspaces, clusters, and instances in each of them, the total number of alerts, and the number of tasks that failed.

From the Tantor platform menu, you can create new tenants and view detailed information about them, including lists of groups and users, and the Instance tab appears on the workspaces page with a list of all instances related to the spaces of the selected tenant and the ability to search by FDQN, labels and ID.

Support for working with tenants increases the level of data security: each space is isolated from others and protected from unauthorized access. DBAs can fine-tune access rights for users and groups within each tenant, providing more effective control and easier monitoring of the DBA. Multi-tenant architecture makes it easy to scale the system by adding new workspaces and clusters without affecting existing ones.

In Tantor 4.1, the developers added API methods related to working with metrics, tenants, agents and users. To go to the Swagger interface and use them, there is now a Swagger API option. The efficient application of the API allows you to automate processes and integrate the Tantor platform with other systems.

The added functionality of our product can significantly expand the audience and capabilities of customers. Multi-tenancy is especially in demand by cloud providers, SaaS SaaS services developers, large enterprises and holdings with a geographically distributed infrastructure. They can use multi-tenant DBMSs for centralized data management. Updated API methods will open up new horizons for our customers to increase performance and optimize integration. We strive first of all to offer users such solutions that will allow them to always be one step ahead of competitors, "said Vadim Yatsenko, CEO of Tantor Labs.

Basic edition compatibility with Docsvision platform

Tantor Labs (part of the Astra Group) and Docsvision completed a series of compatibility tests for the Docsvision Linux Edition platform and the Tantor DBMS in the Basic edition. Astra Group announced this on June 28, 2024. More here.

Compatibility with "Galaktika ERP"

The compatibility of the Tantor DBMS with the Galaktika ERP system has been confirmed. The Galaxy Corporation announced this on June 3, 2024. Read more here.

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