Developers: | SoftPoint |
Last Release Date: | 2015/12/12 |
Technology: | DBMS, Server platforms |
The solution SoftPoint Data Cluster is developed for the 1C: Enterprise platform of version 8.X.
Use of a product increases performance and fault tolerance of the database and a system in general.
Indicators and characteristics
During testing the necessary level of an information flow was provided with 125 competing sessions of users "1C: Enterprise" (about 9 thousand requests/pages, 4 thousand transactions), 250 competing sessions (about 17 thousand requests/pages, 8 thousand transactions) and 250 competing sessions with the raised loading (about 25 thousand requests/pages, 18.7 thousand transactions).
Cumulative performance of an information system at inclusion of additional nodes in a server cluster of databases on Microsoft SQL Server 2012 platform increased. The real gain of performance when adding one or two additional nodes made 90-95% and 180-185% respectively. Uniform distribution of loading between physical servers / nodes of a cluster and linear (in proportion to quantity of the added nodes in a cluster) reduction of runtime of the majority of transactions of testing is mentioned.
For Microsoft SQL
Softpoint Data Cluster expands possibilities of the AlwaysOn technology which is built in Microsoft SQL Server 2012, analyzing requests to DBMS and redirecting them on the least loaded server that allows to balance loading depending on server capacity parameters at the specific moment.
SoftPoint Data Cluster implements:
- uniform loading of the Microsoft SQL 2012 servers for increase in cumulative performance and the maximum use of the available hardware resources;
- integration with the information system "1C: Enterprise" (further will appear support of other systems) without need to change an application code taking into account features of an inner pattern of the databases "1C: Enterprise";
- an opportunity to manage a priority of nodes of a cluster, for example, to separate them into operational and analytical. It allows to reduce load of the main nodes, therefore to increase performance of operational work. Thus, more opportunities for priority control of load of different functional units of a system appear.
2015: Certification on Microsoft SQL Server 2014 platform
On December 24, 2015 it became known of certification of the solution SoftPoint Data Cluster on Microsoft SQL Server 2014 platform. The certificate of Microsoft confirms compliance of the software to international standards and complete implementation of functionality of SQL Server of 2014.
SoftPoint Data Cluster is the solution for optimization of work of information systems on the Microsoft SQL Server platform. This superstructure helps to balance loading in a server cluster of DBMS and, respectively, it is more rational to distribute it in network. Use of Data Cluster does an information system more powerful and horizontally scalable.
Technologies do not work in a separation from practical tasks. We managed "make friends" the new version SQL Server 2014 with its numerous innovations with information systems of the customer. The customer increases efficiency at the expense of opportunities of technologies Softpoint and Microsoft. Pavel Barketov, cofounder and technical director of the company of Softpoint
|