wiki'd

by JoKeru

MySQL Load Balancing and Read-Write Splitting with mysql-proxy

[cc lang='bash']
\$ apt-get install -y mysql-proxy
\$ vi /etc/default/mysql-proxy
\$ vi /etc/mysql-proxy
\$ chmod 0660 /etc/mysql-proxy
\$ /etc/init.d/mysql-proxy start
[/cc]

/etc/default/mysql-proxy
[cc lang='bash']
ENABLED="true"
OPTIONS="--defaults-file=/etc/mysql-proxy"
[/cc]

/etc/mysql-proxy
[cc lang='bash']
[mysql-proxy]

admin-address = 192.168.0.10:4041

proxy-address = 192.168.0.10:3036
proxy-backend-addresses = 192.168.0.11:3306
proxy-read-only-backend-addresses = 192.168.0.12:3306,192.168.0.13:3306

log-file = /var/log/mysql-proxy.log
log-level = debug
[/cc]

Comments