<< Should I just move over the DB or would I be better off Load balancing across the two boxes? Or is the something else you'd recommend? >>
Make sure that you also take into consideration how much you care about maintenance / administration time. IMO it's often worth paying a little more for a couple of larger boxes than an army of cheaper ones just so that you can save time keeping them in order. All depends on what your priorities are, and what you expect your future traffic growth to be. If you're getting any sort of load, get that db off the CF box. It's like night and day. I just upgraded my CF setup from a single dual Xeon to a pair of Opterons, 1 acting as a mysql server, the other for httpd/cfmx. Stick a switch between them, and watch in amazement. My experience is that you'll tend to be disk/IO bound if you're running your DB on a busy CFMX server. Fast disks might help, but giving the DB a new home is going to be worth it. If your db server is light loaded, you can pile other tasks on it like sendmail, backups, etc and take even more pressure off the CF server. Personally I wouldn't consider load balancing at all until a 3rd server was required, unless failover is important to you. Of course, if availability is critical then your requirements will vary, in which case you're going to want failover of both cf and the db. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
