Dear people who understand the Domain Name System, please would you be so kind as to explain a few things to me.
Let's assume I have a single publicly accessible web server, with a single IP address and a single DNS address mapped to that IP address. For this example I'll use 123.123.123.1 and mysite.net.
I host multiple clients on this web server, and I accord each client a DNS address in the form myclient1.mysite.net. On incoming HTTP requests, I use the HTTP host header to determine which client is being accessed.
Let's say I would now like to create myclient99.mysite.net, except that I would like to point that particular client at a different IP address (a different server) with the address 123.123.123.99. Is that possible? How should I do this? I believe this is called a sub-domain, is that correct?
EDIT 1 : I should point out that the server is hosted by an Internet Service Provider and they set up the DNS for me originally. I think I would have to go through tech support to make changes. Should I be hosting my DNS records somewhere else?