Skip to main content
M
Mark_1968
Participant
February 7, 2011
Question

Is there a way to programmatically add datasources to multiple instance in a cluster?

  • February 7, 2011
  • 1 reply
  • 1426 views

Hi,

I am wondering whether it is possible to loop through the instances in a cluster and add the same datasource to each using the setMSSQL function from cfide.adminapi.datasource.cfc.

We are running CF9.01 on Windows Server 2008 r2 (64 Bit).

If you can't do this, what would be the best way to achieve this without having to log in to each administrator and add them manually?

Thanks in advance,

Mark

    This topic has been closed for replies.

    1 reply

    12Robots
    12Robots
    Participating Frequently
    February 7, 2011

    I don't know how to do it programatically, but ColdFusion comes with a pretty cool Server Manager/monitor that lets you work with multiple servers at once.

    http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSfd7453be0f56bba4-2a6b48f122a6582c7f-8000.html

    M
    Mark_1968Author
    Participant
    February 7, 2011

    Hi Mr Robots,

    Yeah, the Server Manager is good, but doesn't really help us here. We can add the datasource for the instance we have the active session with using setMSSQL() method in the adminAPI , but I would like to add it to all the CF instances in the cluster.

    Cheers,

    Mark

    12Robots
    12Robots
    Participating Frequently
    February 7, 2011

    You can't add datasources across a cluster with the Server Administrator?  That surprises me.

    Honestly, I have never done it, but according to Adobe's feature page, that is one thing it does:

    http://www.adobe.com/products/coldfusion/features/

    "You can create data sources, schedule tasks, apply hot fixes, clear caches, and compare settings across a cluster of ColdFusion servers."

    According tot he docs here:

    http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSfd7453be0f56bba4-2a6b48f122a6582c7f-7ffe.html

    You do need to register each instance as a server, but once that is done, you shouldn't need to worry about it again.

    Sorry if that's not the answer you're looking for.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices