Thanks Matt. SMTP and POP are on a separate server, and web stats on another. One issue we've always had with multiple boxes powering a web site is that when one server is down then the web site is down. Say CF/IIS on one and MySQL on another. Without clustering or other failover measures this (to my thinking) effectively doubles the probability that the site will be down at any given time due to a hardware failure or the need to reboot either one of the machines.
----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, May 17, 2007 5:22 PM Subject: Re: MySQL on CF server > It will run, but no matter how overbuilt your server is, you'll get > better reliability from two separate servers. > > For years I ran a setup like you are describing... big dual-processor > behemoth with uber-SCSI drives and gobs of memory. The theory was to > overbuild the single box and use all that extra capacity to run > multiple apps off the same box (in my case that was CF/IIS, mySQL and > SmarterMail/ASSP). > > When I eventually outgrew that, I went to two behemoths and put CF/IIS > alone to itself, moving db and mail/antispam to its own box. > > Reliability went WAY up. > > Later, I decided to go with a lower-cost approach: A mid-grade build > for web/CF (dual Xeon, 2gb, 1 73gb SCSI drive), and a single cheapo > server for mySQL, another for mail, another for DNS/antispam and so > on. I wound up spending less for *five* 'little' servers that each > did only one or two things ($480/month) than I did for Godzilla and > Megalon ($850/month for both) ... and reliability went from 'pretty > darn reliable' to 'rock solid forever and ever'. I personally would > never go back to doubling and tripling up like that if I could help > it. My server setup: > > LARRY > primary DNS > statistics (smarterstats) > backup for all the other servers (synchback, mySQL via sqlYog > scheduled jobs) > CURLY > CF-generated smtp (smartermail) > antispam gateway for human-generated mail (ASSP) > MOE > mySQL > SHEMP > CF > IIS > JOE > Secondary DNS > human smtp/pop mail server, web mail (smartermail) > > > If I need more capacity I'd replace one of the small boxes above with > a bigger one. > > -- > [EMAIL PROTECTED] > Janitor, The Robertson Team > mysecretbase.com > > > On 5/17/07, Jim McAtee <[EMAIL PROTECTED]> wrote: >> We're finally going to be migrating from CF 5 to CFMX 7.1 soon and will >> spec a new server with Win2k3 Server Standard as the OS. The dbms, >> currently running on a separate Windows server, is MySQL 5.0. If we >> move >> MySQL to the new server, how well could we expect it to coexist with >> CF/IIS on the same machine? The new server will likely be far more >> powerful than needed given our traffic level and the complexity of our >> web >> sites - either a single or dual dual-core Xeon, 4GB memory, 10k RPM SAS >> disks. I suspect MySQL will run faster on this machine, even with CF >> and >> IIS running along side, and it eliminates the 100 Mbps network >> connection >> between two machines. >> >> Any thoughts or recommendations? >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278537 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4