KB0012 - High Availability

KB0012 - High Availability

Update

Please see the documentation at https://docs.powershelluniversal.com/config/hosting/high-availability for in-depth details on this topic. Below is an overview statement from Adam Driscoll on this topic as well.

Adam's statement

Our high availability solution is focused around centralized configuration using git with data storage in instance registration in SQL. 

The idea is to stand up multiple PowerShell Universal instances and configure them to use the same central SQL server database. As the instances connect they will register with the job queue and will process jobs as they come in. Job data will be stored centrally in SQL. Additionally, app tokens and identities are stored centrally in SQL so that you can use the same app tokens and role-based access across the instances. 

In terms of configuration, the PS1 files used to configure PSU, should be stored in a central git repository. In version 3.1, you can store the git configuration settings in SQL so that once the PSU instances connect, they will be able to retrieve the git repository information and pull their configurations. This ensures that all machines in the cluster are configured the same way. 

In front of the cluster, you will need a load balancer or other fail over application to redirect traffic to the individual instances. The gateway needs to support sticky sessions in order to support dashboards. Additionally, PSU takes advantage of web sockets heavily and it is a requirement that the gateway or load balancer support forwarding web socket connections. 

    • Related Articles

    • KB0044 - High memory usage in a long running, complex App

      Problem Memory usage can grow continuously in a complex app that is either long running and\or very busy. Root Cause Apps maintain user state as the users interact with the app. This state includes variables that are set and event handlers that are ...
    • KB - 1008 Tax/VAT Exempt at checkout

      Scope In this article you will learn how to make a tax-free purchase at checkout. Problem How do you remove the Tax/VAT on an order? Impact Orders will then need to be refunded for tax if processed without the tax deducted. Resolution Follow the ...
    • KB0050 - High memory usage for apps\dashboards using UDElement event handlers

      Affected Versions - PowerShell Universal 4.1.1 and earlier - PowerShell Universal 3.9.17 and earlier Problem PowerShell Universal apps (v4) and dashboards (v3) will consume gradually more memory when being accessed by users when the dashboard is ...
    • KB0062 - TLS Cipher Suites

      Problem Your organization has security concerns about the TLS cipher suites that are utilized by PowerShell Universal. You may have been informed by your security team (pen testers) that your instance of PowerShell Universal is vulnerable due to the ...
    • KB0074 - Connecting to PSU API w/Windows Auth

      Scope This article applies only to PSU environments where Windows Authentication[1] is enabled and known to be working[2]. Problem You are not able to interact with the PSU instance using the Invoke-WebRequest PowerShell cmdlet even though logging in ...