Storages

[jonnermut]

OpenFGA's PostgreSQL Storage Adapter was purposely built for OpenFGA. Auth0 is not using it in a production environment.
OpenFGA's MySQL Storage Adapter was contributed to OpenFGA by @twintag. Auth0 is not using it in a production environment.

So what does Auth0 use in its production environment? Another adapter that's not part of the open source?

Has anyone taken the MySQL adapter, or the PostgreSQL for that matter, to its limits? Should we be expecting it to be functioning well with millions or billions of tuples?

[aaguiarz]

Hi @jonnermut

Auth0 FGA uses OpenFGA with a Dynamo DB storage adapter, so that multi-region active-active writes can be supported. We are considering open sourcing it too, but we haven’t made a decision yet, initially we wanted the OpenFGA adapters to be for OSS (which DynamoDB is not), which is why we went with Postgres and accepted the MySQL adapter contribution.

The are no theoretical limits on the amount of tuples MySQL/Postgres can handle that are related to how OpenFGA works, and OpenFGA’s core is designed to manage billions of tuples, it is on the implementer to manage scaling, partitioning and sharding the datastore though.

In practice, Auth0 is not using the Postgres or MySQL datastores with a production-like constant workload. Until we get data from production OpenFGA deployments, we won’t know how the product will actually behave under those conditions.