Load balancing with MySQL Proxy v 0.7.2
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.
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.