PostgreSQL数据库中复制机制的实现

R. Gibadullin, I. Vershinin, R. Minyazev
{"title":"PostgreSQL数据库中复制机制的实现","authors":"R. Gibadullin, I. Vershinin, R. Minyazev","doi":"10.1109/ICIEAM.2017.8076380","DOIUrl":null,"url":null,"abstract":"Nowadays we have a project of a high-performance parallel encrypted database on a cluster platform that will work with large volumes of data. For the smooth operation of the system, a reliable and high-speed data replication mechanism is required which should satisfy certain criteria of PostgreSQL DBMS and the mentioned project. In this article we consider the very essence of data replication, replication strategy, the basic methods and techniques of replication and also made compliance analyses with the replication method for high-performance parallel DBMS on the cluster platform. We also made an experiment to study the reliability and speed of the method for data replication between nodes in the cluster where the work was done with different amounts of the replica and a different nodes number. The aim was to obtain information on the speed of the Slony-I replication method at different volumes of the replicated data and the different number of nodes in the cluster on which we make a conclusion about the reliability of this method in relation to the project mentioned above.","PeriodicalId":428982,"journal":{"name":"2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM)","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"8","resultStr":"{\"title\":\"Realization of replication mechanism in PostgreSQL DBMS\",\"authors\":\"R. Gibadullin, I. Vershinin, R. Minyazev\",\"doi\":\"10.1109/ICIEAM.2017.8076380\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Nowadays we have a project of a high-performance parallel encrypted database on a cluster platform that will work with large volumes of data. For the smooth operation of the system, a reliable and high-speed data replication mechanism is required which should satisfy certain criteria of PostgreSQL DBMS and the mentioned project. In this article we consider the very essence of data replication, replication strategy, the basic methods and techniques of replication and also made compliance analyses with the replication method for high-performance parallel DBMS on the cluster platform. We also made an experiment to study the reliability and speed of the method for data replication between nodes in the cluster where the work was done with different amounts of the replica and a different nodes number. The aim was to obtain information on the speed of the Slony-I replication method at different volumes of the replicated data and the different number of nodes in the cluster on which we make a conclusion about the reliability of this method in relation to the project mentioned above.\",\"PeriodicalId\":428982,\"journal\":{\"name\":\"2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM)\",\"volume\":\"1 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-05-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"8\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICIEAM.2017.8076380\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICIEAM.2017.8076380","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 8

摘要

现在我们有一个在集群平台上的高性能并行加密数据库项目,该项目将处理大量数据。为了系统的顺利运行,需要一个可靠的、高速的数据复制机制,该机制应该满足PostgreSQL DBMS和上述项目的一定标准。本文讨论了数据复制的本质、复制策略、复制的基本方法和技术,并对集群平台上高性能并行DBMS的复制方法进行了合规性分析。我们还做了一个实验来研究该方法在集群中使用不同数量的副本和不同节点数的节点之间进行数据复制的可靠性和速度。目的是获得关于Slony-I复制方法在不同复制数据量和集群中不同节点数量下的速度的信息,我们在此基础上得出关于该方法与上述项目相关的可靠性的结论。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
Realization of replication mechanism in PostgreSQL DBMS
Nowadays we have a project of a high-performance parallel encrypted database on a cluster platform that will work with large volumes of data. For the smooth operation of the system, a reliable and high-speed data replication mechanism is required which should satisfy certain criteria of PostgreSQL DBMS and the mentioned project. In this article we consider the very essence of data replication, replication strategy, the basic methods and techniques of replication and also made compliance analyses with the replication method for high-performance parallel DBMS on the cluster platform. We also made an experiment to study the reliability and speed of the method for data replication between nodes in the cluster where the work was done with different amounts of the replica and a different nodes number. The aim was to obtain information on the speed of the Slony-I replication method at different volumes of the replicated data and the different number of nodes in the cluster on which we make a conclusion about the reliability of this method in relation to the project mentioned above.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
期刊最新文献
Efficient electric traction drive configuration for battery electric vehicles Experimental study of current error of up to 50 hz current-measuring transformer Designing integrated PV facility with dual-axis solar tracking system mounted on the south building face Key ways of energy saving in pump units for melioration and irrigation systems Justification of wind turbine operation and management modes for russian arctic conditions
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1