MySQL Forums
Forum List  »  Router & Proxy

proxy-read-only-backend-addresses
Posted by: David Palmer
Date: January 17, 2008 04:34PM

I've been working with mysql-proxy and using the excellent init script someone posted here, and noticed something quite odd with mysql-proxy.

its not picking up any of my read-only backend database addresses. i specify them via the
--proxy-read-only-backend-address=<xxx>:xxxx

only to not see them when running:
select * from proxy_config;

i've taken the actualy command out of the init script to see if the command line arguments were mucking it up, it isn't.

my whole command looks like:
/usr/local/bin/mysql-proxy --daemon --pid-file=/var/run/mysql-proxy.pid \
--proxy-address=:4040 --admin-address=:4041 \
--proxy-backend-addresses=192.168.1.84:3306 \
--proxy-read-only-backend-addresses=192.168.1.90:3306 \
--proxy-lua-script=/usr/local/bin/rw-splitting.lua
i've made sure that the .90 box has mysql running and that i can log in from the .84 box (where mysql-proxy is running).

i know i have to be missing *something*



Edited 1 time(s). Last edit at 01/18/2008 11:29AM by David Palmer.

Options: ReplyQuote


Subject
Views
Written By
Posted
proxy-read-only-backend-addresses
10904
January 17, 2008 04:34PM
4719
January 18, 2008 11:27AM
3697
March 14, 2008 12:58AM


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.