Page 1 of 1

Naming a mysql server

Posted: Tue Jul 24, 2007 7:35 pm
by RobertGonzalez
Does anyone know what the proper search term would be for giving your mysql server a name? What I am looking to do specifically is create several servers on various machines that will be used for dev/test/prod. I want them to be named servers so we can connect to them from any other machine on the network. So...

On our dev machine right now, I can connect to localhost only. I want to be able to connect to mysql-dev.domain.com from anywhere in our network. I also want to be able to connect to mysql-prod.domain.com. Does anyone know what this is called or know what I should be searching for?

I am not ready to ask you how to do it as I have not even been able to search for it yet. All help is, as always, appreciated.

Posted: Tue Jul 24, 2007 7:49 pm
by Benjamin
google

jk...

The easy way would to just edit your host file and add the ip's for each name.

Posted: Tue Jul 24, 2007 7:53 pm
by Begby
I use monowall's DNS forwarder for this. Its like a mini dns server with a static table, it checks its internal table first, then forwards the request onto the main DNS server. You just have to set all your client PCs to use the forwarder as their DNS server.

This is also handy if you have say myserver.domain.com pointing to your public IP and that entry is published on your live DNS server. From within your network trying to access the myserver.domain.com pointer will crap out, but with a DNS forwarder you can map it to the private IP, then you can use that pointer from inside and outside your private network.

Posted: Tue Jul 24, 2007 8:06 pm
by Benjamin
Yeah I believe what your looking for would be a local DNS server. If these are linux boxes it shouldn't be too hard to setup, although I have never done it.

Posted: Wed Jul 25, 2007 3:21 pm
by RobertGonzalez
Thanks guys. I think that gives me enough to start searching properly.