A method for multi-tenant shared database and multi-tenant database as a service system

Abstract

The invention discloses a multi-tenant database as-a-service system. The multi-tenant database as-a-service system comprises an application layer module for receiving a client-side instruction, establishing and maintaining logical database information of tenants and sending a first instruction to a data management layer module, the data management layer module for establishing and maintaining mapping of the logical database information of an application layer to physical database instance information of an infrastructure layer according the first instruction and sending a second instruction to an infrastructure layer module, and the infrastructure layer module for establishing physical database instances of the infrastructure layer according to indication of the second instruction based on a virtual machine or performing data operation on the physical database instances according to the indication of the second instruction. The multi-tenant database as-a-service system can achieve performance isolation of the tenants and ensures the performance demands of the tenants. The invention further provides a multi-tenant database sharing method.

Description

technical field [0001] The present invention relates to the technical field of cloud computing, in particular to a multi-tenant shared database method and a multi-tenant database as a service DBaaS (Database as a Service) system. Background technique [0002] With the development of cloud computing technology, operating systems, middleware and applications in the traditional software layer stack have found their place in the cloud, and infrastructure as a service (IaaS), platform as a service (PaaS) and software as a service (Software as a service) have emerged. SaaS) model. In fact, databases that carry information are also very suitable for building in cloud data centers. Traditional database hosting services deploy tenants' databases in units of physical machines. With the deepening of applications, problems such as unbalanced resource utilization and difficult maintenance and management are exposed. Centrally hosting the databases of each tenant in the database as a se...

AI Technical Summary

Problems solved by technology

The existing shared database solution enables the databases of multiple tenants to coexist on the same database engine on the same server. Although it can improve resource utilization, the performance isolation of tenant databases cannot be guaranteed, and the request load of some tenants may occupy most of the system resources, causing resource hijacking

[0004] Therefore, in the existing multi-tenant database as a service DBaaS system, tenants interact with each other, and the performance requirements of tenants are not effectively guaranteed

Images