ldvhai
asked on
MySQL-Proxy Round Robin
Hi All,
I have Mysql-Proxy Server (IP: 192.168.190.142) and 03 DB servers, in there:
- DB Server 1: Read & Write
(IP: 192.168.190.41)
- DB Server 2: Read
(IP: 192.168.190.144)
- DB Server 3: Read
(IP: 192.168.190.145)
I checked the DB Server 1 (Read & Write OK) & DB Server 3 (Read OK)
And DB Server 2 never read.
#vi /etc/mysql-proxy.cnf
[mysql-proxy]
user=root
proxy-address= 192.168.190.142:3306 #IP, port of proxy server
proxy-backend-addresses=19 2.168.190. 41:3306 #IP, port of DB server for writting
proxy-read-only-backend-ad dresses=19 2.168.190. 144:3306 #IP, port of DB server for read
proxy-read-only-backend-ad dresses=19 2.168.190. 145:3306 #IP, port of DB server for read
proxy-lua-script=/usr/loca l/mysql-pr oxy/lua/rw -splitting .lua # script read-write
admin-lua-script=/usr/loca l/mysql-pr oxy/lua/ad min-sql.lu a # script management
log-file=/usr/local/mysql- proxy/log/ mysql-prox y.log #file log
log-level=warning
daemon=true
keepalive=true
Where is the parameter for round robin that I can declare in this configuration above? Is it right?
Please give me your advices about this issue.
Thanks in advance,
I have Mysql-Proxy Server (IP: 192.168.190.142) and 03 DB servers, in there:
- DB Server 1: Read & Write
(IP: 192.168.190.41)
- DB Server 2: Read
(IP: 192.168.190.144)
- DB Server 3: Read
(IP: 192.168.190.145)
I checked the DB Server 1 (Read & Write OK) & DB Server 3 (Read OK)
And DB Server 2 never read.
#vi /etc/mysql-proxy.cnf
[mysql-proxy]
user=root
proxy-address= 192.168.190.142:3306 #IP, port of proxy server
proxy-backend-addresses=19
proxy-read-only-backend-ad
proxy-read-only-backend-ad
proxy-lua-script=/usr/loca
admin-lua-script=/usr/loca
log-file=/usr/local/mysql-
log-level=warning
daemon=true
keepalive=true
Where is the parameter for round robin that I can declare in this configuration above? Is it right?
Please give me your advices about this issue.
Thanks in advance,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for ldvhai's comment #a40129118
for the following reason:
OK, Thks,
Accepted answer: 0 points for ldvhai's comment #a40129118
for the following reason:
OK, Thks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, solved, thks.
ASKER
Thks for your help.
ASKER