Mysql-proxy Load Balancing doesn't work

Can you post the balance.lua and the log output.

Hi Jason

This is the log from /home/mysql-proxy/mysql-proxy.log

2013-02-25 11:31:47: (message) mysql-proxy 0.8.2 started
2013-02-25 11:31:47: (debug) max open file-descriptors = 1024
2013-02-25 11:31:47: (message) proxy listening on port 192.168.1.2:3306
2013-02-25 11:31:47: (message) added read/write backend: 192.168.1.3:3306
2013-02-25 11:31:47: (message) added read/write backend: 192.168.1.4:3306

This is the balance.lua that I copy from /usr/lib64/mysql-proxy/lua/proxy/balance.lua to /home/mysql-proxy/balance.lua

--[[ $%BEGINLICENSE%$
...
$%ENDLICENSE%$ --]]

module("proxy.balance", package.seeall)

function idle_failsafe_rw()
 local backend_ndx = 0

 for i = 1, #proxy.global.backends do
  local s = proxy.global.backends[i]
  local conns = s.pool.users[proxy.connection.client.username]

  if conns.cur_idle_connections > 0 and
     s.state ~= proxy.BACKEND_STATE_DOWN and
     s.type == proxy.BACKEND_TYPE_RW then
   backend_ndx = i
   break
  end
 end

 return backend_ndx
end

function idle_ro()
 local max_conns = -1
 local max_conns_ndx = 0

 for i = 1, #proxy.global.backends do
  local s = proxy.global.backends[i]
  local conns = s.pool.users[proxy.connection.client.username]

  -- pick a slave which has some idling connections
  if s.type == proxy.BACKEND_TYPE_RO and
     s.state ~= proxy.BACKEND_STATE_DOWN and
     conns.cur_idle_connections > 0 then
   if max_conns == -1 or
      s.connected_clients < max_conns then
    max_conns = s.connected_clients
    max_conns_ndx = i
   end
  end
 end

 return max_conns_ndx
end

Can you try to shutdown one backend to check if the connection goes to another backend.

I already tried it.
Yes it does the failover, the connection go to second backend.
But load balancing process never hapenned even after I boot the first backend, the connection now always go to the second backend.

Would you please paste the configuration of your mysql configuration, did you setup the replication for them.

please refer here:http://www.clusterdb.com/mysql-cluster/get-mysql-replication-up-and-running-in-5-minutes/.