Hi Wendy,
I have checked it didn't setup SQLGARD_IP as the CM instead. I had to change the value for this parameter STAP_PARTICIPATE_IN_LOAD_BALANCING to 4 in order to get STAP active and to capture the traffic successfully.
I am sure there must be bug for Load Balance. Also we are using 10.6 STAP version while our appliances are on version 10.5.
Also I have setup windows Load Balance for MSSQL servers. when i am giving this parameter STAP_PARTICIPATE_IN_LOAD_BALANCING value to 4, all STAP's are inactive on 1 collector while on other 2 additional collector no STAP's are showing up. when i changed this parameter STAP_PARTICIPATE_IN_LOAD_BALANCING value to 1, all the STAP's are showing up active on collector 1 while still on other 2 collectors nothing is showing up. I will be able to capture the traffic successfully on collector 1.
Please let me know what is the process to setup Load balance for MSSQL.
1- what is the correct value for this Parameter for all DB Types
STAP_PARTICIPATE_IN_LOAD_BALANCING if using ELB.
Thanks,
Farah
------------------------------
farah zabe
------------------------------
Original Message:
Sent: Thu June 18, 2020 01:32 PM
From: Wendy Zemba
Subject: Load Balance
@farah zabe
In 10.6, we had situations where ELB would set the SQLGARD_IP as the CM instead. I'll have to research for the bug number.
Do you have access to the guard_tap.ini file on the source system to validate?
Another thing you should ensure that the value in the STAP_TAP_IP parameter is the same value you are using in your S-TAP group. IP to IP or hostname to hostname.
Assume that you opened TLS Port 8443 between CM and Collectors.
------------------------------
Wendy
Original Message:
Sent: Thu June 18, 2020 09:37 AM
From: farah zabe
Subject: Load Balance
Hi Wendy,
I have setup all the parameter as you suggested last night, But since then STAP's are in synchronizing state on all 3 collectors.
Thanks,
Farah
------------------------------
farah zabe
Original Message:
Sent: Wed June 17, 2020 01:41 PM
From: Wendy Zemba
Subject: Load Balance
Hi @farah zabe:
Correction, sorry. STAP_PARTICIPATE_IN_LOAD_BALANCING needs to be set to 0 to use ELB.
------------------------------
Wendy
Original Message:
Sent: Wed June 17, 2020 01:14 AM
From: farah zabe
Subject: Load Balance
Hi Wendy,
I have setup Load Balance and set those parameter to value as follows: I have Managed group with 3 collector IP and I have STAP group with 15 STAP. i have defined STAP_SQLGUARD_IP for 5 STAP, collector 1, for other 5 STAP, collector 2, while for 5 STAP, collector 3, I didnt define STAP_ADDITIONAL_SQLGUARD_IPS because this value should be taken by Enterprise parameter value CM. But what I am seeing all the STAP's have Primary STAP_SQLGUARD_IP is collector 2, we are having high CPU and Memory Utilization alert on collector 2. why we are seeing this behavior, this STAP should be distributed on coll 1, coll 2 and coll 3.
STAP_PARTICIPATE_IN_LOAD_BALANCING = 4
STAP_LOAD_BALANCER_NUM_MUS=3
STAP_SQLGUARD_IP=
Thanks,
Farah
------------------------------
farah zabe
------------------------------