Work place: Departement of Informatic Management, Bali State Polytechnic, Indonesia
E-mail: wisswani@yahoo.com
Website:
Research Interests: Bioinformatics, Neuroinformatics
Biography
Ni Wayan Wisswani, She obtained her Master Degree in Fac. of Electrical Engineering at Udayana University. She currently works as a lecturer in the Department of Informatics Management of Bali State Polytechnic. She has conducted three journal publications in the field of Middleware.
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