https://supertokens.com/ logo
#general
Title
# general
j

joeldesante

04/10/2022, 6:47 PM
Is supertokens horizontally scaleable?
r

rp

04/10/2022, 6:48 PM
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
j

joeldesante

04/10/2022, 6:48 PM
Awesome thanks!
r

rp

04/10/2022, 6:48 PM
The only limitation is that they all need to be connected to one instance of a sql db
j

joeldesante

04/10/2022, 6:48 PM
Right okay
If that database was sharded in some way Im sure that would still count as 1 instance, right?
r

rp

04/10/2022, 6:51 PM
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.
j

joeldesante

04/10/2022, 6:54 PM
thanks for the info!
m

michaelgrigoryan25

04/10/2022, 7:02 PM
@User maybe the postgres driver that you use is also compatible with Cockroachdb?
CockroachDB supports postgres syntax but is much more scalable
r

rp

04/10/2022, 7:08 PM
We do have people use the sessions + passwordless recipe for cockroach db
But we haven’t tested it extensively with that db yet. So no guarantees from our side
And we r working on generic sql support which would work with cockroachdb and others reliably.
3 Views