计算机技术与发展2018，Vol.28Issue(3)：42-46,5.DOI:10.3969/j.issn.1673-629X.2018.03.009
表广播机制在MyCat中的实现
Realization of Table Broadcasting Mechanism in MyCat
摘要
Abstract
The storage and access of massive data is the bottleneck of system design and use.The MyCat,an open source distributed stor-age database,makes the different tables mapped to different data engines through the horizontal segmentation of the data,which realizes the capacity extension of database logically.However,when using the data manipulation language (DML) to access the global table of MyCat,if a node is disconnected due to an abnormal situation,it may lead to the inconsistencies in the number of different sub-library da-ta.For the problem of weak distributed transaction in MyCat distributed database middleware,we put forward a kind of solution about ta-ble broadcast mechanism.By changing the execution logic of the global table while the original MyCat accessing to the DML,the pro-gram changes the operation of all nodes to that of the master node,and implements the data consistency between the nodes by data syn-chronization between the nodes of the table broadcast mechanism.Then the MyCat is tested by common DML accessing to achieve the da-ta in MyCat database of table broadcast mechanism,which shows that the table broadcast mechanism based on the MyCat is efficient in SQL and also guarantees the data consistency between the nodes.关键词
表广播/MyCat/分布式数据库/数据库中间件Key words
table broadcast mechanism/MyCat/distributed database/database middleware分类
信息技术与安全科学引用本文复制引用
王锦,梁正和,王法强..表广播机制在MyCat中的实现[J].计算机技术与发展,2018,28(3):42-46,5.基金项目
国家自然科学基金(61272543) （61272543）
