443端口代理mysql_[转]MySQL Proxy - MySQL代理的介绍及个人使用经验

$ mysql-proxy --proxy-backend-addresses=192.168.0.1:3306 &

测试连接:

$ mysql --host=localhost --port=4040 --user=root --password

输入Data base server的密码.连接上了.

到网通服务器上测试,

$ mysql --host=双线服务器的网通IP地址 --port=4040 --user=root --password

输入密码后,立即就能看到mysql>了.

套上PHP代码,测试. 速度非常好.目的达到了.

如果你也有类似或者 mysql server 负载平衡、容错 等的应用需求时,不妨也试试mysql-proxy,

相信不会让你失望的.

也欢迎和我探讨这方面的问题. 我的联系方式在这里!!

-------------------------------------------------------------------

附mysql-proxy 的所有语法命令:$ mysql-proxy --help-all

Usage:

mysql-proxy [OPTION...] - MySQL Proxy

Help Options:

-?, --help Show help options

--help-all Show all help options

--help-admin Show options for the admin-module

--help-proxy Show options for the proxy-module

admin module

--admin-address=listening address:port of internal admin-server (default: :4041)

proxy-module

--proxy-address=listening address:port of the proxy-server (default: :4040)

--proxy-read-only-backend-addresses=address:port of the remote slave-server (default: not set)

--proxy-backend-addresses=address:port of the remote backend-servers (default: 127.0.0.1:3306)

--proxy-skip-profiling disables profiling of queries (default: enabled)

--proxy-fix-bug-25371 fix bug #25371 (mysqld >5.1.12) for older libmysql versions

--proxy-lua-script=filename of the lua script (default: not set)

--no-proxy Don't start proxy-server

Application Options:

-V, --version Show version

--daemon Start in daemon-mode

--pid-file=PID file in case we are started as daemon