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!

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/

On Apr 2, 10:59 am, Ed Murphy <emurph...@socal.rr.com> wrote:
> 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!

>> 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!)

On Apr 3, 11:27 am, "--CELKO--" <jcelko...@earthlink.net> 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? <<
>
> 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!

"pbd22" <dushkin@gmail.com> wrote in message
news:1175538756.772556.294980@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