Implementación de una base de datos heterogénea distribuida entre los SGBDs ORACLE, MySQL y PostgreSQL con replicación, mediante un script bash implementado en el sistema operativo CentOS usando software libre

This article allows to obtain a heterogeneous distributed database with replication in a CentOS environment in less than 5 minutes, using a bash script, using only free software. The idea is focusedon having a slave that will be ORACLE and the master nodes will be in MySQL and PostgreSQL, in order t...

Descripción completa

Detalles Bibliográficos
Autor: Flores Castro, Edwin Geovanny
Tipo de recurso: artículo
Estado:Versión publicada
Fecha de publicación:2018
País:Ecuador
Institución:Universidad Internacional del Ecuador
Repositorio:Repositorio Universidad Internacional del Ecuador
OAI Identifier:oai:repositorio.uide.edu.ec:37000/3314
Acceso en línea:https://doi.org/10.33890/innova.v3.n2.1.2018.668
https://repositorio.uide.edu.ec/handle/37000/3314
Access Level:acceso abierto
Palabra clave:heterogeneidad; MySQL; PostgreSQL; ORACLE; ODBC
heterogeneity; MySQL; PostgreSQL; ORACLE; ODBC
Descripción
Sumario:This article allows to obtain a heterogeneous distributed database with replication in a CentOS environment in less than 5 minutes, using a bash script, using only free software. The idea is focusedon having a slave that will be ORACLE and the master nodes will be in MySQL and PostgreSQL, in order to reduce costs when designing and implementing a distributed database since the power of a manager is maximized of payment, which is Oracle, with the free and good performance of MySQL and PostgreSQL. The result of this article will be an ODBC that configures the two managers without spending a single cent and in record time, and thus be able to obtain a distributed database made up of different managers, who work as one.