Aplikasi Migrasi Database dan Replikasi Bi-Directional

Michael Yoseph Ricky

Abstract


This study aims to analyze and design a migration and replication configurations in an enterprise using several methods such as literary study and direc survey to the company; analysis on hangar systems, process migration and replication as well as existing problems; and a prototype design for migration process implementated with Oracle SQL Developer and replication process implementated with Oracle GoldenGate. The study resluts ini a prototype for migration and replication configuration processes using Oracle's Golden Gate which can produce two sets of identical data for backup and recovery. Also a simple tool is designed to assist active-active replication process as well as active-passive one. The migration process from MySQL database to Oracle database using Oracle GoldenGate can not be done because GoldenGate Oracle has bugs related to the binary log, so database migration is done using Oracle SQL Developer. However, bi-directional replication between Oracle database using Oracle GoldenGate can ensure data availability and reduce the workload of primary database.

 


Keywords


database migration, Oracle Golden Gate, bi-directional replication, database

Full Text:

PDF

References


Hart, M., Jesse S. (2004). Oracle Database 10g: High Availablity with RAC Flashback & Data Guard. California: McGraw-Hill Osborne.

Howard, G., Irving, S. M., Sceales, A. M., Sauvage, A. M. F. (2010). Error prevention for data replication. Diakses dari http://www.ipo.gov.uk/p-find-publication-getPDF.pdf?PatentNo=GB2468742&DocType=A&JournalNumber=6331.

Morales, Tony. (2002). Oracle9i Database Migration, Release 2 (9.2). Diakses dari http://download.oracle.com/docs/cd/B10501_01/server.920/a96530.pdf

Munoz, J., Syracuse, N. (2000). Replication and Migration. Diakses dari https://www.ietf.org/proceedings/49/slides/NFSV4-4.pdf.

Viv, S. (2010). Oracle® Database High Availability Overview 11g Release 1 (11.1). diakses dari http://isu.ifmo.ru/docs/doc112/server.112/e10804.pdf.

Zeis, C., Ruel, C., Wessler, M. (2009). Oracle® 11g For Dummies. Indianapolis: Wiley Publishing.




DOI: https://doi.org/10.21512/comtech.v2i2.2828

Refbacks

  • There are currently no refbacks.



Public Visitor Statistics:ComTech stats
Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.