First, I concur - use a separate box for the database. And since you are building a new box, let me give a couple of additional suggestions.
1. Use at least three separate, physical disks. One as your boot drive for the OS and the database software. One for your datastore One for database log files (transaction logs, etc.) Databases are extremely IO intensive, and the more you can avoid disk contention during database access, the better. 2. Put as much RAM in the box as you can comfortably handle. Think "that seems like enough" and then add more. The reason is actually related to my first suggestion. Databases KNOW that IO is a problem, so will keep as much data in memory as possible to avoid disk access as much as possible. Ideally, you should have enough RAM to hold the entire contents of your database. These two things are far more important than CPU speed. If your budgeting comes down to going with a faster CPU vs. more RAM or disks, go for the disks and RAM. If your database is really getting worked hard, your CPU will be wasting a lot of time waiting for the disks and even the memory - it's unlikely with a reasonably powerful processor that the processor will be the bottleneck. As for DNS - it's not a terribly heavy process, assuming you aren't using it as the core DNS server for a large network, so leave it where it is. > -----Original Message----- > From: Richard Cooper [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 9:38 AM > To: CF-Talk > Subject: Re: Second Server > > Thanks Dave. > > Do you think all other services should remain off that box. i.e. should I > keep the DNS on the website server? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
