This seems very similar to the Amazon Route 53 Alias record which I've found quite useful for pointing to ELB instances:

http://aws.amazon.com/route53/faqs/#Supported_DNS_record_typ...