Paul
This is exactly what we are doing.
We have 2 SQL Servers that share the same disk array. One SQL server is
passive whilst the other is live. There is a bit of software called
Costandby server which basically tells the other to take over if the live
one goes down. Costs about 3K I think.
Andy
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: 15 December 2000 14:32
To: CF-Talk
Subject: RE: URGENT: Not OT: SQL Server Problems...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Paul,
The overhead to check to see if a SQL server was up per query would
be enormous. Don't consider that option.
You're on the right track by setting up a second SQL server for
failover. If you want to have true failover, you'll need to purchase
NT Enterprise (4.0) or 2000 Advanced, install the cluster option and
then install SQL Server Enterprise, using a drive array to share
disks.. which equals a ton of cash.
MS has multiple articles on their site on how to do this...
Managing SQL Server on a Cluster
http://msdn.microsoft.com/library/psdk/sql/1_server_20.htm
Configuring SQL Server for a Cluster
http://msdn.microsoft.com/library/psdk/sql/1_server_24.htm
Q243218 - INF: Installation Order for SQL Server 2000 Enterprise
Edition on Microsoft Cluster Server
http://support.microsoft.com/support/kb/articles/Q243/2/18.ASP
IMHO: If you're database server is going down that often, your tech
guys probably won't be ready for a cluster anyway.. find new tech
guys.
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
___________________________________________
"Never forget that only dead fish swim with
the stream." -- Malcolm Muggeridge
___________________________________________
- -----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 6:49 AM
To: CF-Talk
Subject: URGENT: Not OT: SQL Server Problems...
Guys,
We have a SQL Server 7 implementation with three CF servers using it
as a
database server.
The problem is that it's falling over regularly (and the technical
guys
can't figure it out).
That's not the problem though. We are now setting up a second SQL
Server 7
for use as a failover. It will replicate all of the data. My boss
wants to
know if it is possible for CF to use one or other of the database
servers
depending on what is up!
So the idea is:
For each query - check which server is up and choose one to use
(assuming we
can replicate all data)
This doesn't make very much sense to me (it's not my idea, I just got
asked
to ask the list) as I would do it differently anyway!
So situation (again)
2 SQL servers
Q: can we replicate the data so they effectively are the same?
2 CF Server
Q: without having to change EVERY <cfquery> can we make something
that will
use one or other to retrieve data depending on which one is up.
Is this possible?
Paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
