Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Patch Manager > Patch Manager - Knowledgebase Articles > How to install a load balancer between the PAS and the database server

How to install a load balancer between the PAS and the database server

Table of contents

Updated: November 9, 2017

Overview

This article describes how to place a load balancer between the Primary Application Server (PAS) and the database server.

Environment

All Patch Manager versions

Steps

See Migrate a local or remote Patch Manager database to a Remote SQL Server for information about adding a database load balancer. This article describes how to point to a separate database. If the database and IP are identical, Patch Manager operates as expected without any required changes.

SolarWinds recommends placing the database balancer in the same subnet as the database. In this configuration, all connection strings are unchanged, which minimizes any changes. If the connection string between Patch Manager and the database changes, the article listed above can provide guidance. 

You can also change the connection string using DBhelpler or updating the hosts file. You can change the hostname in the PAS etc/hosts file to point to the new load balancer VIP Address. This method is an simple alternative and follows the same logic as migrating the database IP address into the load balancer. 

 

Last modified

Tags

Classifications

Public