When I ran a large network, machines didn't physically move very much (at least, far less often than their logical functions changed); we had a naming scheme based on datacenter code, rack ID and rack position:
sjc02-X0501-19
would be the machine in sjc02, rack X05.01, unit 19.
Far more important than the actual scheme you use is consistency. Pick one scheme and stick with it. Easier when you pick the right scheme the first time. :)
Not so great for SA's that are administering the boxes remotely, devs trying to figure out what machine they are on, or teams trying to troubleshoot an issue.
If a box is no longer a db machine, just rename it to something descriptive.
Most likely it's overkill - but I do like my pretty names as well.
For physical hardware, fancy names sounds pretty good, examples:
* group of mountains -> db servers
* group of bridges -> web services
* group of cities -> app servers (Kinda fun to say "Portland is down!")For some reason it just gave me a little tiny bit of excitement to get started on their service that wouldn't have been there if they were named the standard ns1., ns2., etc., and when you're just choosing from a random pool of DNS servers it doesn't really matter what the names are from an organization standpoint.
When you sign up for CloudFlare we provide you two unique nameservers when you sign up as part of the verification process. We can tell you are the owner of the domain you're registering if you change the nameservers to the two we provide you. In that way, it adds a layer of security in case two people register the exact same domain at the same time and we can't tell who should be authoritative. We figured that it was easier to remember and not typo two names rather than two random numbers (ns23 & ns67).
We commissioned an artist to draw 101 ninjas to represent CloudFlare's "Ninja nameservers." You can read more about them on the CloudFlare blog, including links to the Facebook page with all 101 illustrations:
http://blog.cloudflare.com/introducing-igor-alex-phil-isla-a...
I'm a big fan of the function###.IATA (or ICAO) code.
So like db1.pao, web3.sfo, m22.sin...
I don't do the 01 02 thing because that falls down at 99. :-)
I remember reading through the Bind file and seeing
# >10k machines? NEVER!
streamer0001.xxx...