Stat Server Load Balancing
The relationship between a statistic and the Stat Server pair against which it is requested is maintained. This means that on (re)start or refresh of the adapter, statistics are now re-requested against the same Stat Server(s) as previously. AGA no longer depends on the value set for the Stat Server old-stats-remove-interval option.
If any additional Stat Servers are added after the initial starting of the Adapter, the statistics already requested with previous Stat Servers are not automatically re-distributed with the newly added Stat Server pair. You have two options if a redistribution is needed. Use Option 2 to maintain existing mapping with some of the Stat Servers.
Option 1
| 1. Run the following SQL statement to truncate the ADAPTER_SS_OBJ_MAPPING platform database table: DELETE FROM ADAPTER_SS_OBJ_MAPPING WHERE SS_PAIR_ID = <Id of the stat server pair> |
| 2. Restart the Stat Servers (this flushes any previous requests). |
| 3. Restart the adapter and Platform server. |
Option 2
Run the following SQL statements to selectively update the ADAPTER_SS_OBJ_MAPPING table to point a range of objects to a new Stat Server installation:
SELECT SS_PAIR_ID FROM ADAPTER_SS_CONFIG WHERE NAME = [Name of the new pair's primary Stat Server]
UPDATE ADAPTER_SS_OBJ_MAPPING SET SS_PAIR_ID = [“ID” from above] WHERE OBJECTID IN ( ) AND OBJECTTYPE = ?
Add Stat Servers after Installation
To add Stat Server capacity after the deployment of Advisors Genesys Adapter, use the following procedure. You require access to the Platform configuration database.
| 1. Insert additional rows into the adapter_ss_config table that describe the additional Stat Servers. Name, Host, and Port are required. One row includes the primary Stat Server and its backup, if applicable. |
| 2. After committing the changes to the database, restart the Platform server and Genesys Adapter. |