:wave: Hey, I was wondering, what are your insight...
# ory-selfhosting
f
👋 Hey, I was wondering, what are your insights on removing foreign keys on hydra tables? We are working on integrating hydra as an Oauth2 server in our system and our user count are in hundreds of millions, so to support those amounts we use sharding, but on DB, that uses FK, that, at the very least, would be inefficient, but most likely impossible.
m
Hello @few-state-46898 Ory offers the Ory Enterprise License for companies that run Ory Hydra in high-scale, business-critical environments. The OEL also comes with support by the Ory maintainers. The OEL version of Ory Hydra is specifically designed for such large-scale use cases and you can make use of our years-long experience of running it for many millions of users. I would very strongly suggest you talk to us about purchasing a license if you plan to use Hydra in such a large scale system. The OSS version is provided as is, without any guarantees, and community support can't help with a use case like this. You can read a bit about OEL here: https://www.ory.sh/docs/self-hosted/oel/quickstart