Multiple DB servers or Multiple DBs in on DB server!
Posted: Sun Aug 10, 2008 8:58 am
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!
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!