Is supertokens horizontally scaleable

Question

rp · Answer

Yea You can deploy how many ever cores you need to They are all stateless and can add a load balancer in front of them that does a round robin style query to them

joeldesante · Answer

Awesome thanks

rp · Answer

The only limitation is that they all need to be connected to one instance of a sql db

joeldesante · Answer

Right okay

joeldesante · Answer

If that database was sharded in some way Im sure that would still count as 1 instance right

rp · Answer

well you would have to handle the querying to hit the right shard If you can do that and do it in a way that s transparent to the core that would work If you are doing that i d be interested in knowing how also it may get tricky since you would sometimes have to do a transaction across shards

joeldesante · Answer

thanks for the info

michaelgrigoryan25 · Answer

< rp> maybe the postgres driver that you use is also compatible with Cockroachdb

michaelgrigoryan25 · Answer

CockroachDB supports postgres syntax but is much more scalable

rp · Answer

We do have people use the sessions + passwordless recipe for cockroach db

rp · Answer

But we haven t tested it extensively with that db yet So no guarantees from our side

rp · Answer

And we r working on generic sql support which would work with cockroachdb and others reliably