Abstract
Synchronous replication is the ideal solution for organizations: search for the fastest possible data recovery, minimal data loss and protection against the problems of database integrity. This ensures that the remote copy of data that is identical to the primary copy is created at the same time the primary copy is updated. However, most of the synchronous replication does not consider the heterogeneous system. In this paper, a software persistence layer for heterogeneous synchronous replication has been designed and developed based on multi-threading known as PLSR. The main objective of this strategy is to make the persistence layer adaptive and make the synchronous replication process reliable and faster than other existing replication processes concerning cost minimization. In the proposed PLSR replication technique, the replication servers are OS independent and the entire replication process is not inter dependent nevertheless on the main server. Adding a new replication server is easier than other processes. The technique also introduces the modification of replication servers without making impairment to the entire process. The comparative Results with SQL server data replication show the PLSR is more acceptable in terms of transactional insertions and sync time. The result shows that PLSR outstanding performs 88.5 % faster than SQL server for transactional insert.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abdul-Wahid, S., Andonie, R., Lemley, J., Schwing, J., Widger, J.: Adaptive Distributed Database Replication Through Colonies of Pogo Ants. In: IPDPS, IEEE International Parallel and Distributed Processing Symposium, pp. 1–8 (2007)
Osrael, J., Froihofer, L., Chlaupek, N., Goeschka, K.M.: Availability and Performance of the Adaptive Voting Replication Protocol. In: ARES, The Second International Conference on Availability, Reliability and Security, pp. 53–60. IEEE Press, Vienna (2007)
Gao, T., Liu, F.: A Dynamic Data Replication Technology in Educational Resource Grid. In: ISITAE, First IEEE International Symposium on Information Technologies and Applications in Education, pp. 287–291 (2007)
Sato, H., Matsuoka, S., Endo, T.: File Clustering Based Replication Algorithm in a Grid Environment. In: 9th IEEE/ACM International Symposium on Cluster Computing and the Grid, pp. 204–211 (2009)
Elghirani, A., Zomaya, A.Y., Subrata, R.: An Intelligent Replication Framework for Data Grids. In: AICCSA, IEEE/ACS International Conference on Computer Systems and Applications, pp. 351–358 (2007)
Lou, Y.-s., Wang, Z.-j., Huang, L.d., Yue, L.-l.: The Study of A Reflected Persistence Data Layer Framework. In: WCSE, WRI World Congress on Software Engineering, pp. 291–294 (2009)
Rajasekhar, S., Rong, B., Lai, K.Y., Khalil, I., Tari, Z.: Load Sharing in Peer-to-Peer Networks using Dynamic Replication. In: AINA, 20th International Conference on Advanced Information Networking and Applications, pp. 1011–1016 (2006)
Wang, Y., Li, S.: Research and performance evaluation of data replication technology in distributed storage systems. Computers & Mathematics with Applications 51, 1625–1632 (2006)
Bost, Charron, B., Pedone, F., Schiper, A.: Replication Theory and Practice, ch. 2. Springer, Heidelberg (2009); ISBN-10 3-642-11293-5
Lin, Y.: Practical and consistent database replication, Â ch.1-2. McGill University Montreal, Quebec (2007)
Gu, L., Budd, L., Caycl, A., Hendricks, C., Purnell, M., Rigdon, C.: Practical Guide to DB2 UDB Data Replication, vol. 8, ch. 1. IBM, Durham (2002)
Ibej, U.C., Slivnik, B., Robic, B.: The complexity of static data replication in data grids. Parallel Computing 31, 900–912 (2005)
Urbano, R.: Oracle Database Advanced Replication. Oracle Corporation, Part No. B10732-01, ch.1 (2003)
Hitachi data system, http://www.hds.co.uk/assets/pdf/sb-synchronous-data-replication.pdf
Boyera, W.F., Hurab, G.S.: Non-evolutionary algorithm for scheduling dependent tasks in distributed heterogeneous computing environments. J. Parallel Distrib. Comput. 65, 1035–1046 (2005)
Tanga, X., Li, K., Li, R., Veeravalli, B.: Reliability-aware scheduling strategy for heterogeneous distributed computing systems. J. Parallel Distrib. Comput. 70, 941–952 (2010)
Tong, X., Shu, W.: An Efficient Dynamic Load Balancing Scheme for Heterogenous Processing System. In: IEEE Conference on Computational Intelligence and Natural Computing, pp. 319–322 (2009)
Guest editorial. Heterogeneous computing. Parallel Computing 31, 649–652 (2005)
Open Ehr, http://www.openehr.org/208-OE.html?branch=1&language=1
Dewald, B., Kline, K.: InformIT.: SQL Server: Transaction and Locking Architecture, http://www.informit.com/articles/article.aspx?p=26657
Poddar, S.: SQL Server Transactions and Error Handling, http://www.codeproject.com/KB/database/sqlservertransactions.aspx
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Beg, A.H., Ahmad, N., Alla, A.N.A., Sultan, E.I., Zin, N.M. (2011). Synchronous Replication: Novel Strategy of Software Persistence Layer Supporting Heterogeneous System. In: Zain, J.M., Wan Mohd, W.M.b., El-Qawasmeh, E. (eds) Software Engineering and Computer Systems. ICSECS 2011. Communications in Computer and Information Science, vol 180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-22191-0_21
Download citation
DOI: https://doi.org/10.1007/978-3-642-22191-0_21
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-22190-3
Online ISBN: 978-3-642-22191-0
eBook Packages: Computer ScienceComputer Science (R0)