计算机与现代化 ›› 2011, Vol. 1 ›› Issue (8): 153-156,.doi: 10.3969/j.issn.1006-2475.2011.08.042

• 数据库 • 上一篇    下一篇

虚拟化环境下的数据库集群系统构建与性能分析

刘 宇   

  1. 河南大学计算机与信息工程学院,河南 开封 475004
  • 收稿日期:2011-04-18 修回日期:1900-01-01 出版日期:2011-08-10 发布日期:2011-08-10

Construction and Performance Analysis of Database Cluster System in Virtual Environment

LIU Yu   

  1. College of Computer and Information Engineering, Henan University, Kaifeng 475004, China
  • Received:2011-04-18 Revised:1900-01-01 Online:2011-08-10 Published:2011-08-10

摘要: 基于物理主机的数据库集群配置和管理存在配置复杂、灵活性差的问题。虚拟化技术结合集群系统管理使系统管理和资源构建更加灵活透明。本文提出一种基于Xen Server虚拟化平台的MySQL Cluster数据库集群系统配置部署方案,并对比MySQL 5.1单机版测试数据对系统性能进行分析。本文提出的方案不但利用虚拟化平台虚拟机快速复制功能有效降低数据库集群系统部署的复杂度,提高配置的灵活性,且与大并发和大数据量的处理能力相比MySQL 5.1单机版具有较高的性能优势。

关键词: 虚拟化, 分布式系统, 数据库集群, 虚拟化基础设施

Abstract: The configuration and management of database cluster based on physical host have the problem of complex configuration and poor flexibility. Virtualization technology combined with cluster system management makes the system management and resource construction more flexible and transparent. This paper presents Xen Server virtual platform and MySQL database cluster system based concept proof scheme. The performance of the system is analyzed by comparing with the testing data of MySQL 5.1 single server version. The solution proposed in this paper not only reduces the complexity of database cluster system deployment through using the rapid replication function of virtual platform, improves the flexibility of configuration, but also has higher performance advantage in concurrency and massive data processing compared to MySQL 5.1 single server version.

Key words: virtualization, distributed system, database cluster, virtual infrastructure

中图分类号: