I think you can do it with linux-vs, because it loadbalances all TCP traffic
that means layer 4, like most other load-balancers.
Personally I've done a quite big Cluster (about 20 mysql's ) with an F5-
BigIP-HA. It's superior to all other solutions from Cisco, Alteon...
And it does Layer 7 switching according to customizable rules...
Very cool.
And the best: it is based on a BSD-3.0 PC, which you can upgrade for
performance with simply buying a bigger Intel Processor from the store
around the corner :-)
No expensive proprietary hard or software like other competitors...
Performance is about 500-600Mbit/s with one 600Mhz PIII
just my opinion...
--Andy
-----Ursprüngliche Nachricht-----
Von: Bogomolnyi Constantin <ConstantinB@stripped>
An: Eric Thelin <eric@stripped>
Cc: mysql@stripped <mysql@stripped>
Datum: 18 November, 2000 14:06
Betreff: Re: Load balancing queries?
>Hi ,
>I have done this on pretty big web cluster ,
>10 pc , where 6 statics and 4 dyns . I have an
>Mysql Master on a separate machine and 1 replication instance on
>each dyn (you can put them on separates machines if you want )
>
>So for my http load balancing i'm using an Alteon (nice but pain in the ass
>to make it work) now I prefer Foundry solutions .
>
>And here comes mysq load balancing .
>I have resolved this by a very simple trick . All my scripts are using the
>same API to acces the database , and in this api I check the type of
>the submited query , if it is an select i just send it to localhost , else
>(update insert delete ) i send them to the master .
>This works neat for me .
>And it allows me to make the difference between tables in the query
>(not all tables are replicated) so i can tune this in my api and
>not brother all developers with this .
>The SqlApi is quite trivial , so i don't post it here , if you want i can
>post it to you directly .
>
>Hope this helps .
>Best
>CB
>
>----- Original Message -----
>From: "Eric Thelin" <eric@stripped>
>To: <mysql@stripped>
>Sent: Friday, November 17, 2000 12:46 AM
>Subject: Load balancing queries?
>
>
>> With replication working the next step to gaining a very high
>> performance system is to have an effective method to divide the queryies
>> to the many replicated servers. Lets say I have 4 slaves replicating
>> off of 1 master and 3 webservers that I want to use to pull queries on
>> the database cluster. Is there any existing way to make those 4 slaves
>> look like one very high performance database server (by sending
>> alternating queries to different servers)? The linux virtual server
>> project can do this for other tcp connections (ie. http, ftp, ...). But
>> will it work for MySQL? Has anyone done it? It sounds like using the
>> direct routing method it should work great. But I haven't done any
>> thing like this before so I am only guessing. If this won't work will
>> any of the hardware load balancing solutions like cisco's localdirector
>> work?
>>
>> Eric
>>
>>
>> Eric Thelin erict@stripped
>> AZtechBiz.com: Where Arizona Does Tech Business
>> Voice: 480-377-6743 Fax: 480-377-6755
>>
>>
>> --
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/documentation/manual.php" before
>> posting. To request this thread, e-mail mysql-thread56585@stripped
>>
>> To unsubscribe, send a message to:
>> <mysql-unsubscribe-hpcenter=netcourrier.com@stripped>
>>
>> If you have a broken mail client that cannot send a message to
>> the above address (Microsoft Outlook), you can use:
>> http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread56720@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-andreas=vierengel.de@stripped>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
>
