State of glb

40 views
Skip to first unread message

Vadim Tkachenko

unread,
Mar 20, 2012, 9:26:51 PM3/20/12
to codership
Hello Codership team.

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/

Alex Yurchenko

unread,
Mar 21, 2012, 2:52:22 AM3/21/12
to codersh...@googlegroups.com
Hi Vadim,

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

Vadim Tkachenko

unread,
Mar 21, 2012, 12:30:27 PM3/21/12
to Alex Yurchenko, codersh...@googlegroups.com
Alex,

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.

Reply all
Reply to author
Forward
0 new messages