I haven't used MySQL, but my instincts say to get a commercial-grade
database server like Oracle if this is as serious of an application as you
make it sound. Don't take the risk of it crashing. Get a database that is
designed to scale and has good, solid support behind it for when you have
issues.
As for whether CF could handle the load, I believe it will. However, each
application is different and a little load analysis will help determine if
this is the case.
One MAJOR problem I see here is you are relying on one web server. What if
it fails? What is your disaster-recovery plan for that case? Forget
failure, what if you just want to do maintenance and have to take it
offline? Your customer should be nervous if you haven't provided a plan for
this case.
--Doug
-----Original Message-----
From: Michael Sheldon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 11:15 PM
To: [EMAIL PROTECTED]
Subject: RE: How much can CF handle?
On a sturdy enough box, CF might handle the load, it depends on how complex
the code is.
MySQL *won't*. If you're really going to get that kind of traffic, don't
mess around with the small-fry, go to Sybase, Oracle, or at least
PostgreSQL.
A dual P3 is not the most important issue, and in fact, Allaire specifically
recommends NOT using an SMP Linux kernel until kernel 2.4 is released. Web
serving is not processor-intensive, it's I/O intensive. With this type of
load, a fast SCSI system is required, preferably 4+ high speed SCSI
Ultra-Wide drives in RAID5 configuration.
Michael J. Sheldon
http://www.desertraven.com/
Make a fast friend, adopt a greyhound!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 22:52
To: [EMAIL PROTECTED]
Subject: How much can CF handle?
Hi,
I am doing a proposal for a client ATM who has a web site that is currently
getting about 6 page views per second in peak time.
Do you think it will be possible to handle the load with a single CF/HTTP
server
running Linux and a separate DB server running MySQL? All images will be
stored
on an external server, so the only thing being processed by the CF box is
the
pages. It will probably be a fairly decent box, perhaps dual-P3, up to a gig
of
RAM, dual ethernet.
I am writing the app to make a lot of use of <cfinclude>s of
dynamically-built
static pages and liberal caching.
Any suggestions are welcome.
--------
Rob Keniger
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
