arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 2008.05164cs.DB
收藏

流行DBMS中复制的网络足迹

The network footprint of replication in popular DBMSs

Muhammad Karam Shehzad, Jam Muhammad Yousif, Muhammad Saqib Ilyas, Adnan Iqbal

摘要:

数据库复制是可靠、容灾和高可用分布式系统的重要组成部分。但是,数据复制也会导致通信和处理开销。量化这些开销是至关重要的,在选择一个合适的DBMS形式几个可用的选项和容量规划。在本文中,我们提出了从比较实证分析的结果复制活动的三个常用的数据库管理系统- MySQL,PostgreSQL和Cassandra下的文本以及图像流量。在我们的实验中,有两个副本的总流量(这是标准)比没有副本的总流量高出$300$ \%。此外,为MySQL中内置的复制流量激活压缩选项,使总网络流量减少了$20$ \%。我们还发现,平均CPU利用率和内存利用率不受副本数量或数据集的影响。

英文摘要:

Database replication is an important component of reliable, disaster tolerant and highly available distributed systems. However, data replication also causes communication and processing overhead. Quantification of these overheads is crucial in choosing a suitable DBMS form several available options and capacity planning. In this paper, we present results from a comparative empirical analysis of replication activities of three commonly used DBMSs - MySQL, PostgreSQL and Cassandra under text as well as image traffic. In our experiments, the total traffic with two replicas (which is the norm) was as much as $300$\% higher than the total traffic with no replica. Furthermore, activation of the compression option for replication traffic, built into MySQL, reduced the total network traffic by as much as $20$\%. We also found that average CPU utilization and memory utilization were not impacted by the number of replicas or the dataset.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑