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...?
6851
September 10, 2007 05:08PM
3007
September 10, 2007 11:52PM
3294
September 11, 2007 12:58AM
3182
September 11, 2007 01:35AM
3206
September 11, 2007 02:37AM
2966
September 11, 2007 03:38PM
2806
September 12, 2007 03:42PM
2886
September 12, 2007 05:03PM
2794
September 13, 2007 01:45AM
2994
September 13, 2007 03:16PM
2872
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.