Open AccessHybrid Data Protection Framework to Enhance A2O Functionality in Production Database Virtualization
Author(s) -
Naeem Zafar Azeemi,
Zulqarnain Hayat,
Ghassan Al Utaibi,
Omar al Basheer
Publication year - 2020
Publication title -
international journal of recent technology and engineering
Language(s) - English
Resource type - Journals
ISSN - 2277-3878
DOI - 10.35940/ijrte.f1203.038620
Subject(s) - failover , computer science , high availability , cloud computing , database , computer network , operating system
Deluge of information flows in the unprecedented scenario of smart city development trend, hence prone to issues on stability, reliability and availability. Smart data storage resources are vulnerable to provide functionality Always Available Online (A2O) due to their inherent heavy dependence on System Down Time (SDT), Redundant Systems and Software Failure (RS2F) or whole/ multiple site failures. In the absence of Production Database Management Services (PDMS), duplicate deployment of similar data on disjoint but similar architecture provides a Tightly Coupled Ultimate System (TCUS), which assures A2O mutually exclusive services. In this paper, we investigated active Data Guard (aDG) and Data Guard (DG) role management or switchover for a real time transition performed for database at standby state to cope up both planned maintenance and accidental RS2F events. We expose our results for deep integration of aDGs with ODB in-terms of Fast Sync to align synchronously at an ease of zero of wait states for disk I/O and configurability to Null Data Loss (NDL). Over a large range of remote or standby databases NDL make it certain to zero failover. The impact of aDG Fast-Start Failover in the cloud proximity make sure guaranteed NDL in synchronously and near NDL protection asynchronously. Hence, avoids unusual overhead impeding disk I/O and eventually on a primary database. We observe the key performance indicator in failover does not restart the standby database for primary role resumption, but introduce cloud proximity as a new primary database and the process is performed without any intervention of manual migration. The reliability of aDG Redo is flexible across not only standby databases but also primary sites running different operating system over diverse hardware platforms. The Redo capability enables migration with minimal downtime for any transaction in the clouds, therefore adds an inevitable functionality to big data applications.