Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement setting in mysql_hostgroup_attributes to define custom load balancing algorithm #4536

Open
renecannao opened this issue May 3, 2024 · 0 comments

Comments

@renecannao
Copy link
Contributor

This is a new feature.

Currently ProxySQL supports only 1 load balancing algorithm: "weighted random load balancing" .
(Actually, it is a slightly modified version of it, as the presence of free connections may direct more traffic to the server with more connections: the presence of free connections is used as a hint that the server can take more traffic).

"Complex logic" like the one described in #730 can add time in finding a candidate server, thus shouldn't a behavior that is always enabled.
Although we could implement different load balancing algorithms based on hostgroup. In this way the default algorithm is not changed, but each hostgroup can use a different load balancing algorithm at (potentially) a different performance cost.
This may be beneficial in scenarios like the one described in #730 .

Note on performance:
The performance cost cannot be determined before the actual implementation design, but it is likely to be a small cost especially when compared with network latency.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant