The Design And Implementation Of Cloud Database Base On MySQL

Cloud database is a product of traditional database technology combined with cloud computing,it can provide database resource virtualization, and has on-demand, dynamic expansion, high availability. In recent years, the rapid development of cloud database technology, more and more enterprises, institutions, organizations move databases to the cloud, so the demand for building cloud database is also increasing.Cloud database currently on the market most of the public cloud environment to build, but a private cloud database also has a great market demand. In this paper, by studying OpenStack and cluster management technology, analysis SaltStack automated deployment and hot standby high availability architecture feasibility cloud database design, proposed to build a cloud database solution in a private cloud environment, the program has better ease of use and reliability, and supports MySQL relational database engine.Firstly, in this issue, it introduces the concept of cloud computing and cloud database and the development of status quo, analysis of key technologies to build cloud database. By analyzing the actual usage scenarios cloud database, developed a demand cloud database functionality and reliability, and gives a detailed description of the requirements.Secondly, divide the cloud database system module, from the physical structure and logical structure two aspects to develop a deployment plan for each module and logic design. In order to improve the usability and reliability of the system, the author proposes to SaltStack-based automated deployment design and based on the shared storage high availability cluster architecture.Thirdly, given the realization of the cloud database project the main functional requirements,design and gives each function workflow and specific implementation. Lastly, by building the cloud database test environment based on MySQL, test the project’s main features and high-availability solutions, verify the functionality and ease of use and reliability of the cloud database system.