Re: read queries are not executing on backend-read-only server

[Diego Medina]

Hi Yogesh,

You will first have to create many connections through the proxy, so that the proxy can have a pool of connections to work from.

You can simply do

$ for x in {1..100} do;
  mysql -h192.168.0.9 -P4040 -uuser -ppassword -e "exit";
done

that will create many connections, and then the proxy should be able to distribute the queries.

Now, 0.6.1 is pretty old :) Have you tried 0.7.2 ? It runs much better.

Thanks

--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified? http://www.mysql.com/certification