Hello,Does anyone have experience with high availability of MS SQL supporting the OutSystems?We're evaluating the option to have a MS SQL cluster with active/active/standby servers with a f5 load balancer in front of the servers (MS SQL), so the OutSystems' front-ends and controller server connects to load balancer to access the MS SQL (connections distributed to the 2 active of the cluster).My concerns is the OutSystems use connection pooling for the databases, and is not cluster aware platform (altrough f5 could obviate this by presenting a single entry point).Reason to do this is high availability and scalability on database side.
Hi Luis,
Although nobody responded to your question, I was wondering if you yourself found out the answer already, and if so if you would like to share your experience.
Regards,
Daniel
Daniël Kuhlmann wrote:
We've contacted OutSystems support and answer we got back is this not recommended.
We could go doing all the "black magic" behind OutSystems with f5 and MS SQL clusters presenting a single point to OutSystems, but in the end we choose not go this way.
Thank you for the feedback Luis.