Hybrid Data Replication Gateway

Pratama, Aditya Fieansyah Putra and Akbari, Izzudin Ali (2026) Hybrid Data Replication Gateway. Project Report. [s.n.], [s.l.]. (Unpublished)

Text 5025231309_5025231313-Project_Report.docx.pdf - Accepted Version Restricted to Repository staff only Download (3MB) | Request a copy

Abstract

Perkembangan sistem informasi terdistribusi menuntut ketersediaan data yang konsisten dan sinkron antar lokasi. Pada lingkungan organisasi dengan banyak cabang, perbedaan sistem basis data serta keterbatasan konektivitas dapat menjadi kendala dalam pengelolaan data terpusat. Penelitian ini bertujuan untuk mengimplementasikan dan menganalisis mekanisme replikasi data dua arah (bidirectional replication) antara basis data Oracle sebagai Head Office (HO) dan MySQL sebagai basis data cabang menggunakan SymmetricDS. Implementasi dilakukan dengan arsitektur satu server dan dua node edge, di mana tabel EMP dan DEPT direplikasi secara penuh (insert, update, dan delete) pada ketiga basis data. Proses replikasi dijalankan dalam lingkungan Docker untuk memastikan konsistensi konfigurasi dan kemudahan deployment. Pengujian dilakukan dengan skenario perubahan data pada masing‑masing node untuk memastikan replikasi berjalan dengan baik pada kedua arah. Hasil pengujian menunjukkan bahwa SymmetricDS mampu menangani replikasi data lintas basis data yang secara mekanisme sinkronisasi berbasis trigger dan batch data yang dikirim secara otomatis antar node, dengan catatan konfigurasi trigger, router, serta proses registrasi node dilakukan dengan benar. Sistem ini dapat menjadi solusi yang efektif untuk mendukung sinkronisasi data pada sistem terdistribusi dengan arsitektur multi‑cabang.
================================================================================================================================
The development of distributed information systems requires data availability that is consistent and synchronized across multiple locations. In organizational environments with numerous branches, differences in database systems and limited connectivity can pose challenges to centralized data management. This study aims to implement and analyze a bidirectional data replication mechanism between an Oracle database as the Head Office (HO) and a MySQL database as branch databases using SymmetricDS. The implementation is carried out using an architecture consisting of one server and two edge nodes, where the EMP and DEPT tables are fully replicated (insert, update, and delete) across all three databases. The replication process is executed within a Docker environment to ensure configuration consistency and ease of deployment. Testing is conducted through various data modification scenarios at each node to verify that bidirectional replication functions properly. The results show that SymmetricDS is capable of handling cross-database replication through a synchronization mechanism based on triggers and batch data transmission, which are automatically distributed between nodes. However, successful implementation depends on proper configuration of triggers, routers, and node registration processes. This system can serve as an effective solution for supporting data synchronization in distributed systems with multi-branch architectures.

Item Type:	Monograph (Project Report)
Uncontrolled Keywords:	Basis Data Terdistribusi, Bidirectional Replication, MySQL, Oracle, Replikasi Data, SymmetricDS, Distributed Database, Bidirectional Replication, MySQL, Oracle, Data Replication, SymmetricDS
Subjects:	T Technology > T Technology (General) > T57.5 Data Processing T Technology > T Technology (General) > T58.6 Management information systems
Divisions:	Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Informatics Engineering > 55201-(S1) Undergraduate Thesis
Depositing User:	Aditya Fieansyah Putra Pratama
Date Deposited:	11 Jun 2026 00:57
Last Modified:	11 Jun 2026 00:57
URI:	http://repository.its.ac.id/id/eprint/133709

Actions (login required)

View Item