MySQL Forums
Forum List  »  Router & Proxy

Proxy pool member. How to...?
Posted by: Maxim Volkov
Date: September 10, 2007 05:08PM

A few (may be naive) questions about mysql-proxy load balancing I still have after going through mysql-proxy documentation, web and this forum search.

-- after starting mysql-proxy with:
mysql-proxy \
--proxy-backend-addresses=1.1.1.1 \
--proxy-backend-addresses=1.1.1.2 \
--proxy-backend-addresses=1.1.1.3 \
--proxy-lua-script=my_script.lua &

is there a way to add an additional --proxy-backend-addresses=1.1.1.4 without restarting mysql-proxy? Can I take an IP out from the pool? In broader terms, can parameters to mysql-proxy being passed in run time situation?

-- when I try to connect to mysql-proxy in a loop it looks like round robin balancing not happening at all and only the first member of the group gets all connections. Do I have to do any special configuration changes to allow load balancing?

-- using lua how to print out all IPs active in proxy.servers array? I can print an individual IP with say print(proxy.servers[1].address), but how print an entire array to see what is there? The attempts to print with table.foreach or for bares no fruit.

-- is there any How To(s) on the topic of load balancing with mysql-proxy?

Much appreciate your response.

Options: ReplyQuote


Subject
Views
Written By
Posted
Proxy pool member. How to...?
6845
September 10, 2007 05:08PM
3006
September 10, 2007 11:52PM
3291
September 11, 2007 12:58AM
3180
September 11, 2007 01:35AM
3204
September 11, 2007 02:37AM
2964
September 11, 2007 03:38PM
2804
September 12, 2007 03:42PM
2884
September 12, 2007 05:03PM
2793
September 13, 2007 01:45AM
2993
September 13, 2007 03:16PM
2868
September 13, 2007 03:38PM


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.