Hi,

What would be a current recommended Hibernate strategy database horizontal scaling (tens of terabytes of data)? My research led me to the Hibernate shards project but it seems to have stalled and no one else picked up after Google guys abandoned the project. I also read about multi-tenancy and how it is well suited for P/SaaS environments. Although I understand the original use case for multi-tenancy I wanted to ask you if it makes sense to use multi-tenancy to implement horizontal scaling instead of using shards? If database is relatively simple, denormalized, all data is centered around one main entity abstraction (say customer) and you never need cross tenant union queries then multi-tenant database approach can be used to scale out horizontally, right?

I dug a bit more and I noticed that although database multi-tenancy works with native Hibernate, it does not work well with JPA (see https://hibernate.onjira.com/browse/HHH-7312). Any updates on this?

Are there any plans to implement data partitioning on top of JPA similar to http://wiki.eclipse.org/EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Data_Partitioning


All the best