Abstract—The production database are transactions intensive transactions can be insert, update on the tables, failover is the replica of the production server, if there is any change we have to implement on the production and it will be automatically implemented on failover or standby database. Now a days the data on the production server is increasing and we need extra storage space on production server to keep data and this is same required on the failover. To generate reports from that data will increase load on the production server and can affect the performance of the server. There are also some threats which can cause loss of data from which we have to protect our database like Hardware failure, loss of machine. Replication is one of the methods for Backup of the running database and its immediate failover during failure. This paper represents some parts for the replication techniques, failover, and transaction states.

Index Terms—Asynchronous, synchronous, active, commit, rollback, RAIDb.

Tarandeep Singh is with the Punjab Technical University, India (e-mail: tarandeepskhs@gmail.com).
Parvinder S. Sandhu is with the Rayat and Bahra Institute of Engineering and Bio-Technology, Mohali, Punjab, India (e-mail: parvinder.sandhu@gmail.com). Harbax Singh Bhatti is with the Department of Applied Sciences, Baba Banda Singh Bahadur, Engineering College, Fatehgarh Sahib (India).

Cite:Tarandeep Singh, Parvinder S. Sandhu, and Harbax Singh Bhatti, "Replication of Data in Database Systems for Backup and Failover – An Overview," International Journal of Computer and Communication Engineering vol. 2, no. 4, pp. 535-538, 2013.