Since July 16, 2024 The druid-multi-tenant-starter plugin has been released for more than two years. The launch of this new tool marks the birth of an efficient and convenient SaaS multi-tenant management solution, providing developers with a brand new convenient experience.
druid-multi-tenant-starter is a multi-tenant plugin based on MyBatis interceptor and alibaba Druid SQL parser. It aims to simplify multi-tenant management in SaaS (Software as a Service) platforms and provides an out-of-the-box, easy-to-configure solution that enables developers to easily implement multi-tenant data isolation and management.
Seamless Integration: As an out-of-the-box plugin, druid-multi-tenant-starter can be perfectly integrated with the existing MyBatis framework, avoiding cumbersome configuration and code modification. Only a small amount of configuration is required to enable multi-tenant functionality, greatly improving development efficiency.
Powerful SQL Parsing: Utilizing the powerful SQL parsing ability of Alibaba Druid, druid-multi-tenant-starter can accurately parse and process SQL statements, ensuring data isolation and security in multi-tenant environments. Whether it's a query, update, or deletion operation, it can be effectively managed and controlled.
Flexible Tenant Management: The plugin provides a variety of flexible tenant management strategies, allowing developers to define and adjust tenant identification methods according to actual needs. This makes it adaptable to different application scenarios and provides personalized solutions.
Performance Optimization: druid-multi-tenant-starter parses SQL statements based on the alibaba Druid SQL parsing library, and its performance is stronger than that of a certain tenant plugin which parses SQL statements based on JSQLParser.
SaaS Application Platform: druid-multi-tenant-starter is particularly suitable for SaaS platforms that need to support multiple tenants. It can ensure the data security and isolation of different tenants and prevent data crossover and leakage.
Enterprise-level System: For enterprises that need to manage data of multiple business units or subsidiaries in the same system, druid-multi-tenant-starter provides an ideal solution, simplifying data management and maintenance work.
Data Sharing Platform: In scenarios where multi-party data sharing is required while ensuring data isolation, druid-multi-tenant-starter can effectively support the management needs of different data sources.
table name to ignore the addition of the tenantId field condition in the SQL statement.alias to ignore the addition of the tenantId field condition in the SQL statement.Mybatis project.<dependency> <groupId>io.github.osinn</groupId> <artifactId>druid-multi-tenant-starter</artifactId> <version>1.4.7</version></dependency>--Basic configurationmybatis: tenant: config:# Whether to enable the multi-tenant pluginenable: true# The column name of the tenant ID in the databasetenant-id-column: tenant_id/** * Demonstration: Provide the service interface of multi-tenant ID * * @author wency_cai */@Servicepublic class TenantServiceImpl implements ITenantService<Integer>{ @Override public List<Integer> getTenantIds() { // Query the multi-tenant id in the system. If there are multiple, return multiple values. int tenantId = 1; return Lists.newArrayList(tenantId); }}The druid-multi-tenant-starter has been running normally in the production environment for more than two years since its release. It not only simplifies the development work in the multi-tenant environment but also improves the performance and security of the system. We look forward to this plugin helping more developers and enterprises manage their multi-tenant systems efficiently and achieve rapid business development and success.
Project address: Click