Preliminary communication

Database mirroring in fault-tolerant continuous technological process control

R. Danel ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic
L- Otte ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic
R. Kozel ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic
D. Johanides ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic
Š. Vilamová ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic
K. Janovská ; Business School Ostrava plc., Czech Republic
M. Řepka ; Faculty of Mining and Geology, VŠB–Technical University of Ostrava, Czech Republic

Abstract

This paper describes the implementations of mirroring technology of the selected database systems – Microsoft SQL Server, MySQL and Caché. By simulating critical failures the systems behavior and their resilience against failure were tested. The aim was to determine whether the database mirroring is suitable to use in continuous metallurgical processes for ensuring the fault-tolerant solution at affordable cost. The present day database systems are characterized by high robustness and are resistant to sudden system failure. Database mirroring technologies are reliable and even low-budget projects can be provided with a decent fault-tolerant solution. The database system technologies available for low-budget projects are not suitable for use in real-time systems.

Keywords

Continuous production; control; database mirroring; fault-tolerant system

Hrčak ID:

141842

URI

https://hrcak.srce.hr/141842

Publication date:

1.1.2016.

Visits: 1.639 *