[MDEV-21185] Need to test Load Balancer on MariaDB Created: 2019-12-01 Updated: 2019-12-01 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2.28 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Minor |
| Reporter: | Ras Tarun | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
MariaDB 10.2.25 Galera Cluster |
||
| Description |
|
We have MariaDB Galera Cluster hosted on 3 nodes . System Administrator has configured F5 Network Load Balancer so that Traffic can loaded on least nodes as there is frequent Data Loading done from Streams. When Data Loading team is loading Data , using show processlist command , I am able to see Stream connection established and Insert & Update operations being done. What should I do to see that these connections are managed by Load balancer ? or how Load Balancer is communicating with all 3 Maria DB Nodes Do we have any Dictionary View or SQL Query which could tell us about this , Kindly support and guide me |
| Comments |
| Comment by Ras Tarun [ 2019-12-01 ] |
|
Show Processlist command doesnot show IP Address of Load Balancer ( VIP ) in the output. I mean how can we say Load Balancer is working fine or it is Load Balancer which is managing connections |