Performance of free replication tools for the implementation of an integrated high availability system oriented to the management of academic tutoring in Higher Education Institutions

Authors

  • Diego Bernardo Palacios Campana Escuela Superior Politécnica de Chimborazo
  • Gonzalo Allauca Peñafiel Universidad Nacional de Chimborazo
  • Danny Velasco Silva Universidad Nacional de Chimborazo
  • Estuardo Cajilema Guamán Universidad Nacional de Chimborazo
  • Rubén Saltos Chávez Escuela Superior Politécnica de Chimborazo

DOI:

https://doi.org/10.47187/perspectivas.vol2iss2.pp2-6.2020

Keywords:

Replication, Slony, PgPool, PrimeFaces, PostgreSQL

Abstract

A comparative analysis of the Slony-I and PgPool-II data replication tools was carried out, to select the best alternative in the implementation of an integrated system of high availability for the management of academic tutoring in Higher Education Institutions, established as Study parameters the response time against the execution of SQL statements, the use of CPU, memory, and hard disk. An N-Layers web application was developed using PrimeFaces and PostgreSQL, integrated into an Academic System through SOAP web services. To carry out the tests, master and slave database servers were configured under a Linux environment. The performance tests were based on the Apache JMeter tool, simulating 282 requests per second in an instant of time, observing that PgPool-II consumed less resources with an average of 2.80%, however, Slony-I was more effective at carry out transactions with just 0.009% error.

Métricas

References

M. Marqués. SQL Server 2008 R2 Motor de base de datos y administración. Grupo RC, España, 2011.

F. Asteasuain y A. Javed, «Tecnología aplicada a aspectos en base de datos relacionales: El caso de replicación,» Ingeniería & Desarrollo, nº 25, p. 232, 2009.

Y. Guerra, E. Altuna, A. García y. Pérez, «Experiencias en el uso del symmetric para la replicación de datos en la plataforma educativa ZERA,» Revista Cubana de Ciencias Informáticas, vol. 9, nº 4, p. 197, 2015.

S.D. Group. Slonny-I, 2007. [En línea]. Disponible: http://www.slony.info/.

MediaWiki. PgPool, 2011. [En línea]. Disponible: http://www.pgpool.net

G. Brill. Codenotes for J2EE: EJB, JDBC, JSP, and Servelets. Random House Trade Paperbacks, New York, 2002.

J. Jacobi, J. Fallows. Pro JSF and AJAX. Building Rich Internet Components (1 ed.). Apress, USA, 2006.

J. Arrambide. Desarrollo Web en Java: Configura paso a paso todas las herramientas para crear proyectos web. Edición Kindle, Estados Unidos, 2017.

PrimeTek. Leading Provider of Open Source UI Component Libraries, 2009. [En línea]. Disponible: https://www.primefaces.org/

Consejo de Educación Superior. Reglamento de Régimen Académico. CES, Ecuador, 2019.

K. Beck y C. Andres, Extreme Programming Explained: Embrace Change, Addison-Wesley Educational Publishers Inc, 2004.

Portada Vol 2 - Num 2

Downloads

Published

2020-07-05

How to Cite

[1]
D. B. Palacios Campana, G. Allauca Peñafiel, D. Velasco Silva, E. Cajilema Guamán, and R. Saltos Chávez, “Performance of free replication tools for the implementation of an integrated high availability system oriented to the management of academic tutoring in Higher Education Institutions: Array”, Perspectivas, vol. 2, no. 2, pp. 2–6, Jul. 2020.

Issue

Vol. 2 No. 2 (2020): Revista Perspectivas

Section

Artículos arbitrados

License

Copyright (c) 2020 Diego Bernardo Palacios Campana, Gonzalo Allauca Peñafiel, Danny Velasco Silva, Estuardo Cajilema Guamán, Rubén Saltos Chávez

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright

The authors of the manuscripts will retain their copyright on their articles published in Pespectivas Journal. These rights allow the authors to present their manuscripts in public, prepare derivative works, reproduce them physically by printing and distribute them on their social or research networks. These rights will remain unchanged as long as the authors respect the publication and free access policy of Perspectivas Journal.

 

Publication Rights

Perspectivas Journal reserves all first publication rights on each of the articles that the authors have sent to its review and publication process. It implies that authors will only exercise their copyright if they state the source and origin of the publication correctly, mainly when they distribute, share, present, or use their articles' total or partial content.