Amoeba realizing MySQL read-write separation

Amoeba version: 5.1.45-mysql-amoeba-proxy-2.2.0 Source distribution

Master: 192.168.204.128

From: 192.168.204.129

amoeba:192.168.204.130

Dbservers.xml file:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/1B/wKioL1SpRyKRgeu2AAHjbmOQ6IY932.jpg "style=" float: none; "title=" DbServers.xml.png "alt=" Wkiol1sprykrgeu2aahjbmoq6iy932.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/1E/wKiom1SpRmbzoqrJAAJKHWk-AzQ269.jpg "style=" float: none; "title=" DbServers.xml2.png "alt=" Wkiom1sprmbzoqrjaajkhwk-azq269.jpg "/>

Amoeba.xml file

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/1B/wKioL1SpR4eyNpUgAAF8rwy8evU205.jpg "style=" float: none; "title=" Amoeba.xml.png "alt=" Wkiol1spr4eynpugaaf8rwy8evu205.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/1E/wKiom1SpRsuTGWcsAAIQsMXowSo826.jpg "style=" float: none; "title=" Amoeba.xml2.png "alt=" Wkiom1sprsutgwcsaaiqsmxowso826.jpg "/>

Execute on the master/slave server:

Grant all on cjnew.* to [e-mail protected] ' 192.168.204.130 ' identified by ' CMYSQLJ ';

Start Amoeba:

/usr/local/amoeba/bin/amoeba start

Netstat-tnlp

:: ffff:192.168.204.130:8066

Login Amoeba:

Mysql-uroot-p-h192.168.204.130-p8066

Amoeba realizing MySQL read-write separation