dexdev (4/28/2014)

---

Hi everyone

We're looking into setting up a SQL cluster for our app.

Our current setup is based on a very high number of small databases.

We are looking into setting up a cluster, but we are getting mixes opinions on whether to convert all our individual databases (about 5000) to one big individual database, or keeping our current setup.

Some say that it would be easier to manage one large database, and ensure high availability, while some say that managing a huge number of small databases would not be an issue. Any thoughts on this ?

We also want to make sure that should we scale and grow, and we get to 50000 databases, clustering etc. will still never cause issues.

Any thoughts?

Thanks