Hi
I'm working with haproxy couple of days but I'm really desperate.
I think that is great tool but not easy to use.
*My problem **:**
*
I'm developing load balancing app with ha proxy and php websockets as my
backend servers and mysql database.
I want to send some DB queries to haproxy,which distributes them among
my servers and servers send them to the database. All I have on one
machine.. I don't have options to create virtual machines and so..
(Maybe this is problem)
I tried different possibilities how to do it but I failed. My last
attempt was : sending http post request with php curl,which includes my
sql query to haproxy. I found the problem that I can use php curl for
my apache server but no for haproxy or there is a another solution ?
I'm working on linux, of course.
HAproxy detects my backend servers. I see it in statistics report.
Maybe I'm doing all wrong and I didn't understand the concept of
haproxy. Is there any examples how to do it? I read a lot of
different articles about haproxy but solutions are only partly.
How is the mechanism?
How can I send my sql queries as http requests to haproxy which process
them and send them to the backend servers in php ? I didn't found
articles how to do it.
Maybe, I must read the whole documentation.(last option)
Thanks for answer
Maros