Is supertokens horizontally scaleable?
# generalj
joeldesante
04/10/2022, 6:47 PMIs supertokens horizontally scaleable?
r
rp
04/10/2022, 6:48 PMYea! 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 PMAwesome thanks!
r
rp
04/10/2022, 6:48 PMThe only limitation is that they all need to be connected to one instance of a sql db
j
joeldesante
04/10/2022, 6:48 PMRight okay
joeldesante
04/10/2022, 6:49 PMIf that database was sharded in some way Im sure that would still count as 1 instance, right?
r
rp
04/10/2022, 6:51 PMwell.. 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 PMthanks for the info!
m
michaelgrigoryan25
04/10/2022, 7:02 PM@User maybe the postgres driver that you use is also compatible with Cockroachdb?
michaelgrigoryan25
04/10/2022, 7:02 PMCockroachDB supports postgres syntax but is much more scalable
r
rp
04/10/2022, 7:08 PMWe do have people use the sessions + passwordless recipe for cockroach db
rp
04/10/2022, 7:08 PMBut we haven’t tested it extensively with that db yet. So no guarantees from our side
rp
04/10/2022, 7:09 PMAnd we r working on generic sql support which would work with cockroachdb and others reliably.
4 Views