Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Supported Database for ProGet HA Installations
-
I have a 2025 version of ProGet deployed in OpenShift using the embedded database at the moment, For an HA deployment, what is the supported database cluster, SQL AlwaysOn, InedoDB, or PostgreSQL? This page https://docs.inedo.com/docs/installation/postgresql points to using InedoDB as the choice for a clustered DB for Inedo products, but this page https://docs.inedo.com/docs/installation/postgresql says "can work with any SQL Server Cluster installation". Finally, this page https://docs.inedo.com/docs/installation/sql-server seems pretty definitive that SQL is supported.
Thanks for your help de-mystifying it for me, I am sure I am just confusing myself.
-
Hi @jeff-williams_1864 ,
You mentioned that you're "using the embedded database at the moment", which I take to mean that you're not using a separate SQL Server container image.
The In that case, the only options for a clustered installation is using InedoDB (recommended) or an External PostgreSQL (not recommended).
If you were using SQL Server, then SQL Server would be supported for a clustered instance as well. However, we are moving away from SQL Server, so we definitely wouldn't recommend it on a new installation.
Thanks,
Alana
-
Thank you Alana, so that pretty much sums it up. My plan was to use a SQL server availability group for the DB backend for the clustered application. In the case of using InedoDB with a clustered HA deployment of the ProGet application in a containerized scenario, do you support multiple clustered InedoDB containers for this?
-
Hi @EnterpriseVirtualization_2441 ,
We do not recommend using SQL Server Availability groups..
For a product like ProGet, a single database node is all that's required -- and it's strongly recommended.
There is no practical benefit to a clustered database here - on the contrary, it makes the product slower, less stable, and more costly/complex to maintain. As such, InedoDB does not support clustering.
Cheers,
Alana
-
Perfect, thanks Alana :)
