Binary Log Design for One-Way Data Replication with ZeroMQ

Full Text (PDF, 684KB), PP.22-30

Views: 0 Downloads: 0


I Gede John Arissaputra 1,* I Made Sukarsa 1 Putu Wira Buana 1 Ni Wayan Wisswani 2

1. Departement of Information Technology, Udayana University, Bali, Indonesia

2. Departement of Informatic Management, Bali State Polytechnic, Indonesia

* Corresponding author.


Received: 15 Jul. 2018 / Revised: 20 Aug. 2018 / Accepted: 5 Sep. 2018 / Published: 8 Oct. 2018

Index Terms

Synchronization, Binary log, Socket, Replication


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.

Cite This Paper

I Gede John Arissaputra, I Made Sukarsa, Putu Wira Buana, Ni Wayan Wisswani, " Binary Log Design for One-Way Data Replication with ZeroMQ", International Journal of Modern Education and Computer Science(IJMECS), Vol.10, No.10, pp. 22-30, 2018. DOI:10.5815/ijmecs.2018.10.03


[1]Margaretha, F., DAMPAK ELECTRONIC BANKING TERHADAP KINERJA PERBANKAN INDONESIA. Jurnal Keuangan dan Perbankan, Vol.19, No.3 September 2015, hlm. 514–524, 2015.
[2]Surya, G.H., I.M. Sukarsa, and I.G.M.A. Sasmita, Two-Ways Database Synchronization In Homogenous Database Management System With Binary Log Approach. Journal of Theoretical and Applied Information Technology, 2014. 65.
[3]Hanafi, A., I.M. Sukarsa, and A.A.K.A.C. Wiranatha, Pertukaran Data Antar Database dengan Menggunakan Teknologi API. LONTAR KOMPUTER, 2017. 8.
[4]Gudakesa, R., I.M. Sukarsa, and I.G.M.A. Sasmita, Two-Ways Database Synchronization In Homogeneous DBMS Using Audit Log Approach. Journal of Theoretical and Applied Information Technology, 2014. 65.
[5]Abhisena, I.G.A., I.M. Sukarsa, and D.P. Githa, Implementasi Database Auditing dengan Memanfaatkan Sinkronisasi DBMS. LONTAR KOMPUTER, 2017. 8.
[6]Lee, S., H. Park, and W.J. Lee, Design of ZeroMQ-Based Cooperative Simulation Framework for Distributed Code and Model Components. International Journal of Future Computer and Communication, 2015. 4.
[7]Jothipriya and M.L. Shri, Database Synchronization of Mobile-build by using Synchronization framework. International Journal of Engineering and Technology (IJET), 2013. 5(3).
[8]Yang, F., et al., DZMQ: A Decentralized Distributed Messaging System for Realtime Web Applications and Services. 11th Web Information System and Application Conference, 2014.
[9]Malhotra, N. and A. Chaudhary, Implementation of Database Synchronization Technique between Client and Server. International Journal of Engineering Science and Innovative Technology (IJESIT), 2014. 3(4).
[10]Jafarinejad, M. and M. Amini, Multi-join query optimization in bucket-based encrypted databases using an enhanced ant colony optimization algorithm. Springer US, 2018.
[11]Patro, S., P.M. Potey, and A. Golhani, Comparative Study of Middleware solutions For Control and Monitoring systems. IEEE, 2017.
[12]Shaochao, S., H. Dao, and y. Gong, A MT-NT-MILP Combined Method for Gross Error Detection and Data Reconciliation. IEEE, 2010.
[13]Meng, Z., et al., A Data-Oriented M2M Messaging Mechanism for Industrial IoT Applications. IEEE, 2016.
[14]Gougeaud, S., et al., Using ZeroMQ as communication/synchronization mechanisms for IO requests simulation. 2017.
[15]Estrada, N. and H. Astudillo, Comparing scalability of message queue system: ZeroMQ vs RabbitMQ. XLI Latin American Computing Conference (CLEI), 2015.
[16]Sasongko, Y.A. and W. Suadi, IMPLEMENTASI KOMUNIKASI ANTAR SERVER PADA BISNIS PULSA ELEKTRIK MENGGUNAKAN ZEROMQ Digital Library Institut Teknologi Seputuh Nopember, 2010.