Database mirroring in fault-tolerant continuous technological process control

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...

Full description

Bibliographic Details
Main Authors: R. Danel, L. Otte, R. Kozel, D. Johanides, Š. Vilamová, K. Janovská, M. Řepka
Format: Article
Language:English
Published: Croatian Metallurgical Society 2015-10-01
Series:Metalurgija
Subjects:
Online Access:http://hrcak.srce.hr/file/209299
_version_ 1818759190567452672
author R. Danel
L. Otte
R. Kozel
D. Johanides
Š. Vilamová
K. Janovská
M. Řepka
author_facet R. Danel
L. Otte
R. Kozel
D. Johanides
Š. Vilamová
K. Janovská
M. Řepka
author_sort R. Danel
collection DOAJ
description 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.
first_indexed 2024-12-18T06:38:47Z
format Article
id doaj.art-61b06f2237d14cd88563a8173630b1f7
institution Directory Open Access Journal
issn 0543-5846
1334-2576
language English
last_indexed 2024-12-18T06:38:47Z
publishDate 2015-10-01
publisher Croatian Metallurgical Society
record_format Article
series Metalurgija
spelling doaj.art-61b06f2237d14cd88563a8173630b1f72022-12-21T21:17:42ZengCroatian Metallurgical SocietyMetalurgija0543-58461334-25762015-10-015518386Database mirroring in fault-tolerant continuous technological process controlR. DanelL. OtteR. KozelD. JohanidesŠ. VilamováK. JanovskáM. ŘepkaThis 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.http://hrcak.srce.hr/file/209299Continuous productioncontroldatabase mirroringfault-tolerant system
spellingShingle R. Danel
L. Otte
R. Kozel
D. Johanides
Š. Vilamová
K. Janovská
M. Řepka
Database mirroring in fault-tolerant continuous technological process control
Metalurgija
Continuous production
control
database mirroring
fault-tolerant system
title Database mirroring in fault-tolerant continuous technological process control
title_full Database mirroring in fault-tolerant continuous technological process control
title_fullStr Database mirroring in fault-tolerant continuous technological process control
title_full_unstemmed Database mirroring in fault-tolerant continuous technological process control
title_short Database mirroring in fault-tolerant continuous technological process control
title_sort database mirroring in fault tolerant continuous technological process control
topic Continuous production
control
database mirroring
fault-tolerant system
url http://hrcak.srce.hr/file/209299
work_keys_str_mv AT rdanel databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT lotte databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT rkozel databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT djohanides databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT svilamova databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT kjanovska databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol
AT mrepka databasemirroringinfaulttolerantcontinuoustechnologicalprocesscontrol