๐”– Bobbio Scriptorium
โœฆ   LIBER   โœฆ

Evaluation of the basic remote backup and replication methods for high availability databases

โœ Scribed by Lars Frank


Publisher
John Wiley and Sons
Year
1999
Tongue
English
Weight
104 KB
Volume
29
Category
Article
ISSN
0038-0644

No coin nor oath required. For personal study only.

โœฆ Synopsis


In this paper, we describe the properties of two 0-safe backup/replication methods and compare them with the traditional 1-safe and 2-safe backup/replication methods. The 1-safe and 2-safe backup/replication methods have been analyzed for many years, and their problems are well known. The properties of the 0-safe designs have not yet been analyzed. The basic 2-safe, 1-safe and 0-safe backup designs all use two copies of the database. However, under normal operation the database copies of the 2-safe backup design are both consistent and up-to-date, whereas the 1-safe backup design only uses one up-to-date copy of the database. In the 0-safe backup design none of the databases are consistent and up-to-date. Therefore, this backup design is named 0-safe. However, in the 0-safe design the two inconsistent copies converge towards the same consistent state. In a 0-safe design transactions update and commit the nearest database copy first and, therefore, the database copies are normally inconsistent. The inconsistency between the 0-safe database copies must be managed by using countermeasures, which will reduce the problems of the missing distributed isolation property. We will also describe and evaluate a mixture of the 0-safe and the 1-safe designs, which in certain situations may have more interesting properties than the original designs. The backup/replication designs will among other things be compared with respect to their disaster recoverability, availability, performance, implementation problems and ACID properties. The largest bank in Denmark, Den Danske Bank, has converted all its important database systems from using the 1-safe design to using the 0-safe design. We have been cooperating with one of the major ERP (Enterprise Resource Planning) software companies in designing a distributed version of their financial management and accounting system by using the techniques described in this paper. We have now started to implement a prototype of the system.


๐Ÿ“œ SIMILAR VOLUMES


Evaluation of centralized maintenance fo
โœ Masanori Hirano; Michihiro Yamane; Masamitu Kobayashi; Yasuo Kinouchi ๐Ÿ“‚ Article ๐Ÿ“… 2000 ๐Ÿ› John Wiley and Sons ๐ŸŒ English โš– 311 KB

A system is considered in which two dual nodes with databases are placed at distant locations for mutual backup. When they are distributed in the network, the relationship between the centralized maintenance and the reliability is studied. The maintenance teams are centrally located at the maintenan