基于Kubernetes的容器化数据库及其集群方案

doi:10.11959/j.issn.1000-0801.2018311

Abstract

Abstract:

With the maturity of container technology,more and more internet companies and IT companies have begun to migrate their core business platforms to the container environment.After more than three years of rapid development,Kubernetes has become the industry's preferred container cluster management platform.The containerization scheme of MySQL database and its cluster was given from the perspective of database containerization,based on the analysis of the key technology of database containerization on Kubernetes.Through the evaluation and comparison of performance and reliability of various database models,problems that database containerization technology may encounter and suggestion of database container hosting scheme under different scenarios were proposed.

Key words: database, container, Kubernetes, cluster

CLC Number:

TP399

Liyun YAN,Zhenwei HE,Xinzhang YANG,Ling ZHANG,Shaoxin HOU. Containerizing solution based on Kubernetes of database and its cluster[J]. Telecommunications Science, 2018, 34(12): 163-171.

Figures/Tables 16

References 5

[1]	何宇锋, 林奕琳, 张琳峰 . 容器技术在移动核心网的应用[J]. 移动通信, 2018,42(3): 27-32.
	HE Y F , LIN Y L , ZHANG L F . The application of container technology in the mobile core network[J]. Mobile Communications, 2018,42(3): 27-32.
[2]	龚正, 吴治辉, 叶伙荣 ,等. Kubernetes权威指南（第一版）[M]. 北京: 电子工业出版社, 2016.
	GONG Z , WU Z H , YE B R ,et al. Kubernetes authoritative guide:1st edition[M]. Beijing: Publishing House of Electronics IndustryPress, 2016.
[3]	张勋, 张呈宇, 魏进武 . 一种基于容器编排技术的资源运维系统的设计与实现[J]. 电信科学, 2018,34(6): 162-170.
	ZHANG X , ZHANG C Y , WEI J W . Design and implementation of a resource operation and maintenance system based on container arrangement technology[J]. Telecommunications Science, 2018,34(6): 162-170.
[4]	斯维特·斯米尔诺娃 . MySQL 排错指南[M]. 北京: 人民邮电出版社, 2015.
	SMIRNOVA S . MySQL troubleshooting guide[M]. Beijing: Posts ＆ Telecom PressPress, 2015.
[5]	邱红飞, 李先绪, 黄春光 . 云计算数据库的测试技术研究与应用[J]. 电信科学, 2013,29(10): 16-20.
	QIU H F , LI X X , HUANG C G . Research and application of testing technology of cloud computing database[J]. Telecommunications Science, 2013,29(10): 16-20.

Metrics

Recommended 0

No Suggested Reading articles found!

	单实例数据库	主从数据库集群	主主数据库集群
部署难易程度	简单	较难	较难
读写性能	读性能低，写性能高	读性能高，写性能低	读写性能高
可靠性	低	中	高
适用范围	中小型数据库、可靠性要求低	大型数据库、可靠性要求高	大型数据库、业务可靠性要求高
实例数	1	≥2	≥2

用途	软件项目	版本
操作系统	CentOS 7	1511
文件系统	XFS
容器引擎	Docker	1.12.6
容器集群管理	Kubenetes	1.6.2
网络方案	Flannel(host-gw)	0.5.5
数据库软件	MySQL	5.7
测试工具	SysBench	1.1.0、0.5
数据库集群	主从集群、Galera	5.7
数据库代理	MyCat、service	1.4.3

硬件名称	硬件信息
CPU	Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40 GHz(32核)
内存	128 GB
内核	Linux 3.10.0-327.el7.x86_64
网卡信息	10GE
硬盘	Intel DC S3510 2.5" 800 GB SATA III SSD HP Vk0800geyjt,800.1 GB

故障场景	业务中断时间/s	业务降级时间/s	集群恢复时间/s
主备切换（物理机）	0.5~2	0	30~120
单实例容器恢复	4~7	0	1~3
主主切换（service代理）	1~3	0	30~120
主主切换（MyCat代理）	0	0	30~120

[1]	Haoshuang LIU, Yong ZHANG, Yingbo CAO. Substructure correlation adaptation transfer learning method based on K-means clustering [J]. Telecommunications Science, 2023, 39(3): 124-134.
[2]	Qiaoqiao MA, Ligang DONG, Xian JIANG. Distributed high-efficiency entropy energy-saving clustering routing algorithm for SDWSN [J]. Telecommunications Science, 2023, 39(3): 100-114.
[3]	Ming GAO, Ming LIU, Yangting CHEN, Weiming WANG. Cost optimization model for multi-cloud network based on Kubernetes [J]. Telecommunications Science, 2023, 39(2): 71-82.
[4]	Zhimin HE, Yuzhe LIN, Yujie CHENG, Shi YAN. Downlink wireless resource allocation method of V2X based on wireless sensing assistance [J]. Telecommunications Science, 2022, 38(9): 60-70.
[5]	Haibo ZHAO, Zhijun XIANG, Linsong XIAO. A big data framework for short-term power load forecasting using heterogenous data [J]. Telecommunications Science, 2022, 38(12): 103-111.
[6]	Jiao WANG, Gongan QIU, Shibing ZHANG. Adaptive channel status based access class barring scheme for traffic emergency communication [J]. Telecommunications Science, 2022, 38(1): 95-101.
[7]	Ning JIN, Qingyang WANG. Research on clustering algorithm based 6G typical usage scenarios [J]. Telecommunications Science, 2022, 38(1): 121-131.
[8]	Xie LU, Lei XU, Manjun ZHANG. Safe hierarchical virtual network mapping method based on clustering [J]. Telecommunications Science, 2021, 37(9): 112-117.
[9]	Zihao LIU, Xiaojun JIA, Sulan ZHANG, Zhiling XU, Jun ZHANG. Vibe++ background segmentation method combining MeanShift clustering analysis and convolutional neural network [J]. Telecommunications Science, 2021, 37(3): 133-145.
[10]	Yuting WU, Xuliang WANG, Shuo QUAN. KubeTelecom: a multi-cloud multi-container cluster management and operation engine for 5G network slicing [J]. Telecommunications Science, 2021, 37(12): 72-83.
[11]	Jihua WU, Pengyu ZHU, Zichen WU, Bin GU, Tao HONG, Bo GUO, Jing WANG, Jingyu WANG. Fault diagnosis and auto dispatchin of power communication network based on unsupervised clustering and frequent subgraph mining [J]. Telecommunications Science, 2021, 37(11): 51-63.
[12]	Xiang LI,Yuan LI,Zifei ZHANG,Zhe YANG. A density clustering-based network performance failure big data analysis algorithm [J]. Telecommunications Science, 2020, 36(9): 51-58.
[13]	Gang LU,Changyi CHEN,Zelong HUANG,Zeyuan HUANG. Research on intelligent cloud native architecture and key technologies for cloud and network integration [J]. Telecommunications Science, 2020, 36(9): 67-74.
[14]	Dongliang GUAN. Service platform architecture reconstruction based on microservices [J]. Telecommunications Science, 2020, 36(9): 75-83.
[15]	Danchi HUANG,Zhenwei HE,Liyun YAN,Yuanzhi LIN,Xinzhang YANG. Research and design of multi-tenant scheme for Kubernetes container cloud platform [J]. Telecommunications Science, 2020, 36(9): 102-111.

Containerizing solution based on Kubernetes of database and its cluster

RichHTML

PDF下载

Knowledge

Abstract

Cite this article

share this article

Figures/Tables 16

References 5

Related Articles 15

Metrics

Recommended 0