> 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?
I don't know if this is the easiest way, but if you have CF 4.5.x, you can
take advantage of CFERROR TYPE="EXCEPTION". You can configure two separate
datasources, store the datasource name in an Application variable, then when
one database server goes down and someone runs a script which attempts to
query that server, you can trap the exception, parse it to make sure that
the problem is the server being down, then change the value of the
datasource variable to the other server. Again, this might not be the
easiest way, but it's pretty easy - it should take you about ten minutes to
do this.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
