Performance Comparison between NoSQL (RethinkDB) and MySQL Database Replication from Master to Slave in Big Data

被引:0
|
作者
Hussain, Dildar [1 ]
Omar, Mohammad [1 ]
Ahmad, Khairol Amalfi [2 ]
Adnan, Ja'afar [2 ]
Ahmad, Khaleel [1 ]
机构
[1] Maulana Azad Natl Urdu Univ, Dept Comp Sci & Informat Technol, Bengaluru, India
[2] Natl Def Univ Malaysia, Fac Engn, Dept Elect & Elect Engn, Kuala Lumpur, Malaysia
来源
JURNAL KEJURUTERAAN | 2021年 / 4卷 / 02期
关键词
MySQL; NoSQL; replication; Master and Slave Database; USN; DRBD; RSYNC;
D O I
10.17576/jkukm-2021-si4(2)-10
中图分类号
T [工业技术];
学科分类号
08 ;
摘要
When database is stored in one computer or server, certain issues related to disaster (in terms of natural or un-natural) problem may arise with reference to geographical connection and geographical distribution of servers. Here, replication feature plays an important role. There were many techniques and methodologies for geographically distributed servers, but the problem was of one master. When an authorized user updates his database on a client database server then this client database server updates his master database server and at last, the master database server updates all its client's database servers. The described process is called database replication. In this process, there are several main parameters that are important, i.e., bandwidth, memory, and processor time. In this paper, the analysis is focused on comparing which database (NoSQL family-RethinkDB and MySQL) utilize how much memory, processor, and time during replication of database from client to master.
引用
收藏
页码:65 / 69
页数:5
相关论文
共 16 条
  • [1] NoSQL Database: A Scalable, Availability, High Performance Storage for Big Data
    Huang, Yu
    Luo, Tiejian
    [J]. PERVASIVE COMPUTING AND THE NETWORKED WORLD, 2014, 8351 : 172 - 183
  • [2] Graph-Based Denormalization for Migrating Big Data from SQL Database to NoSQL Database
    Rathika, V
    [J]. INTELLIGENT COMMUNICATION TECHNOLOGIES AND VIRTUAL MOBILE NETWORKS, ICICV 2019, 2020, 33 : 546 - 556
  • [3] An Empirical Performance Comparison between MySQL and MongoDB on Analytical Queries in the COMEX Database
    Gomes, Augusto
    Lopes, Vitor
    Ribeiro, Edward
    Lima, Jorge
    Costa, Wagner
    Garcia, Luis
    Holanda, Maristela
    [J]. PROCEEDINGS OF 2021 16TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI'2021), 2021,
  • [4] High Availability and Performance of Database in the Cloud Traditional Master-slave Replication versus Modern Cluster-based Solutions
    Shrestha, Raju
    [J]. CLOSER: PROCEEDINGS OF THE 7TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING AND SERVICES SCIENCE, 2017, : 385 - 392
  • [5] Performance Comparison Between Apache Hive and Oracle SQL for Big Data Analytics
    Sethy, Rotsnarani
    Dash, Santosh Kumar
    Panda, Mrutyunjaya
    [J]. PROCEEDINGS OF THE EIGHTH INTERNATIONAL CONFERENCE ON SOFT COMPUTING AND PATTERN RECOGNITION (SOCPAR 2016), 2018, 614 : 130 - 141
  • [6] Big-data for building energy performance: Lessons from assembling a very large national database of building energy use
    Mathew, Paul A.
    Dunn, Laurel N.
    Sohn, Michael D.
    Mercado, Andrea
    Custudio, Claudine
    Walter, Travis
    [J]. APPLIED ENERGY, 2015, 140 : 85 - 93
  • [7] Performance Comparison between S3, HDFS and RDS storage technologies for real-time big-data applications
    Jamal, Alaa
    Fleiner, Rita
    Kail, Eszter
    [J]. IEEE 15TH INTERNATIONAL SYMPOSIUM ON APPLIED COMPUTATIONAL INTELLIGENCE AND INFORMATICS (SACI 2021), 2021, : 491 - 496
  • [8] Comparison of thermal comfort between radiant and convective systems using field test data from the Chinese Thermal Comfort Database
    Du, Heng
    Lian, Zhiwei
    Lai, Dayi
    Duanmu, Lin
    Zhai, Yongchao
    Cao, Bin
    Zhang, Yufeng
    Zhou, Xiang
    Wang, Zhaojun
    Zhang, Xiaojing
    Hou, Zhijian
    [J]. BUILDING AND ENVIRONMENT, 2022, 209
  • [9] Exploring the mediating role of big data in the relationship between servant leadership and firm performance: insights from private hospitals in India
    Kumar, Anup
    Chauhan, Vinit Singh
    [J]. INTERNATIONAL JOURNAL OF PRODUCTIVITY AND PERFORMANCE MANAGEMENT, 2024, 73 (08) : 2650 - 2672
  • [10] A comparison of surgical practice and operative outcomes between retroperitoneal and transperitoneal laparoscopic nephrectomies - 6 years of data from the BAUS Nephrectomy database
    Jenkins, James
    Foy, Christopher
    Davenport, Kim
    [J]. JOURNAL OF CLINICAL UROLOGY, 2023, 16 (05) : 548 - 561