MySQL Forums
Forum List  »  Router & Proxy

Load balancing with MySQL Proxy v 0.7.2
Posted by: Biswajit Bardalai
Date: November 27, 2009 04:42PM

Hi,

I'd like writes to go to the master and reads to any of the db servers in a setup as follows:

192.168.53.191 (master)
- 192.168.53.192 (slave 1)
- 192.168.53.193 (slave 2)


/etc/mysql-proxy.conf:

[mysql-proxy]
daemon = true
keepalive = true
basedir = /opt/mysql-proxy
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy.log
log-level = debug
#proxy-address = 192.168.53.191:4040
#proxy-backend-addresses = 192.168.53.191:3306 # default localhost
proxy-read-only-backend-addresses = 192.168.53.192:3306, 192.168.53.193:3306


Startup:
/opt/mysql-proxy/sbin/mysql-proxy --defaults-file=/etc/mysql-proxy.conf


Connection from remote host:
mysql -u user -ppwd -h 192.168.53.191 -P 4040 mydb



Is this configuration sufficient to achieve writes to master and reads from any of the servers?

Thanks,
Biswajit



Edited 1 time(s). Last edit at 11/27/2009 04:40PM by Biswajit Bardalai.

Options: ReplyQuote


Subject
Views
Written By
Posted
Load balancing with MySQL Proxy v 0.7.2
5120
November 27, 2009 04:42PM


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.