We use Oracle here, and utilize the jdbc lite drivers. This allows us to build the failover right on the CF-Server: I'm sure it would work for other RDBMS as well . . .
When you create the datasource, choose "other" Driver Class: oracle.jdbc.driver.OracleDriver JDBC.URL = jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db1.your.primarly.server.url.or.ip.addy.here)(PORT = 1234)) (ADDRESS = (PROTOCOL = TCP)(HOST = db2.your.failover.server.url.or.ip.addy.here(PORT = 1234)) (LOAD_BALANCE =off) (FAILOVER = on) ) (CONNECT_DATA = (SERVICE_NAME = servicename.here) ) ) Dave Hannum On Tue, Aug 10, 2010 at 1:02 PM, Barney Boisvert <[email protected]>wrote: > > All the datasource information is stored in XML > (/WEB-INF/cfusion/lib/neo-query.xml, if I recall correctly) files, and > on CF8 you can just drop the XML files into another non-running server > and start it up. On CF9 there is some additional security to prevent > this. > > However, you can use the CFADMIN API to script the creation of all > your datasources (and all your other admin settings). That's > definitely the route I would take. Build yourself a configuration > file per environment, and then use that to bootstrap your CF instance > when it starts up. Works like a champ, and you can store your > bootstrap file in version control to keep track of it. Plus, because > it's code, you'll never have to worry about servers being configured > differently for the same version of code AND you can have different > server configuration move out with your code so you don't get out of > sync. > > cheers, > barneyb > > On Tue, Aug 10, 2010 at 9:48 AM, Wally Randall > <[email protected]> wrote: > > > > I am faced with a difficult deployment situation. I have eight > production CF servers running CF8. We have about 10 SQL server and Oracle > database occurances supporting those CF applications. > > > > Our agency is going to create a failover server system at our off-site > emergency location with the following characteristics. All Database server > names will be changed. All IP addresses for all servers will be changed. > > > > We have 130+ CF datasources defined on the webservers which we need to > "migrate" to the failover location. My datasources all reference specific > database server names and need to be modified on the target machines. > > > > Has anyone else had to deal with this problem? Any suggestions? Is > there anyway to create the datasources from a source loaded at server > startup? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6894 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
