Reputation: 24325
Should I host an API website with no user interface on the same server the database it's going to read data from? This would be on a Windows Server 2008 box with SQL Server 2005.
Upvotes: 1
Views: 747
Reputation: 3298
If you don't have a lot of traffic, there's no problem at all with this setup.
When your server loads increase, you can start having multiple API front end servers connecting to a dedicated DB server.
Just remember to keep connection info centralized and easily configurable (i.e. no hard coded DB host or user in your code). This will make migration much much easier.
Upvotes: 1