We have steadily grown and one by one we added web server for a market, than another web server for another market and another and another. We now have
4 web servers and one mysql database server running separate from each other.
We now wanted to put load balancing on them and looked at some hardware, we tried one but it did not work. A friend who even has a bigger site than ours, he programmed their own load balancer and it works good. If one servers produces errors the system automatically puts down this server and brings p a spare server up. He showed it to me and I was amazed. also their possibility of monitoring all the server loads was great.
I would like to have such a system for us as well and asked around. But all I get are "specialists" who want to sell me a whole new server system and hosting.
Trying to find specialized programmers in my area was unsuccessful.
My question now to you: Are on this forum specialists who can do such programing for us economically. We have around 200.000 queries to our servers during a 24 hour period.