Re: mysql load balancer appliance

Good point Ed and I would agree--unless of course the project is sufficient
to warrant that kind of expenditure to make sure it work.  I know, I know,
I'm always doing cost/benefit analysis; it's a sickness.

For MySQL, SIP and even SMTP, what you're looking for is an intelligent
message-based load-balancing as opposed to the more traditional
connection-based load balancing.  As Ed mentioned, this is the way most
advanced devices handle HTTP.  The idea is that you terminate the
'connection' and load balance the messages within the stream.  For example,
you could terminate SMTP at the load balancer, have it then connect to
multiple SMTP servers and the backside and load balance the delivery of
individual messages between the servers.  In this manner, if any SMTP server
fails, you don't have to reinitiate the entire transfer.

If a device where to employ a generic message-based load-balancing
capability, it could easily then also use intelligent content examination to
make decisions about how to load balance individual messages: reads across
all servers, but writes only to one; all email to a specific
domain/sub-domain to one server versus another.  At this time, you can
simulate this using things like iRules on F5 gear for some things and
individual products may have specific solutions for specific protocols (like
HTTP).

Obviously, the holy grail here will be a device that has fairly generic 
capability to understand message-based transactions and automatically handle 
them.

KJ (Ken) Salchow, Jr. | Manager, Technical Marketing
D 651.423.1133
M 612.868.12588
P 206.272.5555
F 206.272.5555
www.f5.com



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Ed
Toro
Sent: Monday, June 22, 2009 8:50 AM
To: Load Balancing Mailing List
Subject: Re: [load balancing] mysql load balancer appliance

Most LB are great for simple layer 3/4 LB like this but I think OP was
looking for an LB that does similar LB magic at layer 7 that something
like NetScaler does for HTTP.

I would never buy something expensive and feature rich like NetScaler
only to do MySQL LB. If I already have one doing my HTTP LB then it
makes sense. It's great for HTTP LB but for Layer3/4 LB it's overkill
and it does nothing at Layer 7 for MySQL except intelligent monitoring.


Routon, Randal R. wrote:
>  I use Citrix NetScaler for MySQL load-balancing.  They have built-in
> MySQL monitor.  I've configured in primary/backup config such that the
> backup does not receive any connections unless the primary is DOWN.
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf
> Of Miloska
> Sent: Monday, June 22, 2009 9:12 AM
> To: Load Balancing Mailing List
> Subject: [load balancing] mysql load balancer appliance
>
> Hi Lads,
>
> is there any appliance (preferably hardware) with native MySQL
> loadbalancing on the market? For example a pair of boxes with failover
> based on MySQL proxy?
>
> It should speak MySQL to split 'read' and 'write' statements.
>
> I need a drop-in solution rather than set up own stuff from scratch.
>
> Thanks,
>
> Miloska
> _______________________________________________
> lb-l mailing list
> [email protected]
> http://vegan.net/mailman/listinfo/lb-l
> Searchable Archive: http://vegan.net/lb/archive
> http://lbdigest.com Load Balancing Digest
> http://lbwiki.com Load Balancing Wiki
> _______________________________________________
> lb-l mailing list
> [email protected]
> http://vegan.net/mailman/listinfo/lb-l
> Searchable Archive: http://vegan.net/lb/archive
> http://lbdigest.com Load Balancing Digest
> http://lbwiki.com Load Balancing Wiki
>

_______________________________________________
lb-l mailing list
[email protected]
http://vegan.net/mailman/listinfo/lb-l
Searchable Archive: http://vegan.net/lb/archive
http://lbdigest.com Load Balancing Digest
http://lbwiki.com Load Balancing Wiki

_______________________________________________
lb-l mailing list
[email protected]
http://vegan.net/mailman/listinfo/lb-l
Searchable Archive: http://vegan.net/lb/archive
http://lbdigest.com Load Balancing Digest
http://lbwiki.com Load Balancing Wiki