Database on Web server

[oaklanders]

We have MySQL sitting on our very busy Windows Web Server.
Is it not a good idea to put a robust Database on a Web server because it could impact the performance?

Everything seems to be working with MySQL on the server but was wondering if anyone has any past issues or thoughts on this.

 

[Aelara]

We have a similar setup running several Sql databases on the Main Web server. All sites are run on IIS 6. The only performace issues are related to bandwidth limitations.

The server is runing 2 Xeon Dual core cpu's, 2gb Ram, 500gb Sata HDD 7200rpm etc.


Aelara.

 

[lhuegele]

It really depends on the hardware and bandwidth that server has. Most of our IIS servers also run at least one database application (if not multiple databases) with no issues, but they are beefy servers.

Good luck,

 

[oaklanders]

Thanks

 

[kmcferrin]

It usually depends on how hard the web site and databases are being hit, as well as what is in the databases. If the DB is just the backend for the web site then your only concern is performance. If it stores data for other applications, then there are potential security concerns.

Technically speaking, those security concerns are there regardless of what data is in the DB. Usually you would adopt a tiered approach, keeping the presentation layer (web) separate from the application or data tiers (MySQL).