I am trying to understand how multi tenancy with shared engine and multi schema is working.
I am using MultiSchemaMultiTenantProcessEngineConfiguration. The main purpose is to be able to encrypt data which can easily be done by using individual schemas.
Each tenant’s data is managed in an own db schema. From my understanding this also includes the runtime data e.g. current running processes etc. This would also mean there is no shared table to managed this and it would need to read from each tenant schema whether something needs to be done. From looking at the code there will even be a thread started for each node (SharedExecutorServiceAsyncExecutor).
This seems to me it would not scale well with a lot of tenants. Does anyone has experiences running in such a setup or is there any other way to avoid this?