LOAD BALANCER

2010-01-21 Thread Krishna Chandra Prajapati
Hi list, Out of the below load balancer which is the best one. Is there any other load balancer available. 1 mysql proxy (Still alpha) 2 ultramonkey. 3 haproxy Thanks, Krishna

Re: Load Balancer for mysql

2006-10-05 Thread Tom Brown
Is there a hardware/software loadbalancer for multiple mysql servers servicing read transactions? linux lvs project http://www.linuxvirtualserver.org/ as mysql network connections are tcp then this would work fine for reads -- MySQL General Mailing List For list archives: http://lists.m

Re: Load Balancer for mysql

2006-10-05 Thread Dominik Klein
Is there a hardware/software loadbalancer for multiple mysql servers servicing read transactions? You might want to take a look at www.linuxvirtualserver.org and www.keepalived.org Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Load Balancer for mysql

2006-10-05 Thread JM
Hi, Is there a hardware/software loadbalancer for multiple mysql servers servicing read transactions? Mailing-List -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: load balancer and cluster

2005-06-27 Thread d2clon
if it fails. On 6/23/05, d2clon <[EMAIL PROTECTED]> wrote: (sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain

Re: load balancer and cluster

2005-06-27 Thread d2clon
if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very good, but i see a problem: we need to

load balancer and cluster

2005-06-23 Thread d2clon
(sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the d

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-04 Thread mfatene
each node load ? Selon Kevin Burton <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > >Hi, > >i think that client load-balacer are more Dispatchers than real load > balancer. > > > >load balancing in the database side takes care to number of connections, but >

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-02 Thread Kevin Burton
[EMAIL PROTECTED] wrote: Hi, i think that client load-balacer are more Dispatchers than real load balancer. load balancing in the database side takes care to number of connections, but also node load. So thisis more real. But this issue is difficult. No... you're making assumptions.

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-02 Thread mfatene
Hi, i think that client load-balacer are more Dispatchers than real load balancer. load balancing in the database side takes care to number of connections, but also node load. So thisis more real. But this issue is difficult. even for oracle with 9iRAC and 10gRAC, load balancing is not

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-01 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin Burton wrote: > [EMAIL PROTECTED] wrote: > > >>Wouldn't it make better sense to build on the NDB protocol and keep >>the native messaging infrastructure than it would be to build a >>similar wrapper from scratch? I mean to use the NDB commun

RE: Design of a Client-side MySQL Java Load Balancer

2005-06-01 Thread Dathan Pattishall
We have a client-side load balancer, as well as a central load balancer for mySQL traffic. I've done many different models at a variety of companies, all which still use the solutions. Building on top of the NDB protocol would take a very long time to produce-a HA solution native to mySQL,

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-01 Thread Kevin Burton
[EMAIL PROTECTED] wrote: Wouldn't it make better sense to build on the NDB protocol and keep the native messaging infrastructure than it would be to build a similar wrapper from scratch? I mean to use the NDB communications on top of regular MySQL Biting off an NDB migration would be a L

Re: Design of a Client-side MySQL Java Load Balancer

2005-06-01 Thread SGreen
ct and > > reconnect to another host if the load grows too high. > > > > To that end I think it makes a lot of sense to have a MySQL > > client-side load > > balancer. > > > > This area is difficult to implement. There are a log of design issues. > >

Design of a Client-side MySQL Java Load Balancer

2005-06-01 Thread Kevin Burton
your MySQL configuration. For example they can't handle transparent query failover if a MySQL box fails. They also can't disconnect and reconnect to another host if the load grows too high. To that end I think it makes a lot of sense to have a MySQL client-side load balancer. This area

Using a Load balancer with MySQL 4.1.7 and JDBC 3.1.7 (performance)...

2005-01-21 Thread Kevin A. Burton
I'm playing around with using a load balancer to balance our slaves. What I want to do is put a load balancer in front of our slaves and then reconnect each time via the JDBC driver. This way a slave can fail and I can just take it out of service. It also means that I can keep performan

Re: Using a hardware load balancer in from of MySQL

2004-05-14 Thread sp4mv0rt3x-mysql
--- "PARTHA DUTTA, BLOOMBERG/ 499 PARK" <[EMAIL PROTECTED]> wrote: > Hello all, I would like to find out if anyone has > implemented an architecture > where a hardware load balancer is placed in front of > some MySQL servers in a > Multi-master replication sc

Re: Using a hardware load balancer in from of MySQL

2004-05-13 Thread Robert J Taylor
dware load balancer is placed in front of some MySQL servers in a Multi-master replication scheme. I want to use the load balancer more for high availability, than for load balancing. All connections to the database server would go the mysql server 1. If server1 fails, the load balancer shoul

Re: Using a hardware load balancer in from of MySQL

2004-05-13 Thread Luis R. Rodriguez
On Thu, May 13, 2004 at 06:49:01AM -0400, PARTHA DUTTA, BLOOMBERG/ 499 PARK wrote: > Hello all, I would like to find out if anyone has implemented an architecture > where a hardware load balancer is placed in front of some MySQL servers in a > Multi-master replication scheme. I want t

Using a hardware load balancer in from of MySQL

2004-05-13 Thread PARTHA DUTTA, BLOOMBERG/ 499 PARK
Hello all, I would like to find out if anyone has implemented an architecture where a hardware load balancer is placed in front of some MySQL servers in a Multi-master replication scheme. I want to use the load balancer more for high availability, than for load balancing. All connections to