I am currently hosting a subdomain on dreamhost with the main domain being hosted elsewhere. I went to my DNS provider and changed the A record for the subdomain (subdomain.mydomain.com) to point to the IP address that I found in the domain manager within the dreamhost control panel.
Now I am tring to setup a mysql database and I am having some trouble. I created the database with the hostname subdomainb.mydomain.com. The problem is I don't know what IP to enter in the A record like I did for the previous subdomain.
Do I enter the same IP as subdomain.mydomain.com or is there a different IP i have to use for subdomainb.mydomain.com?
How often will the IP's change on these subdomains?
Thanks so much as I am pulling my hair out looking through forums and wikis for the above answers.