Mantis Bug Tracker - Forums

Is it feasible to host a single instance of the database in one location and host multiple instances of IIS across different regions. We have a latency issue with some places, and as part of our investigative approach into finding a workable solution, we were going to setup up regional IIS boxes pointing back to one MSSQL server.

Thanks

I would expect the proposed setup to be slower. Since the client does 1 request from the remote IIS server in the current setup, but with your proposed setup, the IIS will do multiple requests from the DB over the slow connection. Hence, I don't think it will work for you. I would locate the server (IIS+DB) in the location with least latency to all other branches.