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.