Multi-tenant data isolation method and system based on tenant attributes

Abstract

The invention relates to a multi-tenant data isolation method and system based on tenant attributes. The method comprises the steps of: presetting multiple tenant types for the system; correspondinglyinstalling a database according to the plurality of tenant types; obtaining a tenant type selected by a tenant during system registration; classifying the tenants according to the selected tenant types; selecting corresponding databases according to the tenant types of the classified tenants, wherein each type of tenants share the database corresponding to the tenant type; and creating Schema foreach tenant for storing tenant data. According to the method, the installation number of databases can be reduced, and the recovery and backup difficulty is reduced.

Description

technical field [0001] The invention relates to the field of cloud computing, in particular to a method and system for multi-tenant data isolation based on tenant attributes. Background technique [0002] Multi-tenancy technology, or multi-tenancy technology, is a software architecture technology that realizes how to share the same system or program components in a multi-tenant environment, and can ensure the isolation of data between tenants. In the current era of cloud computing, multi-tenant technology provides the same or even customizable services for most clients with a single system architecture and services in a shared data center, and can still guarantee the isolation of customer data. At present, various cloud computing services are such technical categories, such as Alibaba Cloud Database Service (RDS), Alibaba Cloud Server, and so on. [0003] At present, there are three main solutions for multi-tenant data storage, namely: [0004] Option 1. Independent databa...

AI Technical Summary

Problems solved by technology

[0007] Disadvantages: Increase the number of database installations, resulting in increased maintenance costs and acquisition costs

[0011] Disadvantages: If a failure occurs, data recovery is difficult, because restoring the database will involve the data of other tenants; if cross-tenant statistics are required, there are certain difficulties

[0015] Disadvantages: The isolation level is the lowest, and the security is the lowest. It is necessary to increase the amount of security development during design and development; data backup and recovery are the most difficult, and it needs to be backed up and restored table by table.

Images