Using the Atlas MySQL read-Write separation tool

The former array tested 360 open source Atlas, generally good, here first marked, spare.
I heard that amoeba is also good, Daniel gave me a recommended article, but also to keep.

Tests the performance of the next Atlas, which is very powerful.

in Concurrent2000when theAtlaswill promptI have no server backend,closing connection. The judgment should beMysqlcannot provide idle connections in time, butAtlasthere are no bottlenecks. However,Atlasitself is not disconnectedMysqlconnection settings, completely dependent on theMysqlits own time-out.

#!/bin/bash

#***for pressure test atlas***

date + "%h:%m:%s"

for ((i=0;i<1500;i++));d o

{

num= ' echo $RANDOM '

mysql-ushanks-p51cto-h192.168.122.100-p8306 zabbix-e "INSERT into Test_atlas values (\" ${num}\ ")"

} &

done

date + "%h:%m:%s"

configuration file:

[Mysql-proxy]

Plugins = Admin,proxy

Admin-username = Admin

Admin-password = [email protected]

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

Proxy-backend-addresses = 172.16.220.242:3306

Proxy-read-only-backend-addresses = 172.16.220.243:[email protected]

Daemon = True

KeepAlive = True

Event-threads = 4

Log-level = Message

Log-path =/usr/local/mysql-proxy/log

Instance = Test

Proxy-address = 0.0.0.0:8306

Admin-address = 0.0.0.0:8307

Min-idle-connections = 128

#tables = Person.mt.id.3

#pwds = 8z9v7ilzor0=

charset = UTF8

This article is from the "Target: India" blog, please be sure to keep this source http://shunzi115.blog.51cto.com/5184443/1825940

Using the Atlas MySQL read-Write separation tool