locked
CRM installation using active-active or active-active-passive configuration RRS feed

  • Question

  • Hi all,

    have any of you successfully completed an active-active or active-active-passive CRM installation?   is that a supported configuration? what are the pitfalls ?

    many thanks

    Ryan

    Tuesday, April 16, 2013 2:45 PM

All replies

  • Hi,

    CRM is supported for both active-active and active-passive clustering according to the courseware for the installation course, however it will always behave like an active-passive cluster. I have some memory that it only supported active-passive, but either I'm a short way to Alzheimers or something have changed. I haven't done a setup with clustered SQL, so unfortunately I can't help you with that.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Wednesday, April 17, 2013 10:11 AM
  • thank you Rickard.  Does anybody know why CRM wont fully exploit an active-active cluster ?
    Wednesday, April 17, 2013 8:49 PM
  • The smallest unit for an active-active cluster is the database. CRM requires the MSCRM_Config database at all times, so that must be implemented as Active-Passive. Theoretically, if you had multiple organisation databases, you might be able to have some active on one node, and the others active on a different node at the same time, which you could call active-active

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, April 18, 2013 7:54 AM
    Moderator
  • David, do you know if they changed the supported modes from active-passive to "active-active or active-passive but it will behave as active-passive" at some time or if my memory is shot?

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, April 18, 2013 9:41 AM
  • Rickard, I'm not aware of any change in the documentation or support modes. My reply was based on what is theoretically possible, rather than what is documented or supported.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, April 18, 2013 3:48 PM
    Moderator
  • CRM SQL clustering it's only supported on a Active-Passive cluster.

    However David is right this is actually possible, if you change the connectionstring in the MSCRM_CONFIG database the clients will connect to whatever SQL server is in there. I've tested this in the past and worked fine. But wouldn't recommend it for maintainability and support. 


    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    Tuesday, April 23, 2013 1:10 PM
    Answerer