High Performance and High Availability MySQL Server Cluster Based on Active TCP Connection Replication

Shao Zhiyuan, Jin Hai, and Tang Xiaohui

Journal of Computer Research and Development > 2005 > 42(6): 1006-1012.

Shao Zhiyuan, Jin Hai, and Tang Xiaohui. High Performance and High Availability MySQL Server Cluster Based on Active TCP Connection Replication[J]. Journal of Computer Research and Development, 2005, 42(6): 1006-1012.

Citation:

PDF (357 KB)

High Performance and High Availability MySQL Server Cluster Based on Active TCP Connection Replication

Shao Zhiyuan, Jin Hai, and Tang Xiaohui

(Computer College, Huazhong University of Science and Technology, Wuhan 430074)

More Information

Published Date: June 14, 2005

Graphical Abstract

Abstract

Abstract

In this paper, a scheme is presented, which builds high performance and high availability database cluster by using actively replicated TCP connections. The scheme forwards a technique that actively replicates a set of TCP connections by converting them into atomic multicasting and distributing read-only requests to different processing units. The technique is further used on MySQL database clusters and results in high performance and high availability. With the experiments conducted on the prototype systems, high performance on read-only database queries with little sacrifice on the update operations of the cluster is exhibited.
- fault-tolerant computing,
- high availability,
- TCP protocol,
- cluster computing,
- database systems

FullText(HTML)

References (0)

[1]	Li Song, Cao Wenqi, Hao Xiaohong, Zhang Liping, Hao Zhongxiao. Collective Spatial Keyword Query Based on Time-Distance Constrained and Cost Aware[J]. Journal of Computer Research and Development, 2025, 62(3): 808-819. DOI: 10.7544/issn1000-1239.202330815
[2]	Wang Pan, Yang Pingli, Huang Shaohua, Lin Chengdi, Kong Longxing. A Direct Send Image Compositing Algorithm with Minimal Communication Costs[J]. Journal of Computer Research and Development, 2018, 55(4): 885-892. DOI: 10.7544/issn1000-1239.2018.20160875
[3]	Zhou Yuhang, Zhou Zhihua. Cost-Sensitive Large Margin Distribution Machine[J]. Journal of Computer Research and Development, 2016, 53(9): 1964-1970. DOI: 10.7544/issn1000-1239.2016.20150436
[4]	Liu Yue, Li Jintao, Hu Songlin. A Cost-Based Splitting Policy Search Algorithm for Hive Multi-Dimensional Index[J]. Journal of Computer Research and Development, 2016, 53(4): 798-810. DOI: 10.7544/issn1000-1239.2016.20151163
[5]	Guo He, Chen Zheng, Yu Yulong, Wang Yuxin, Chen Xin. A Communication Aware DAG Workflow Cost Optimization Model and Algorithm[J]. Journal of Computer Research and Development, 2015, 52(6): 1400-1408. DOI: 10.7544/issn1000-1239.2015.20140205
[6]	Zong Ming, Wang Xiaodong, and Zhou Xingming. Cost-Optimizing Adaptive Location Service Protocol in MANET[J]. Journal of Computer Research and Development, 2012, 49(12): 2515-2528.
[7]	Lu Min, Huang Yalou, Xie Maoqiang, Wang Yang, Liu Jie, Liao Zhen. Cost-Sensitive Listwise Ranking Approach[J]. Journal of Computer Research and Development, 2012, 49(8): 1738-1746.
[8]	Liu Cancan, Zhang Weimin, Luo Zhigang, and Ren Kaijun. Temporal Consistency Based Heuristics for Cost Optimization in Workflow Scheduling[J]. Journal of Computer Research and Development, 2012, 49(6): 1323-1331.
[9]	Wang Weizheng, Kuang Jishun, You Zhiqiang, Liu Peng. A Low-Power and Low-Cost BIST Scheme Based on Capture in Turn of Sub-Scan Chains[J]. Journal of Computer Research and Development, 2012, 49(4): 864-872.
[10]	He Xiaoyang and Wang Yasha. Model-Based Methods for Software Cost Estimation[J]. Journal of Computer Research and Development, 2006, 43(5): 777-783.