对于mysql主主代理来说,绝对是一个福音。
经过测试,haproxy能够做到像参数功能描述的那样:
The first server with available connection slots receives the connection.
可用连接槽的第一个服务器接收连接。
并且在第一个服务器恢复之后,能够主动切回来。
for /l %i in (1,1,500) do @(mysql -h192.168.1.221 -P20001 -A -N -e "select concat(%i,'-',version(),'-',sysdate())")
附
first The first server with available connection slots receives the connection. The servers are chosen from the lowest numeric identifier to the highest (see server parameter "