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 controled. you speak abot load balancing and introduce also the failover notion, which isnot a load balancing concept. Fail over is difficult because controling it implies that every node must have the image before of every transaction. With cache fusion, oracle RAC gives a solution, but assumes failover only for select statements. All DML statements are lost if a node is lost. The mysql concept of clustering is different from the oracle one. Will oracle shares all in memory, mysql clusters share nothing. I'm studing this now, so can't give you more details, but i think that in future versions, all RDMBS constructors will control the two concepts in the database side. Mathias Selon Kevin Burton <[EMAIL PROTECTED]>: > 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 configure. Also none of them provide any information > > about the > > current state of 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 is difficult to implement. There are a log of design issues. > > Also the > > issues WRT distributed connection management start to make the problem > > difficult. > > > > The other day I had a bit of an epiphany on this topic. > > > .... > > http://peerfear.typepad.com/blog/2005/06/design_of_a_cli.html > > -- > > > Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com. > See irc.freenode.net #rojo if you want to chat. > > Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html > > Kevin A. Burton, Location - San Francisco, CA > AIM/YIM - sfburtonator, Web - http://peerfear.org/ > GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
