Doesn't sound like an ideal solution. If you round robbin the IP addresses,
then half of the time the web server would be using the remote SQL server,
even if the local SQL server is perfectly functional. That could be a hefty
performance penalty for the sake of redundancy.
Can ODBC settings be changed on the fly without causing major headaches with
the driver or with CF? If so, you could run a process that monitors the
health of the local SQL server. If it finds that the machine isn't
functioning properly, then you might switch the IP address within the ODBC
configuration to point to the backup server.
Jim
----- Original Message -----
From: "Rick Eidson" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 10:32 AM
Subject: RE: Backup Database
> Well I can't use the same IP the SQL's are on 2 different Class C's.
>
> What I guess I need is a DNS record that allows for 2 IP's.
>
> Then I can point Cold Fusion to SQL.ourdomain.com
> And in DNS the record would have a Primary and a secondary IP.
>
> Rick
>
> -----Original Message-----
> From: Steve [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 11:11 AM
> To: CF-Server
> Subject: Re: Backup Database
>
> You could do it with DNS. You could round robin it or just use one IP,
If
> one of them fails you would have to change the DNS record. If you do it
that
> way make sure the web servers are pointing at a DNS server you own so you
> dont have to worry about caching.
>
> Steve
> ----- Original Message -----
> From: "Rick Eidson" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 06, 2001 9:53 AM
> Subject: Backup Database
>
>
> > I have a Web Server and a SQL server in Vegas and a SQL database in
Kansas
> > City. The KC database is the main SQL.
> >
> > What is the easiest way to have the Web Server point to the Backup SQL
if
> > the main SQL is not available? Can this be done in DNS?
> >
> > Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
