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](https://private-user-images.githubusercontent.com/94488868/326057666-97e429a2-9aa1-433a-a8a7-3f0d18c888a0.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTYyNjcwMzUsIm5iZiI6MTcxNjI2NjczNSwicGF0aCI6Ii85NDQ4ODg2OC8zMjYwNTc2NjYtOTdlNDI5YTItOWFhMS00MzNhLWE4YTctM2YwZDE4Yzg4OGEwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA1MjElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNTIxVDA0NDUzNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPThhOWZmNWRlOWMwYWIxZjU3MzA3ZjZhMjNlZDg3ZTdjNGZiYjE1ZGJiN2I2NTdiYjBmZjVjNDYxZDFkMGNmOGQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.lJNbjmE2bW69KuVC-hvujdQJzO8v-Y2piplhLf_7kvE)
ProxySQL version: v2.5.5-1
OS version: amazon linux2
Thank you!