DBPapers
DOI: 10.5593/SGEM2014/B21/S7.010

COMPARISON OF DATABASE MIRRORS TECHNOLOGY OF THE SELECTED DATABASE SYSTEMS FOR USE IN FAULT-TOLERANT INFORMATION SYSTEMS SOLUTIONS

L. Otte, R. Danel, V. Vancura, M. Repka, M. Rolcikova
Wednesday 1 October 2014 by Libadmin2014

References: 14th International Multidisciplinary Scientific GeoConference SGEM 2014, www.sgem.org, SGEM2014 Conference Proceedings, ISBN 978-619-7105-10-0 / ISSN 1314-2704, June 19-25, 2014, Book 2, Vol. 1, 73-80 pp

ABSTRACT
The technological process control in the raw-material industry, which often operates in continuous mode 7x24, requires high robustness and safe operation. It was created a category of systems so-called fault- tolerant. The solution of system to be a faulttolerant is in duplication of the entire system. In case of failure of any component of the production system the backup system takes control and ensures the continuous operation of the information (or control) system. A critical component of such solutions is to ensure the continuity of data in databases. Data taken from technological processes have the character of the time series and in case of failure missing data substantially disrupts the evaluation of balance of production. The solution to this problem is to use a database mirror technology for continuous on- line data mirroring between two instances of the database server. In the past we have used technology of Microsoft SQL Server mirroring solution with fault tolerant system for Darkov Coal Mine coal preparation plant. This year we have started research the possibility of using database technology mirror the world’s leading manufacturers of database systems - Oracle, Microsoft SQL Server, MySQL and Caché - to simulate critical failures and determine behavior and immunity of systems against failure. Based on the tests we have an aim to propose the best solutions and best practices for deployment in fault-tolerant information systems for production control.

Keywords: database mirror, fault-tolerant system, MES, Microsoft SQL Server, Oracle.

Home | Contact | Site Map | Site statistics | Visitors : 216 / 353063

Follow site activity en  Follow site activity INFORMATICS  Follow site activity Papers SGEM2014   ?

CrossRef Member    Indexed in ISI Web Of Knowledge   Indexed in ISI Web Of Knowledge
   

© Copyright 2001 International Multidisciplinary Scientific GeoConference & EXPO SGEM. All Rights Reserved.

Creative Commons License