It used to be very bad to have DB and CF on the same server, but I'm not sure that's still the case ... probably depends largely on the RDBMS you're using. In any event, it is certainly best practice to have production boxes separate. Running dozens of databases (or even 100) on a single DB server is no problem. Running many sites on a single CF server is also no problem, assuming you give yourself proper sizing on disk space and RAM.
---------------------------------------- From: "Che Vilnonis" <ch...@asitv.com> Sent: Friday, January 14, 2011 8:56 AM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: (ot) Server Setup Opinions I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm