I Gede John Arissaputra

Work place: Departement of Information Technology, Udayana University, Bali, Indonesia

E-mail: john.arissaputra@gmail.com

Website:

Research Interests: Computer systems and computational processes, Computer Architecture and Organization, Database Management System, Data Structures and Algorithms

Biography

I Gede John Arissaputra, He graduated from high school in SMAN 1 Kuta Utara in 2014. He is currently in the process of studies at the Department of Information Technology, Udayana University, Bali, Indonesia. He also has the ability as a web developer and data management.

Author Articles
Binary Log Design for One-Way Data Replication with ZeroMQ

By I Gede John Arissaputra I Made Sukarsa Putu Wira Buana Ni Wayan Wisswani

DOI: https://doi.org/10.5815/ijmecs.2018.10.03, Pub. Date: 8 Oct. 2018

Today, many business transactions are done online, especially in the financial sector or banking [1]. But as companies grow, many problems occur such as the inability to manage data consistency, especially when data is associated with more than one database. Replication is one of the most commonly used way of syncing data. However, to ensure data remains consistent, it is not enough just to take advantage of the replication process. The problem that often happens is connection failure or offline host. The Binary Log approach is one of the alternative methods that can be used to develop database synchronization. Generally, binary log is used for data recovery or backup purposes. Binary log in the DBMS (Database Management System) record all changes that occur in the database both at the data and structure level, as well as the duration of time used. This information can be used as a reference in updating data, while the ZeroMQ socket used as data exchange medium so data in all system locations will be synchronized and integrated in real time. This research will discuss how to develop a synchronization system by utilizing Binary Log from MySQL to recognize data changes, inherit changes, send changes, and hopefully can contribute new alternative method in developing real time database synchronization.

[...] Read more.
Other Articles