MySQL on ColdFusion server

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?

Goto Fullcontrol.net and check out what they have. I have been with them for over 4 years and can't be any happier. We have never had any downtime due to their network or servers. Good luck! ----- Excess quoted text cut - see Original Post for more -----

Appreciate the recommendation, but we've always owned and maintained our own servers and have a partial cabinet in a pretty nice colocation facility. ----- Excess quoted text cut - see Original Post for more -----

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. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ----- Excess quoted text cut - see Original Post for more -----

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. ----- Excess quoted text cut - see Original Post for more -----

Considering CF can't use over 1.5 gb memory give or take, I'd say you would have plenty for other applications, I wouldn't expect your applications to run any faster then they are now. Separation is the best alternative, expecially with mail since you need to run anti virus against it. That's about the most memory intensive app you could have running on the box. We run mysql and CF and IIS on a single box without problems. How many visitors are you talking about. I think our biggest hurdle is thread allocation. Only running CF Standard is becoming troublesome when using cfdocument. That tag sucks ass, and I don't expect things to be much better in Scorpio unless same with CF7, you go with enterprise. -- Casey

> Considering CF can't use over 1.5 gb memory give or take, Per instance I believe not as a whole. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com Considering CF can't use over 1.5 gb memory give or take, I'd say you would have plenty for other applications, I wouldn't expect your applications to run any faster then they are now. Separation is the best alternative, expecially with mail since you need to run anti virus against it. That's about the most memory intensive app you could have running on the box. We run mysql and CF and IIS on a single box without problems. How many visitors are you talking about. I think our biggest hurdle is thread allocation. Only running CF Standard is becoming troublesome when using cfdocument. That tag sucks ass, and I don't expect things to be much better in Scorpio unless same with CF7, you go with enterprise. -- Casey

And only on certain platforms. We've got a 2.5GB instance on SPARC/Solaris that runs fine. > > Considering CF can't use over 1.5 gb memory give or take, > > Per instance I believe not as a whole. > > Considering CF can't use over 1.5 gb memory give or take, I'd say you would > have plenty for other applications -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/