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

2005-06-04 Thread mfatene
image ? you're modifying row n, node x wants to modify it, you need a rollback segment for that ! which value node x will read. i'm considering every DML is a transaction in an RDBMS, so when you say that you don't use transactions, you miss something. about load balancing, how do you track long

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. With t

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 completely

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, when oth

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
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/01/2005 02:31:54 PM: > I'd love to get some feedback here: > > > MySQL currently falls down by not providing a solution to transparent > > MySQL load > > balancing. There are some hardware solutions but these are expensive and > > difficult to config