DATABASE REPLICATION IN HETEROGENOUS PLATFORM
- 1 School of Information Systems, Bina Nusantara University, Jakarta, Indonesia
Abstract
The application of diverse database technologies in enterprises today is increasingly a common practice. To provide high availability and survavibality of real-time information, a database replication technology that has capability to replicate databases under heterogenous platforms is required. The purpose of this research is to find the technology with such capability. In this research, the data source is stored in MSSQL database server running on Windows. The data will be replicated to MySQL running on Linux as the destination. The method applied in this research is prototyping in which the processes of development and testing can be done interactively and repeatedly. The key result of this research is that the replication technology applied, which is called Oracle GoldenGate, can successfully manage to do its task in replicating data in real-time and heterogeneous platforms.
DOI: https://doi.org/10.3844/ajassp.2014.1450.1455
Copyright: © 2014 Hendro Nindito, Evaristus Didik Madyatmadja and Albert Verasius Dian Sano. This is an open access article distributed under the terms of the
Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
- 3,287 Views
- 2,874 Downloads
- 0 Citations
Download
Keywords
- Replication
- Heterogen
- Real Time
- SQL Server
- MySQL