The Design And Implementation Of DBaaS Service Of Private Cloud Platform

The development of cloud computing enables users to obtain self-service IT resources through the network.With the help of virtualization technology,users don't need to focus on specific hardware,but only need to choose a cloud service provider.They need to log on the cloud platform to purchase and configure the services they need.Such a choice is highly scalable,more economical,and the resource utilization has been significantly improved.Thanks to the development of cloud computing,database technology has also begun to transform from traditional IT to the cloud platform.The database under traditional IT needs to be configured by administrators.Database management needs to be handled by a professional DBA.The database needs to be deployed on a large machine.DBaaS(Database as a Service)based on cloud computing can provide self-service configuration.Developers can manage their own database services and deploy them on virtualized machines.In order to meet the needs of using DBaaS services on private cloud platforms for users,the thesis implements DBaaS module of the cloud platform based on H3 C private cloud platform and OpenStack Trove components.The DBaaS module on the platform can manage the life cycle of cloud database instances and databases of the instances.The thesis first analyzes the needs of users who manage cloud databases,the DBaaS module needs to provide a scalable and reliable cloud databases to them.Then the thesis introduces the architecture of the current private cloud platform and the DBaaS back-end solution which be adopted.The author mostly analyses the principle of creating database instances by OpenStack Trove components and combines with the cloud platform to complete overall design.Then the DBaaS module on the cloud platform is designed and implemented in detail.Because the DBaaS module involves the call and data combination of multiple services,so during the realization of code,the combined asynchronous programming methods provided by Java8 are used to run concurrent tasks.Since the state of the database instance cannot be pushed to the front-end page in real time,the thesis proposes a state-based push scheme based on WebSocket to solve this problem.Finally,the DBaaS module provided by the cloud platform has been systematically tested.Therefore,it is concluded that the DBaaS module can support multiple database types and versions.Users can configure them according to their own requirements and manage the databases and users in the database instance.