sysown/proxysql

Every uneven traffic distribution for nodes with same weight after upgrading from v2.0.10-1 to v2.5.5-1

tijoytom opened this issue · 1 comments

After upgrading from proxysql version v2.0.10-1 to v2.5.5-1, we noticed that the traffic pattern for the backend changed significantly. Both backends weigh 1000; we have three servers, one primary, and two replicas.

primary weight: 1
replica1 weight: 1000
replica2 weight: 1000

With version v2.0.10-1, we see the same number of (stats_mysql_connection_pool.Queries), but with v2.5.5-1, we see almost 3-4X difference between the replica1 and replica2. Please look at the attached screenshot; you will see a traffic switch around 3.55 PM since we changed the weights to 100 and 1000, respectively. But the first part of the graph shows the when both weights are 1000.

Screenshot 2024-04-26 at 10 00 47 AM

ProxySQL version: v2.5.5-1
OS version: amazon linux2

Thank you!