MultiTenancy

There are several multitenancy models around https://vladmihalcea.com/database-multitenancy/

1. Dedicated DB per tenant
2. Shared DB, but one schema per tenant
3. Shared schema with tenantId discriminator column per table

Are there any plans to support these scenarios conveniently with Spring Data JDBC?

Option 1 and 2 are probably tackled by multiple datasources/connection-pools support https://github.com/spring-projects/spring-data-jdbc/issues/544. Regarding option 3 it would be required to automatically inject the tenantId from the thread context into the statement.

I'm using Spatie's mutlti-tenancy package to implement multi-tenancy on my app. I'm using the multiple database approach, and at the moment I'm unsure what should go in my .env file, so I've got DB_DATABASE=landlord in there to point to my landlord database. I then use the DomainTenantFinder and it works quite well. I do have an issue though, usually when I want to indicate a model should use the tenant database connection, I include the following in the model:

I am trying to set-up schema multitenancy in my webapp using Hibernate. I've followed some tutorials and i've come to: implement my own MultiTenantConnectionProvider
implement my own CurrentTenantIdentifierResolver
implement TenantContext change HibernateConfig

I have a default public schema and some schemas per tenant (the public schema has a table with all the tenants).
In short, what i am trying to do now is:

1. recive tenantId via API,
2. query the public.tenants table and control if tenant is enabled
3. if tenant is enabled, query a certain table from his schema

Right now i am stuck at changing from public to tenant schema.

What worked for now is to modify the method MultiTenantConnectionProvider.getConnection, in order to set the tenant before executing the query, then get the tenant directly from the context. Example

In that case i am not using the tenantIdentifier parameter but i try to get the tenant directly from the context. It works only if i don't query the public schema first but just set tenant and execute the query on the tenant schema.

If i execute a query on the public schema first then change the tenant, my solution doesn't work anymore, because spring uses the same connection for both queries.

Do you have any advices?

I'm trying to develop a multitenancy app with quarkus, hibernate-reactive and postgres.

Hibernate-reactive supports multitenancy by letting implement ReactiveConnectionPool :

http://hibernate.org/reactive/documentation/1.0/reference/html_single/#_custom_connection_management_and_multitenancy

Defining hibernate.vertx.pool.class in application.properties seems to be ignored.

Is this feature of hibernate-reactive integrated in quarkus ?

Has anyone used this feature before?

In a Multitenancy B2C application, the interface created by the Application Startup Template applies well to the backoffice, but for the storefront website I think it would be necessary to create a blank UI project (angular or MVC).

What would be the best practice for keep the ABP infrastructure that provides functionality such as customization by Tenant, Tag Hellpers, Proxies, Localization, etc. Without bringing unnecessary dependencies such as JS libraries and other components like menus, datatables, sidebars?

Currently I am trying to implement multitenancy in an OAuth2 secured application by using one Keycloak realm for each tenant. I am creating a prototype in Go but am not really bound to the language and could switch to Node.js or Java if I needed to. I figure that my following question would hold true if I switched language though.

At first, implementing multitenancy seemed pretty straight forward to me:

• For each tenant, create a realm with the needed client configuration for my backend application.
• The backend receives a request with the URL tenant-1.my-app.com. Parse that URL to retrieve the tenant to be used for authentication.
• Connect to the OAuth2 provider (Keycloak in this case) and verify the request token.

Following a guide, I use golang.org/x/oauth2 and github.com/coreos/go-oidc. This is how I setup the OAuth 2 connection for a single realm:

I'm setting up a new project with Entity Framework Core 5 and Postgres. All my project and my context are in the same project.

When adding a migration, I'm getting this error:

/src/Api.csproj : error MSB4057: The target "GetEFProjectMetadata" does not exist in the project. Unable to retrieve project metadata. Ensure it's an MSBuild-based .NET Core project. If you're using custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option.

EF Core version: 5.0.1 Target framework: net5.0

These are all the commands I tried:

I'm testing Hibernate Search 6 multitenancy with Hibernate (referred to this link) and got error message "HSEARCH000520: Hibernate Search encountered failures during bootstrap", with additional detail, "HSEARCH600029: Invalid backend configuration: index 'Users' requires multi-tenancy but no multi-tenancy strategy is set".

I apply to my Users entity. Here is the Users entity class.

as a requirement I have a spring boot project that uses multi tenant based on schema, when I run the application the migration goes fine on master schema(public), but when it tries to apply changes to all tenants (other schemes) it returns an exception that the table from sql script already exists even if the schema is empty: