An Exploratory Study of PostgreSQL Open Source Data Replication Tools

• Danilo Carlo UTFPR
• Darlan Andrade UTFPR
• Rafael Liberato UTFPR
• André L. Schwerz UTFPR

DOI: https://doi.org/10.5753/erbd.2019.8474

Abstract

Data distribution is indispensable to keep applications available and accessible when dealing with a high volume of requests. To meet this demand, PostgreSQL provides a wide variety of tools for data replication. However, understanding its characteristics and limitations is complex and time consuming. In this paper, we present an exploratory study about the features and limitations of the main open source tools for data replication in PostgreSQL, to reduce the complexity and time spent by database administrators in choosing the tool that meets their replication requirements.

Keywords: Open Source, PostgreSQL, Data Replication

References

Bishop, S. (2010). Mammoth replicator. Disponível em: https://launchpad.net/mammothreplicator. Acesso em 10/12/2018. Bucardo (2019). Bucardo asynchronous postgresql replication system. Disponível em: https://bucardo.org/Bucardo. Acesso em 15/01/2019.

Citus Data, I. (2019). Citus documentation. Disponível em: https://docs.citusdata.com/en/v8.1/index.html. Acesso em 19/01/2019. Group, P. G. D. (2019a). Postgresql. Disponível em: http://www.postgresql.org. Acesso em 16/03/2019.

Group, S. D. (2019b). Slony-i enterprise-level replication system. Disponível em: http://slony.info/. Acesso em 15/01/2019.

Gupta, S., Saroha, K., and Bhawna (2011). Fundamental research of distributed database. IJCSMS - International Journal of Computer Science and Management Studies, Vol. 11, Issue 02, Aug 2011 - Disponível em: https://pdfs.semanticscholar.org/f935/1f0cf3c4307dd76c85d6815e2a1b8095324b.pdf. Acesso em 16/03/2019.

Heisler, D. A. (2008). Estudo de algoritmos e técnicas de replicação de banco de dados em software livre. Disponível em: https://www.univates.br/bdu/bitstream/10737/563/1/2008DanielAfonsoHeisler.pdf. Acesso em 06/02/2019.

Lehmann, A. (2017). rubyrep: Home. Disponível em: http://www.rubyrep.org. Acesso em 10/12/2018. MariaDB (2019). Replication overview. Disponível em: https://mariadb.com/kb/en/library/replication-overview/. Acesso em 09/02/2019.

Mauchle, F. (2008). Database replication with mysql and postgresql. Disponível em: https://wiki.hsr.ch/Datenbanken/files/Mauchle Replication MySQL Postgres Paper.pdf. Acesso em 08/02/2019.

Mazilu, M. C. et al. (2010). Database replication. Database Systems Journal, 1(2):33–38.

Moiz, S. A., P., S., G., V., and Pal, S. N. (2011). Article: Database replication: A survey of open source and commercial tools. International Journal of Computer Applications, 13(6):1–8.

Partio, M. (2007). Evaluation of postgresql replication and load balancing implementations. Unpublished.

PgFoundry (2009). Pgfoundry: Pgcluster. Disponível em: http://pgfoundry.org/projects/pgcluster. Acesso em 10/12/2018.

PgFoundry (2019). Pgpool wiki. Disponível em: http://www.pgpool.net/mediawiki/index.php/Main_Page. Acesso em 11/01/2019.

Postgres-XL (2019). Open sourcescalable sql database cluster. Disponível em: https://www.postgres-xl.org. Acesso em 15/01/2019.

Server, S. (2019). Tipos de replicac¸ao. Disponível em: https://docs.microsoft.com/ptbr/sql/relational-databases/replication/types-of-replication. Acesso em 09/02/2019. Severalnines (2018). An overview of logical replication in postgresql. Disponível em: https://severalnines.com/blog/overview-logical-replication-postgresql. Acesso em 08/02/2019.

Tauro, C. J., Patil, B. R., and Prashanth, K. (2013). A comparative analysis of different nosql databases on data model, query model and replication model. In Proceedings of the International Conference on ERCICA.

Wiesmann, M., Pedone, F., Schiper, A., Kemme, B., and Alonso, G. (2000). Understanding replication in databases and distributed systems. In Proceedings 20th IEEE International Conference on Distributed Computing Systems, pages 464–474.