SaaS application based global configuration multi-tenant dynamic data source system

Abstract

The invention discloses a global configuration based multi-tenant dynamic switching data source system. The data source system mainly includes: isolating tenant data according to database rank; sharing a connection pool, wherein the connection number is controllable; supporting a database mapping of a specific tenant or a specific application; monitoring configuration information change in real time, and dynamically adjusting linkage information; solving the problem that similar information of multiple tenants are stored in the same two-dimensional table, and the maintenance difficulty is large; solving the problem that service data is isolated logically, and is not isolated physically; solving the problem that recovery of a database will affect all the tenants while data of a certain tenant is wrong; solving the problem that all the user accesses are affected while a single set database server goes down; solving the problem that a database connection pool is not controllable, and there is no an independent database service for the specific tenant or a specific user; overcoming the defect that a tenant data isolation problem and a connection pool problem cannot be dealt in a simple manner; and the implementation manner of a dynamic data source can be simplified.

Description

technical field [0001] The present invention relates to the technical field of multi-tenant scenarios in J2EE applications or SaaS cloud applications, and in particular to a globally configured multi-tenant dynamic data source system based on SaaS applications. Background technique [0002] In more and more J2EE applications or SaaS cloud applications, multi-tenant scenarios are often involved, such as B2B business. In business applications, both storing and obtaining data should be distinguished according to the tenant information to which the user belongs to avoid confusion and influence of data between tenants. [0003] For the two-dimensional table data of the database, usually in the case of a single database, the method of adding the tenant code field to the database table is adopted. When the application performs data query and update, it also needs to carry tenant information to ensure the correctness of the data. In each database table, a tenant ID (tenantid) is st...

AI Technical Summary

Problems solved by technology

Although the solution has data isolation, the effect of isolation is not good

[0007] In the existing technology, similar information of multiple tenants is stored in the same two-dimensional table, which is difficult to maintain in the later stage; business data only achieves logical tenant isolation, not physical isolation; when a tenant data error occurs, the recovery of the database affects all Tenants; when a single group of database servers goes down, access by all tenants is affected

At the same time, the database connection pool is uncontrollable, there is no independent database service for special tenants or special uses, and the problem of data grid and connection pool between tenants cannot be dealt with in a concise way. The implementation process of dynamic data sources is complicated

Images