Page 1 of 1

Multiple DB servers or Multiple DBs in on DB server!

Posted: Sun Aug 10, 2008 8:58 am
by erinther
Hi,
I'm working on a project that uses several databases. Because I'm a newbie in this field, I would like to hear your advises:
In a dedicated server Which one is better:
1- Having two DB servers which each of them has a db, or one DB server with two databases? Which alternative will perform better?
2-Federated tables between two db servers or using view tables between two databases in the same db server?
Thanks!

Re: Multiple DB servers or Multiple DBs in on DB server!

Posted: Tue Aug 12, 2008 11:04 am
by ghurtado
A single database server will always consume less resources than two, and thus is the most sensitive option. I have never really seen a setup requiring more than one database server per host (barring edge cases, like virtual hosting, legacy apps... etc) . Not only that, but you can go across databases in a single SQL select within the same server, while you can't do the same with separate servers or separate hosts.

Re: Multiple DB servers or Multiple DBs in on DB server!

Posted: Tue Aug 12, 2008 11:30 am
by Apollo
Option 2 (one server with two DBs) and unless you really need to separate things into two different DBs (or have duplicate tables) you might as well use just ONE DB containing all the tables you need.