MySQL Forums
Forum List  »  Router & Proxy

load balancing master-slave setup
Posted by: Herbert Balagtas
Date: January 20, 2012 09:29AM

Hi I'm trying to get mysql-proxy to load balance using a master-slave setup.

I'm using mysql-proxy on Ubuntu 10.04.3

# mysql-proxy --version
mysql-proxy 0.7.2
glib2: 2.22.2
libevent: 1.4.13-stable
lua: Lua 5.1.4
LUA_PATH: /usr/lib/mysql-proxy/lua/?.lua
LUA_CPATH: /usr/lib/mysql-proxy/lua/?.so
== plugins ==
admin: 0.7.0
proxy: 0.7.0

Here is my config file:


[mysql-proxy]
daemon = true
proxy-address = 127.0.0.1:3306
proxy-skip-profiling = true
keepalive = true
event-threads = 10
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy.log
log-level = debug
proxy-backend-addresses = master:3306
proxy-read-only-backend-addresses = slave:3306


However when I use mytop and check munin stats I don't see any reads at all going to the slave.

Can anyone advise please, am I missing something in the config?

Options: ReplyQuote


Subject
Views
Written By
Posted
load balancing master-slave setup
3774
January 20, 2012 09:29AM


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.