MySQL Forums
Forum List  »  Router & Proxy

Re: round robin depends on client or... ?
Posted by: Hans Meiser
Date: May 03, 2010 02:33AM

Hello,

nobody who uses mysql-proxy this way?
i tried to figure out how round robin works. with a simple php-script i do looped connects,query,disconnect and watch log of my backends.
round-robin without lua-script seems to depends on client IP. All x-thousends connects from one client were served from server1.
i tried some lua-script which were provided with my mysql-proxy 0.7 but could not find a big difference.
i think my way of using mysql-proxy is the standard way. one client and x servers for load-balancing.
it must be possible to select backendserver not depending on client IP but simple the count of connections.
connection1 -> server1
connection2 -> server2
connection3 -> server1
.
.
.

Is there no standard-solution? Only possible with own lua-script?

Thanks,
Andre

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: round robin depends on client or... ?
2045
May 03, 2010 02:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.