The Design and Implementation of Cloud Database Service based on MySQL

• 1、State Key Laboratory of Networking and Switching Technology,Beijing University of Posts and Telecommunications

Abstract：Cloud computing is a new way to share infrastructure. It puts huge resources together into a pool to provide various IT services, which brought significant changes in information technology. One of the typical business models is to provide server platforms or development environment as products to users, which is called PaaS, namely Platform-as-a-Service. Generally speaking, DaaS--Database-as-a-Service is a basic capacity of PaaS. It means the developers do not need to understand the specific way to achieve database service. As long as you can access the Internet, the high-available and high-extensive database is available. In this case, DaaS platform is based on MySQL Database.To ensure good user experience, DaaS provides service isolations in performance and data-storage. In terms of system architecture, the platform is based on a hierarchical structure. There exists a layer of proxy between MySQL clients and the MySQL-server layer, which is called MySQL-Proxy. With the proxy layer, the system can not only switch to the backup server quickly when the current server fails, which ensures high availability of the database service, but also implement the size restriction of each user, which ensures safety of the database service.

Keywords： PaaS DaaS MySQL multitenant high availability