I want to run 2 separate MySQL Server for one PHP base web server, like as an load balancer way.
I have two CentOS machine and over that separately MySQL server only. so what kind of service should I use that both server are ruining concurrently, which mean the web server load would be both MySQL Servers.
Can be used Ha Proxy? Please suggest me.