If you're on EC2 they now offer Elastic Load Balancing which allows you to move away from the RR Dns setup many are using. If you have your own hardware and are looking for a Layer 4 load balancing solution take a look at http://www.ultramonkey.org/