It may chew up less resources, but that doesn't get around the security issues. Every 'expert' I've ever spoken with on this would agree with putting the db on a separate box, behind the firewall, and without direct access to the net, utilizing full authenticated-only access from specific sources within the internal lan, and typically on a non-standard port.
MySQL is exceptional, and I use it for nearly all private development, but the only time I use it on the same machine as CF is in my local development environment. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com Tom Chiverton wrote: > On Thursday 21 Jun 2007, Jochem van Dieten wrote: >>>> As a side note, putting a database server on the same box is a bad move. >>>> The web server and database server should be separate to obtain the best >>>> in security and utilization of your hardware. >>> I believe this statement is more true for MS SQL Server than it is for >>> MySQL. At least that is what a couple MySQL experts >> Can those experts elaborate on why they believe that to be so? Do they >> have names? > > I would have though it was obvious. > MySQL eats less resources than MS SQL, so it's more able to co-exist with a > web server than MS SQL given the same hardware and loading. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
