I am wondering what is a state of
http://codership.com/products/galera-load-balancer ?
Does it support notifications from nodes that traffic can be
redirected taking into account the state of node ?
--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-925-400-7377, Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko
Join us at Percona Live: MySQL Conference And Expo 2012
http://www.percona.com/live/mysql-conference-2012/
The list of destination servers can be dynamically changed in runtime,
see README there. Note that it supports "draining", but for that to work
the application needs to periodically willfully reconnect (very nice to
get Sysbench doing that). Same with adding new destinations - if
application connections are static it won't be able to use added nodes.
So if you write a notification script properly, you should be able to
manipulate glbd routing tables. The trick is when one of the nodes
crashes, somebody of the remaining has to report that. Also internally
glbd blacklists destination for a second if it can't connect to it. Does
not seem work that well though - connection attempt seems to introduce a
noticeable overhead (it is a heavy synchronous operation)
As for the overall state - I don't think it got tested enough. We
didn't have any feedback on it.
Regards,
Alex
--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011
Thanks for explanation.
I am looking for what solution what can recommend for user
to use as load balancer. As I understand there is no "ready-to-use"
scripts for glbd ?
I saw there are solutions for haproxy, like
https://groups.google.com/group/codership-team/browse_thread/thread/44ee59c8b9c458aa/98b47d41125cfae6?lnk=gst&q=haproxy#98b47d41125cfae6
so this is probably what we will recommend.
> --
> You received this message because you are subscribed to the Google Groups
> "codership" group.
> To post to this group, send email to codersh...@googlegroups.com.
> To unsubscribe from this group, send email to
> codership-tea...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/codership-team?hl=en.