Naming The Database Server(s)?

[pbd22]

Hi.

Could somebody kindly tell me what conventions and best practices are
used when naming a database server (not the database itself) and/or a
cluster of database servers?

thanks!

[Ed Murphy]

pbd22 wrote:

Could somebody kindly tell me what conventions and best practices are
used when naming a database server (not the database itself) and/or a
cluster of database servers?

http://www.ietf.org/rfc/rfc1178.txt
http://namingschemes.com/

[pbd22]

On Apr 2, 10:59 am, Ed Murphy <[e-mail]:

pbd22 wrote:

Could somebody kindly tell me what conventions and best practices are
used when naming a database server (not the database itself) and/or a
cluster of database servers?

http://www.ietf.org/rfc/rfc1178.txth...ngschemes.com/

Hi.

Thanks for that.

I have some follow-up questions.

lets say that a database server has seven hard drives.
how would i handle the namespace? so, for example:

for www.somesite.com

would the database server and associated drives
look something like this:

database server:
data.somesite.com

various drives on the database server:
db1.data.somesite.com, db2.data.somesite.com, db3.data.somesite.com,
and so on...

anybody out there build a database cluster before? how
did you handle naming?

finally, I am noticing that really big sites such as yahoo and hotmail
use garbage in their namespace. So, for example, this is hotmail:

by138w.bay138.mail.live.com

is there an advantage to using a less obvious naming convention?

responses appreciated!

[--CELKO--]

>Could somebody kindly tell me what conventions and best practices are
used when naming a database server (not the database itself) and/or a
cluster of database servers? <<

The ISO-11179 Standards are for data elements names. No help there.
I guess you would have to use the prinicple of "least surprise" --
i.e. can someone in the field understand/guess the name used?

I know that geeks pick a theme like a TV show (Star Trek, South Park,
etc.). I worked at a shop that used the ethnic origins of the
personnel -- until I got there (nobody could spell "Czechoslovakia"
consistently, even me!)

[pbd22]

On Apr 3, 11:27 am, "--CELKO--" <[e-mail]:

Could somebody kindly tell me what conventions and best practices are

used when naming a database server (not the database itself) and/or a
cluster of database servers? <<

The ISO-11179 Standards are for data elements names. No help there.
I guess you would have to use the prinicple of "least surprise" --
i.e. can someone in the field understand/guess the name used?

I know that geeks pick a theme like a TV show (Star Trek, South Park,
etc.). I worked at a shop that used the ethnic origins of the
personnel -- until I got there (nobody could spell "Czechoslovakia"
consistently, even me!)

ok, thanks.
up until now i have been using musical compositions such
as "aria", "ronodo", "requiem", "cannon", "fugue", and so on.
but, i was afraid that this would be publically viewable so,
thought i would post. are database server names viewable
to the public? I am guessing no. So, if that is true, can you
tell me what server names "are" viewable to the public when
creating a medium-sized web site.

for example, in the example provided above:
by138w.bay138.mail.live.com

what kinds of servers would the following be:
by138w.bay138

sorry, i am just trying to get my mind wrapped around
namespaces.

thanks again!

[Greg D. Moore \(Strider\)]

"pbd22" <du*****@gmail.comwrote in message
news:11**********************@l77g2000hsb.googlegr oups.com...

for www.somesite.com

would the database server and associated drives
look something like this:

database server:
data.somesite.com

I tend to NOT do this, if only because if you have a "hole" in security it
makes things a bit easier to discover.

(Granted, security through obscurity is not a great idea, but at times it
can help a bit.)

>
various drives on the database server:
db1.data.somesite.com, db2.data.somesite.com, db3.data.somesite.com,
and so on...

anybody out there build a database cluster before? how
did you handle naming?

Database cluster named: FOO
Server1: FOO1
Server2: FOO2
ServerN: FOON

>
finally, I am noticing that really big sites such as yahoo and hotmail
use garbage in their namespace. So, for example, this is hotmail:

by138w.bay138.mail.live.com

That's server 138 in their bay area datacenter is my guess.

>
is there an advantage to using a less obvious naming convention?

responses appreciated!

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html