Multiple DB servers or Multiple DBs in on DB server!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
erinther
Forum Newbie
Posts: 19
Joined: Sun Dec 11, 2005 2:07 pm

Multiple DB servers or Multiple DBs in on DB server!

Post 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!
User avatar
ghurtado
Forum Contributor
Posts: 334
Joined: Wed Jul 23, 2008 12:19 pm

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

Post 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.
User avatar
Apollo
Forum Regular
Posts: 794
Joined: Wed Apr 30, 2008 2:34 am

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

Post 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.
Post Reply