Title: Modelling and analysis of two-unit hot standby database system with random inspection of standby unit

Authors: Amit Manocha; Gulshan Taneja; Sukhvir Singh; Rahul Rishi

Addresses: Department of Mathematics, T.I.T.S., Bhiwani, Haryana 127021, India ' Department of Mathematics, M.D. University, Rohtak, Haryana 124001, India ' Department of Information Technology, iNurture Education Solutions Pvt. Ltd., Bangalore, Karnataka 560052, India ' Department of Computer Science, U.I.E.T., M.D. University, Rohtak, Haryana 124001, India

Abstract: Stochastic model for a two-unit hot standby database system comprising of one operative (primary unit) and one hot standby unit has been developed. The primary unit acts as production unit which is synchronised with hot standby unit through online transfer of archive redo logs. The data being saved in the primary unit gets simultaneously stored in the hot standby unit. The different modes of failure of primary database have been considered. To avoid loss of data, random inspection of the standby unit is carried out by a database administrator (DBA) to see as to whether redo log files are created/updated in standby unit or not. The repair of the failed unit and creation/updation of redo log files are also done by the DBA. The system is analysed using semi-Markov process and regenerative point technique. Mathematical expressions for various performance measures of the system have been obtained along with cost-benefit analysis of the system. Numerical analysis has been done to validate the derived results. Bounds for various parameters have also been obtained with regard to profitability of the system.

Keywords: database system; hot standby; random inspection; semi-Markov process; regenerative point technique; stochastic modelling; system effectiveness; cost-benefit analysis; profitability; bounds.

DOI: 10.1504/IJMOR.2019.101618

International Journal of Mathematics in Operational Research, 2019 Vol.15 No.2, pp.156 - 180

Accepted: 04 Mar 2018
Published online: 16 Aug 2019 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article