Load Balancing Problem

[dracula]

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.

[williamc]

Hi Rudi, the problems you face are that it is not simply code that is required. The entire system has to be built in a way so as to be able to have servers brought up and down, the servers themselves need to duplicate IPs between themselves, you have the issue of making sure the backup machines are properly mirrored with the active machines so you dont have older copies of sites popping up and down, and some of this is going to require the host have things setup in a given way to be able to accomplish things.

That said, many hosts have a remote method to reboot machines, and you may be able to create an application layer that checks all the machines every [x] minutes/seconds and calls the remote reboot mechanism the host has in play to accomplish at least some method of keeping your boxes up and online.

[dracula]

Thanks William, yes I know, but we just don't have the right people available and don't lie to change the hosting we are very satisfied with. But we have a host who only offers the connection and root access to our own, now 6, dedicated apache servers. What we miss out is an experts monitoring and programming them in the way we need. We have grown very fast. Where we are located we can't find anybody to employ for this task.

[califmerchant]

well ... what type of queries are they? have you tried lucene or sphinx indexing?

[RajaSekar]

The first factor is that of the load balance. The computational work of each processor should be balanced, so that no processor will be waiting for others to complete. Assuming that the computational work per processor is proportional to the number of mesh nodes in the subdomain, then to achieve load balance it is necessary for the number of nodes in each subdomain to be the same.

[stougard]

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.

Apache has everything you need to make a quite powerful and reliable HTTP(s) load balancer. Google is your friend for the rest of it.

People who can do that for you are Linux System Administrator, a good one will make you that up and running in a few days at most. Do not search "load balancer specialist", they all will sell you an expensive (and useless) piece of hardware.

[dracula]

Apache has everything you need to make a quite powerful and reliable HTTP(s) load balancer. Google is your friend for the rest of it.

People who can do that for you are Linux System Administrator, a good one will make you that up and running in a few days at most. Do not search "load balancer specialist", they all will sell you an expensive (and useless) piece of hardware.

Thank You!
What you said is just what I did you confirmed to me that I did right - no expensive hardware -

[Keimos]

Hi,

A friend who even has a bigger site than ours, he programmed their own load balancer and it works good.

Why not ask your friend?