Really it would come down to which is doing the most work. If all you queries are done in Cold Fusion the CF server. If you are using stored procedures for queries then the SQL server.
Brian > -----Original Message----- > From: George Lu [SMTP:[EMAIL PROTECTED] > Sent: Thursday, 4 March 2004 12:04 > To: CFAussie Mailing List > Subject: [cfaussie] Re: Server architecture. > > I've got one more question. If the database server is sitting in a > separate box, which one should have higher hardware configuration? > > George > > >>> [EMAIL PROTECTED] 4/03/04 10:49:00 >>> > > But what about if one of those boxes fails ? This leads me to think you > need 2 CF boxes running enterprise with cluster cats. but then if you do > that you might as well have 2 of everything ? (sounds more like an Ark > than a server farm!) > > And assuming your application is entirely written in CF, whats the point > of having a separate web server ? all the requests will be forwarded on to > CF processing anyways ? > > Pat > > > "Taco Fleur" < [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote in message <news:[EMAIL PROTECTED]>... > Maybe there is a bit of latency to deal with when the SQL server is > on another machine, but the benefits outweigh those milliseconds lost. > > The 4 main benefits you gain from keeping it all separate is > > 1. security > 2. stability > 3. scalability > 4. upgradeability > > But to answer your question, nope I don't know of any white papers, > but any decent networking guy should know this, keep it all separate > - Web Servers > - SQL Servers > - Application Servers > - Mail Servers > > I think if you have an architecture as following > > Box1 ColdFusion > Box2 SQL Server > Box3 Web Server > > and a 100MBps network you won't notice any latency and possibly gain > speed. > > Taco Fleur > Blog <http://www.tacofleur.com/index/blog/> > Methodology <http://www.tacofleur.com/index/methodology/> > > Tell me and I will forget > Show me and I will remember > Teach me and I will learn > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of WALTERS > Scott > Sent: Thursday, 4 March 2004 8:32 AM > To: CFAussie Mailing List > Subject: [cfaussie] Server architecture. > > > Anyone know about an official paper re best practice server > architecture configuration of CFMX, db servers, etc. > > Basically looking for something that sais the database > server should reside on a separate box to the CF app server. I'm arguing > against someone who insists network latency in accessing data has a bigger > impact than the sheer load oracle running on the same box as a couple of > instances of cfmx app servers. > > Thanks > > Scott. > IMPORTANT NOTICE: This e-mail and any attachment to it are > intended only to be read or used by the named addressee. It is > confidential and may contain legally privileged information. No > confidentiality or privilege is waived or lost by any mistaken > transmission to you. The RTA is not responsible for any unauthorised > alterations to this e-mail or attachment to it. Views expressed in this > message are those of the individual sender, and are not necessarily the > views of the RTA. If you receive this e-mail in error, please immediately > delete it from your system and notify the sender. You must not disclose, > copy or use any part of this e-mail if you are not the intended recipient. > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > AMES (Adult Multicultural Education Services) > www.ames.net.au > > > Disclaimer > ********************************************************************** > This email and any attachments may be confidential. > If received in error, please contact us and delete all copies. > Before opening or using attachments you should check them for viruses > or defects. > Regardless of any loss, damage or consequence, whether caused by the > negligence of the sender or not, resulting directly or indirectly from > the use of any attached files our liability is limited to resupplying > any affected attachments. > Any representations or opinions expressed are those of the individual > sender, and not necessarily those of Adult Multicultural Education > Services (AMES). > > ********************************************************************** > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 ----------------------------------------------------------------------------------- The contents of this message are the views of the Author and do not necessarily reflect the views of SUNCORP METWAY LTD ABN 66 010 831 722. The content of this e-mail, including attachments is a confidential communication between the Suncorp Metway Group and the intended addressee. Any unauthorised use of the contents is expressly prohibited. If you have received this e-mail in error please contact the sender immediately and then delete the message and any attachment(s). http://www.suncorp.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
