What are the alternate solution(s) for Load-balancing in MySQL database server

464 views Asked by At

Are there any better choices other than using MySQL-proxy to perform Load-balancing in actual database servers? MySQL-proxy is in its alpha edition. So I think this solution is not enough tested.

2

There are 2 answers

2
Mohit Thakur On BEST ANSWER

In market there are other paid tools are available which can handle load balancing, data availability and recovery in case of any disaster. TeraData and NEC Japan has many such kind of solution available in market for different-2 database servers.

0
Pradip Das On

You can use HAPROXY for Load-balancing in MySQL database server. Find details at below location: http://www.percona.com/live/mysql-conference-2013/sessions/load-balancing-mysql-haproxy