Application Scaling with Microsoft SQL Server in PAM360

Application scaling with Microsoft (MS) SQL server in PAM360 is aimed at providing enhanced scalability and performance, and also to ensure uninterrupted access to the privileged resources and passwords stored in PAM360. The application scaling model works with a main PAM360 node and several sub nodes, all of them connecting to a common MS-SQL database cluster.

Note: The application scaling model in PAM360 currently works only with the MS-SQL database cluster.
  1. How does it work?
  2. Steps to configure sub nodes
  3. Steps to change a sub node into a main node

1. How Does it Work?

The main node for PAM360 and its corresponding sub nodes must point to the same MS-SQL cluster but they do not need to be connected to each other. However, the main node (or the machine that will carry out the schedule operations) needs to fulfill either of the following conditions:

  1. The main node and the target end-points for which agentless password management capabilities are enabled from PAM360 should reside in the same subnet. 
  2. If the main node and the target end-points reside in different networks, they should be able to communicate to each other, i.e., they should not be blocked by a firewall or reside outside the range of connectivity such as demilitarized zones.
Note: Any of the secondary nodes can be assigned as the main node as long as it has proper connectivity to other machines. This is to ensure that the schedule operations are executed properly. 

application scaling with MS SQL cluster

2. Steps to Configure Sub Nodes

To configure sub nodes pointing to the same cluster, follow the below steps:

  1. Install the PAM360 in the machine which will act as the main node.
  2. In the PAM360 installation directory, copy the database_params file from this path:

< PAM360_installation_directory >\conf\database_params.conf.

  1. Paste the database_params.conf file to the path < PAM360_installation_directory >\conf\> in all the nodes which you want to assign as the sub nodes for PAM360.
  2. Install PAM360 in all the secondary nodes.
Note: Currently, you can assign upto three machines as the sub nodes using the application scaling model.

2.1 Steps to View the Configured Nodes in PAM360

Once the main node and sub nodes are configured, follow the below steps to view them from the PAM360 interface.

  1. Navigate to Admin >> Configuration >> Application Scaling.
  2. Here, you can enable or disable the sub nodes using the toggle button. However, you need to restart the main node and decommission the sub nodes for the changes to take effect.

application scaling with MS SQL cluster

3. Steps to Change a Sub Node into a Main Node

Follow the below steps to change any secondary node into the main node. This change can be done at any point of time from any sub nodes.

  1. Keep the MS-SQL database running.
  2. Stop all application servers including the main node.
  3. Open a command prompt and execute the following commands:
  4. For Windows

    For Linux

  5. Current main node and the list of available servers will be displayed. Choose any server from the drop-down and click Save.
  6. application scaling with MS SQL cluster

  7. Restart all application servers that were stopped earlier.
  8. The selected server will be assigned as the main node now.

Click here for more information on how to set up a Microsoft SQL cluster.

©2019, ZOHO Corp. All Rights Reserved.