I once saw a presentation on different ways of load balancing web servers and SQL
servers to accomplish this. Im no expert but from what I remember the easiest way to
do this is to store the actual databases on a central machine and have the SQL Servers
feed from that central point. In terms of actual redundancy between the SQL servers
there are methods such as round robin DNS, etc. I suggest consulting a networking
engineer for ideas on software and hardware that will accomplish this. Hope this helps.
Shane Witbeck
---------- Original Message ----------------------------------
From: "Paul Johnston" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 15 Dec 2000 11:49:18 -0000
>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
