nav emailalert searchbtn searchbox tablepage yinyongbenwen piczone journalimg journalInfo journalinfonormal searchdiv searchzone qikanlogo popupnotification paper paperNew
2015, 02, v.31;No.262 61-64
基于MySQL分布式数据库系统同步分析与实现
基金项目(Foundation):
邮箱(Email):
DOI:
发布时间: 2015-02-20
出版时间: 2015-02-20
移动端阅读
摘要:

数据库一般被定义为关联数据组织起来的一个集合,即一个组织化和系统化的数据存储表,表格中的行和列系统性和关系性地组织起来,以方便数据保存与访问。在数据库在没有进行规范的前提下,表格没有索引,数据库表格包含有重复记录,这增加了冗余数据。对此,通过规范数据库和索引方式,可以消除并提高搜索速度和优化检索。论文以数据库研究为背景,通过实际应用,分析并实现了基于My SQL分布式数据系统中的数据同步技术。

Abstract:

By definition database is considered to be broad and quite complicated in academia. It is defined as a collection of organized and related data. Other studies indicate that database is a system that stores data in quite an organized and systematic manner in form of tables. The tables are organized in a systematic manner of columns and rows which helps in holding data. In case the database is not normalized and tables are not indexed, the database willcontainduplicate records in tables. This paper is a research based on My SQL replication application. It used new database replication technology "transaction" to solve the problem of My SQL replication.

参考文献

[1]Vaswani,V.(2010).My SQL database usage&administration(1st ed.)[M].New York:Mc Graw-Hill.

[2]Zhiyuan,S.,Hai,J.,&Xiaohui,T.(2005).High performance and high availability My SQL server cluster based on active TCP connection replication[J].Journal Of Computer Research And Development,6,015.

[3]Howtoforge,.(2014).How To Set Up Database Replication In My SQL,Howto Forge-Linux Howtos and Tutorials.Retrieved 21 June 2014,http://www.howtoforge.com/mys ql_database_replication

[4]Du Bois,P.(2009).My SQL(1st ed.).Upper Saddle River,[M].NJ:Addison-Wesley.

[5]Box,D.,Kumar,A.,Maksimovic,P.,Gallas,E.,Guo,Y.,&Litvintsev,D.et al.(2004).Database usage and performance for the Fermilab Run II experiments(1st ed.).[M].Washington,D.C.:United States.Dept.of Energy.

[6]Chenghao,Q.(2009).A Database Cluster Solution Based on My SQL Replication[J].Computer&Telecommunication,8,023.

[7]Drassignment.com,.(2014).Assignment&Essay Writing Help,Auto Assignment Writer.Retrieved 21 June 2014,http://www.drassignment.com/assignment-master-1.html?sid=53a51a9adf5d8.

基本信息:

中图分类号:TP311.13

引用信息:

[1]SIYOMVO SYLDIE.基于MySQL分布式数据库系统同步分析与实现[J].微型电脑应用,2015,31(02):61-64.

发布时间:

2015-02-20

出版时间:

2015-02-20

检 索 高级检索

引用

GB/T 7714-2015 格式引文
MLA格式引文
APA格式引文