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.
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.Subscribe to receive issue release notifications and newsletters from MECS Press journals