ubuntu 13.04 mysql_Ubuntu 13.04 MySQL Proxy安装与配置

Ubuntu 13.04 MySQL Proxy安装与配置

安装环境 Ubuntu 13.04

Shell

$ sudo apt-get install mysql-proxy

1

$sudoapt-getinstallmysql-proxy

ENABLED改为true

Shell

$ sudo vim /etc/default/mysql-proxy

1

$sudovim/etc/default/mysql-proxy

ENABLED=”true”

OPTIONS=”–defaults-file=/etc/mysql/mysql-proxy.cnf”

配置 /etc/mysql/mysql-proxy.cnf

Shell

$ sudo vim /etc/mysql/mysql-proxy.cnf

1

$sudovim/etc/mysql/mysql-proxy.cnf

[mysql-proxy]

daemon = true

user = mysql

proxy-skip-profiling = true

keepalive = true

max-open-files = 2048

event-threads = 50

pid-file = /var/run/mysql-proxy.pid

log-file = /var/log/mysql-proxy.log

log-level = debug

admin-address=:4401

admin-username=admin

admin-password=passw0rd

admin-lua-script=/usr/local/lib/mysql-proxy/lua/admin.lua

proxy-address = 0.0.0.0:3307

proxy-backend-addresses = 192.168.2.1:3306

proxy-read-only-backend-addresses=192.168.6.2:3306, 192.168.6.1:3306

proxy-lua-script=/usr/lib/mysql-proxy/lua/proxy/balance.lua

修改权限，这个步骤不能省略，否则无法启动。

Shell

$ sudo chmod 0660 /etc/mysql/mysql-proxy.cnf

1

$sudochmod0660/etc/mysql/mysql-proxy.cnf

启动mysql-proxy

Shell

$ sudo /etc/init.d/mysql-proxy start

* Starting MySQL Proxy daemon... [ OK ]

1

2

$sudo/etc/init.d/mysql-proxystart

*StartingMySQLProxydaemon...[OK]

测试3307端口

Shell

$ mysql -hlocalhost -P3307 -uroot -p

1

$mysql-hlocalhost-P3307-uroot-p

虽然Ubuntu的版本不一样，不过设置方式是类似的。