[SSAS]How to Cluster SQL Server Analysis Services - moxuemeivip/Microsoft-Analysis-Service-Or-Fabric GitHub Wiki

Two Types of High Availability

Windows Server Failover Cluster (WSFC) and the built-in Windows load balancing feature called Network Load Balancing (NLB)

An NLB cluster is essentially the front end to a number of SSAS instances and distributes incoming requests to those instances.

In the event of a problem on the node that owns the Role, the Role and all of its resources will fail over to another node in the WSFC. Should failover occur, the connectivity information of the SSAS instance will remain the same regardless of the node it is running on. Since SSAS goes through a stop on the old node and a start on another – just like shutting down and restarting a standalone server – there will be an impact on the end user. image

NLB: has load balance is the best practice

WSFC:no load balancing

How to Cluster SQL Server Analysis Services

Here's Microsoft White Paper with a Word Document about how to install high availablility SSAS on Windows Server failover cluster (WSFC).

PowerShell commands to get Failover cluster info(WSFC)

Get-ClusterGroup Get-ClusterGroup “GroupName” | Get-Cluster Resource image

Connect to SSAS failover cluster

from another computer that will access the instance to ensure that it can be connected to from outside the cluster.

image

!!!Remember to open TCP 2383 in the firewall before connecting from a remote computer.

image

SSDT deploy

image

What can be change and what cannot

image