Hybrid Multitenancy in Reactive using Flyway

[humcqc]

Hello,

I have a requirement to be able to store:

• small tenants with Discriminator strategy,
• some medium tenants into different schemas,
• and the biggest in different databases.
  And this dynamically if possible.

On the same time I would like to:

• implement my services in reactive
• use flyway for the db migration

After some discussion with @yrodiere on #32686, I would like to use this place to discuss if this is something doable , the possible design, the current issues, and what should be done.

List of issues found:

• Support for multi tenancy column discriminator  #28644
• Quarkus 3 native image fail to start with NoSuchMethod Exception #34443
• 3.1.1 Final - java.lang.IllegalArgumentException: Class java.util.UUID[] is instantiated reflectively but was never registered #34071
• Hibernate reactive + Flyway extension causes UnsatisfiedResolutionException #10716
• Support of Embedded and ManyToOne nested object projection + Support of @ProjectedFieldName on class fields #36581
• Multitenancy for Hibernate Reactive #15959
• Hibernate ORM and Hibernate Reactive cannot be used in the same application #13425
• Multiple Users for multiple Schemas flyway/flyway#1308
• Support multiple persistence units for Hibernate Reactive #21110
• Rewrite Hibernate Reactive extension to decouple it from Hibernate ORM and use a common base instead #28629

Following some answers in those issues, it seems there is a discussion on Reactive design , if there is some others known issues I can subscribe to see the direction of this I will be interested.

@yrodiere do you have some idea ?

[yrodiere]

Hi,

I don't really deal with Hibernate Reactive on a daily basis, so I'm not fully aware of what it can and cannot do.

However, I would imagine the problem is pretty close to what it would be in Hibernate ORM. As I mentioned in #32686:

The first step would be to check whether it's possible in Hibernate ORM itself, without Quarkus. If it is, then I think we should be able to make it work simply by making the "multitenancy" configuration property multi-valued.

And the best person to ask whether such hybrid multitenancy can work (especially in Hibernate Reactive) would probably be @gavinking.

[gavinking]

I mean the latest release of HR is based on H6, which has discriminator-based multitenancy via the @TenantId annotation.

And for schema/catalog-based multitenancy, there's the documented solution of extending DefaultSqlClientPool.

[P.S. hibernate.multiTenancy no longer exists in H6, the HR docs still need to be updated.]

So anyway, I'm not sure what's missing.

Have you tried it?

[humcqc]

Seems blocked by #15959

What do you recommend for the optimal way for multitenancy in quarkus ?

• waiting for reactive fix
• using DefaultSqlClientPool
• using virtual thread in orm way