a month ago
We are using Convex for a heavy-duty project and we are looking for options to scaling up our infrastructure.
I am working on figuring out if we can upgrade to Enterprise plan. On a side, from a technical perspective, is there a way to scale by using multiple postgres instances?
Pleas shed some light on anything you can help with Convex.
Thank you..
Pinned Solution
a month ago
Something you can do for Postgres is to convert it to a HA (high availability) cluster. You can do so by going into service panel, Database, then Config. You'll see the option to convert to HA from there. (Hope I understood your goal correctly)
4 Replies
Status changed to Awaiting Railway Response Railway • about 1 month ago
a month ago
We don't provide architecture advice on any plan or tier, so we're opening this up to the community for help with scaling your Convex and Postgres setup.
Status changed to Awaiting User Response Railway • about 1 month ago
a month ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open Railway • about 1 month ago
a month ago
Something you can do for Postgres is to convert it to a HA (high availability) cluster. You can do so by going into service panel, Database, then Config. You'll see the option to convert to HA from there. (Hope I understood your goal correctly)
0x5b62656e5d
Something you can do for Postgres is to convert it to a HA (high availability) cluster. You can do so by going into service panel, Database, then Config. You'll see the option to convert to HA from there. (Hope I understood your goal correctly)
a month ago
I saw that option that got recently released. Our application is internal use and we only have a few users. Just so I understand. HA is going to split the load between the backend server to multiple replicas? Is that correct? Also, do u you know if there is any documentation on how this works?
I can attempt to convert my current Postgres database to HA. Do u know if we can get back to the original database after the conversion?
Thanks in advance.
I saw that option that got recently released. Our application is internal use and we only have a few users. Just so I understand. HA is going to split the load between the backend server to multiple replicas? Is that correct? Also, do u you know if there is any documentation on how this works? I can attempt to convert my current Postgres database to HA. Do u know if we can get back to the original database after the conversion? Thanks in advance.
a month ago
Postgres HA handles automatic leader election and failover, if the primary node goes down, Patroni promotes a replica and HAProxy begins routing connections to it within seconds.
You can revert a cluster back to a single standalone Postgres service from the cluster overview. Click Revert to stage the changes.
You can read more about it here in the Railway docs: https://docs.railway.com/databases/postgresql-ha
Status changed to Solved 0x5b62656e5d • 30 days ago