Distributed data recovery architecture based on schema segregation

TLDR: This paper proposes a decentralized disaster recovery structure instead of a single centralized DR, i.e. the databases are hosted on multiple servers, where each of these servers is catering to one or more related schema.

Abstract: The growing importance of huge amount of data and the data analysis for business agility has prophesied managerial decisions to ensure data security and disaster recovery options. This growing dependency has triggered extensive storage of data and development of ‘high availability’ databases. One of the prevalent practices in the industry is to provide for a data center (DC) where the on-going service runs under normal circumstances and another server at Disaster Recovery Center (DR) that contains a replica of the database to provide continuity of service if the primary database fails due to a catastrophe or some other unavoidable reasons. Such situation may cause the database server to be damaged or result in a hardware malfunction. In this paper, we propose a decentralized disaster recovery structure instead of a single centralized DR, i.e. the databases are hosted on multiple servers, where each of these servers is catering to one or more related schema. Since we have multiple servers each catering for a different schema, we also propose different replication schemes for each of these schemas depending on the nature of updates and usage. In the proposed architecture, we would like to have a cyclic back up scheme to provide better decentralization and less vulnerable as opposed to a radial back up architectures.