Comparison of Database Mirror Technologies for Use in Fault-tolerant Information System Solutions

Technological processes in the raw material industry often operate continuously and requirements for high robustness and fail safe operation of the information and control systems are defined for them to fall into the fault-tolerant category. A critical element of fault-tolerant solutions ensures the continuity of data in databases. Data on the course of technological processes assume the nature he of a time series, and in the event of failure, can be attributed to a lack of data distortion in the calculation of trends, trailing averages and calculation balance evaluation. We tested the database mirroring technology in most common database systems (Microsoft SQL Server, MySQL and InterSystems Cache) in the low-price Standard category. The paper elaborates on the results of our testing and provides recommendations as to the use of database mirroring technology in information system solutions for continuous production processes.