SaaS multi-tenant [database isolation]

0. Extremely fast experience ① Clone the https://gitee.com/zhijiantianya/ruoyi-vue-pro (opens new window) repository and switch to the feature/dev-yunai branch. ② Create ruoyi-vue-pro-master, ruoyi-vue-pro-tenant-a, ruoyi-vue-pro-tenant-b Three databases. ③ Download multi-tenant multi-db.zip and unzip it, and import SQL into the corresponding database. friendly reminder: SQL scripts may become outdated as versions are released. If you encounter any problems, […]

Typical scenario | How PolarDB-X supports SaaS multi-tenancy

SaaS multi-tenant background For many platform applications or systems (such as e-commerce CRM platforms, warehouse order platforms, etc.), their service models are developed around the user dimension (the user dimension here can be a seller or brand, a warehouse, etc.) . Therefore, for this type of platform business, in order to support the horizontal scalability […]

Under the SaaS mode, multi-tenant system data isolation implementation scheme

1. Background Friends who have developed the SaaS system platform must be familiar with the concept of multi-tenancy. Simply speaking, a tenant is a company customer, and multiple tenants share the same SaaS system. Once the SaaS system is unavailable, all tenants are unavailable. You can understand that the SaaS system is like a building, […]

Under the SaaS mode, multi-tenant system data isolation implementation scheme

1. Background Friends who have developed the SaaS system platform must be familiar with the concept of multi-tenancy. Simply speaking, a tenant is a company customer, and multiple tenants share the same SaaS system. Once the SaaS system is unavailable, all tenants are unavailable. You can understand that the SaaS system is like a building, […]

SaaSMulti-tenant system design

Article directory Multi-tenant system design 1. SaaS system classification 2. The application must support multi-tenancy 3. Data isolation scheme 3.1. Independent application and independent library 3.2. The same application, one library per tenant 3.3, the same application, the same database 3.4. Fragmentation multi-tenancy 4. Our Model Selection 4.1. Development practice 4.2, metadata/configuration driver refer to […]

Analysis on the implementation scheme of data isolation in SaaS multi-tenant system

1. Background Friends who have developed the SaaS system platform must be familiar with the concept of multi-tenancy. Simply speaking, a tenant is a company customer, and multiple tenants share the same SaaS system. Once the SaaS system is unavailable, all tenants are unavailable. You can understand that the SaaS system is like a building, […]

JFlow Workflow SaaS Org Mode Integration

JFlow workflow SAAS mode access guide 1. Installation Guide Initialize database script Create JFlow database: Example: jflow Download the initialization sql file, download address: https://gitee.com/opencc/JFlow/attach_files Run the SQL file to initialize the database table structure Idea runs JFlow Download JFlow code, download link: https://gitee.com/opencc/JFlow Open JFlow through Idea and import maven project Set up the […]

This is how the data permissions of large SaaS systems should be designed

ToB’s system, in addition to ordinary permission management, often requires data scope permissions. This article introduces a simple design and implementation of a simple and easy-to-implement Saas multi-tenant data scope permission system. Overview of permissions When we generally talk about permissions, we mean “function permissions and data permissions”. Functional permissions refer to “what modules and […]