locked
MDS HIgh Availability RRS feed

  • Question

  • Hi

    We will have have a SQL Server 2014 active/passive cluster that will lost the  application, ssrs , ssas and mds databases.

    Also we have two web/app servers that will host ssrs services (network load balance).

    Regarding MDS, my understanding is MDS is now cluster aware but  if we install MDS on the active/passive cluster nodes then the the web application will have to be hosted by IIS on this nodes. What does one do if we don't want IIS installed on these nodes (install and configure MDS on the web/application servers ?)

    Regards

    Tim


    SQL DBA

    Sunday, October 12, 2014 2:08 PM

Answers

  • Tim, 

    One thing we did at a client site was install the MDS IIS bits on the same scaled out servers that hosted the scale out SSRS IIS bits. It seemed a good use of those resources and created a cost effective method for licensing. 

    Hope this helps.

    Reeves

    Thursday, October 16, 2014 6:03 AM
  • We have scale out architecture too where MDS+IIS sit in one box and the database on another server and we have HA solutions for MDS on the VM level. But keep in mind licensing issue - if you install MDS component on IIS you may have to pay SQL Server license for that server.

    Tuesday, October 14, 2014 8:15 PM

All replies

  • We have scale out architecture too where MDS+IIS sit in one box and the database on another server and we have HA solutions for MDS on the VM level. But keep in mind licensing issue - if you install MDS component on IIS you may have to pay SQL Server license for that server.

    Tuesday, October 14, 2014 8:15 PM
  • Tim, 

    One thing we did at a client site was install the MDS IIS bits on the same scaled out servers that hosted the scale out SSRS IIS bits. It seemed a good use of those resources and created a cost effective method for licensing. 

    Hope this helps.

    Reeves

    Thursday, October 16, 2014 6:03 AM
  • Tim, 

    One thing we did at a client site was install the MDS IIS bits on the same scaled out servers that hosted the scale out SSRS IIS bits. It seemed a good use of those resources and created a cost effective method for licensing. 

    Hope this helps.

    Reeves

    Thanks. Very clever use of resources indeed.
    Thursday, October 23, 2014 2:59 PM