MySQL Proxy更强大的一项功能是实现“读写分离(Read/Write Splitting)”。基本的原理是让主数据库处理事务性查询,而从数据库处理SELECT查询。数据库复制被用来把事务性查询导致的变更同步到集群中的从数据库。
该版本主要改进:
D.7.1. Changes in MySQL Proxy 0.8.3 (2012-08-20)
Functionality Added or Changed
Added timeouts for connect, read, and write operations through --proxy-connect-timeout, --proxy-read-timeout, and --proxy-write-timeout options.
Added support for making connections to backends and clients using IPv6 addresses..
Added initial support for the Windows authentication plugin.
Added support for extracting pluggable authentication protocol information. In the Lua API, added these values: con.client.challenge.auth_plugin_name, con.client.response.auth_plugin_name.
Bugs Fixed
Fixed handling of capability flags in the client authentication response. In the C API, network_mysqld_auth_response_new() needs the server-side capabilities. In the Lua API, added these values: con.client.challenge (mirrors con.server.challenge), con.client.response.server_capabilties, con.server.challenge.server_capabilities.
Fixed the length of auth-plugin-data in the client authentication response packet.
Fixed crash if the configfile value contained invalid characters. In the C API, added chassis_keyfile_to_options_with_error() and deprecated chassis_keyfile_to_options().
Fixed a crash if the --max-open-files value was invalid on Win32.
Fixed the default plugin_dir value for 64-bit Unix systems (lib64/ versus lib/).
Fixed a crash if COM_BINLOG_DUMP was used with rw-splitting.lua.
Fixed handling of a missing trailing \0 in MySQL 5.5.7 through MySQL 5.5.10 in the auth-method name.
Fixed abort() in COM_CHANGE_USER+auth-method-switch.
Fixed excessive buffering of LOAD DATA LOCAL INFILE data.
MySQL Proxy 0.8.3 发布
MySQL Proxy 0.8.3发布。2012-08-20 这是MySQL官方的读写分离以及负载均衡工具,上一个版本还是2011-08-17的0.8.2.已经过了一年。
MySQL-Proxy是处在你的MySQL数据库客户和服务端之间的程序,它还支持嵌入性脚本语言Lua。这个代理可以用来分析、监控和变换(transform)通信数据,它支持非常广泛的使用场景:
MySQL Proxy更强大的一项功能是实现“读写分离(Read/Write Splitting)”。基本的原理是让主数据库处理事务性查询,而从数据库处理SELECT查询。数据库复制被用来把事务性查询导致的变更同步到集群中的从数据库。
该版本主要改进:
D.7.1. Changes in MySQL Proxy 0.8.3 (2012-08-20)
Functionality Added or Changed
Added timeouts for connect, read, and write operations through
--proxy-connect-timeout,--proxy-read-timeout, and--proxy-write-timeoutoptions.Added support for making connections to backends and clients using IPv6 addresses..
Added initial support for the Windows authentication plugin.
Added support for extracting pluggable authentication protocol information. In the Lua API, added these values:
con.client.challenge.auth_plugin_name,con.client.response.auth_plugin_name.Bugs Fixed
Fixed handling of capability flags in the client authentication response. In the C API,
network_mysqld_auth_response_new()needs the server-side capabilities. In the Lua API, added these values:con.client.challenge(mirrorscon.server.challenge),con.client.response.server_capabilties,con.server.challenge.server_capabilities.Fixed the length of
auth-plugin-datain the client authentication response packet.Fixed crash if the
configfilevalue contained invalid characters. In the C API, addedchassis_keyfile_to_options_with_error()and deprecatedchassis_keyfile_to_options().Fixed a crash if the
--max-open-filesvalue was invalid on Win32.Fixed the default
plugin_dirvalue for 64-bit Unix systems (lib64/versuslib/).Fixed a crash if
COM_BINLOG_DUMPwas used withrw-splitting.lua.Fixed handling of a missing trailing
\0in MySQL 5.5.7 through MySQL 5.5.10 in the auth-method name.Fixed
abort()inCOM_CHANGE_USER+auth-method-switch.Fixed excessive buffering of
LOAD DATA LOCAL INFILEdata.Fixed a lockup under very high load.
下载:ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-Proxy/mysql-proxy-0.8.3.tar.gz