Jump to content


Photo

Why Multi Databases ?


  • Please log in to reply
6 replies to this topic

#1 shesma

shesma
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 13 January 2006 - 01:59 AM

Hello,
After searching google to find a place to host my site I found many webhosts offer multi mysql db's on their plans.
What is the idea in using more than one database for your scripts ?
Wouldn't having your data spreaded over two or more db's make integration a little bit harder or at least takes more time in loading the page ?

waiting for your explanation guys..

Thanks

#2 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 13 January 2006 - 02:49 AM

I don't think you would use more than one database for one application - I'm guessing they include multiple DBs in the case of somebody hosting more than one system/application on their web server.
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#3 erisande

erisande
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 13 January 2006 - 03:21 AM

Right. For example, I need a database to run my personal webpages, PHPBB needs another, and PHPNuke needs the third... If you only have the ability to have one database, you wouldn't be able to run some other applications.

#4 shesma

shesma
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 13 January 2006 - 03:50 AM

[!--quoteo(post=336038:date=Jan 13 2006, 06:21 AM:name=Dood)--][div class=\'quotetop\']QUOTE(Dood @ Jan 13 2006, 06:21 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Right. For example, I need a database to run my personal webpages, PHPBB needs another, and PHPNuke needs the third... If you only have the ability to have one database, you wouldn't be able to run some other applications.
[/quote]

So you can't have all the tables in one db's ? will it interfere with each other ?

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 January 2006 - 04:02 AM

One project, one database -- sometimes they can interfere if they use tables of the same name -- there are no namespaces for MyISAM tables. And yes, integration is a royal pain across multiple DBs.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#6 shesma

shesma
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 13 January 2006 - 10:46 AM

Thanks for passing by fenway!

So if am intending to have a project that includes ( cms + email + blog ) it is recomended to integrate all of these in one DB at least to register the same name/pass at one step and to recall them after one login

oh and I will keep in mind to have unique tabel names ;)



#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 January 2006 - 07:49 PM

I don't know what you're referring to w.r.t. "register the same user/pass" -- put all of them in one DB. You can (and should) prefix the tables with cms_, email_, blog_ -- that way you shouldn't even run into table name problems. Good luck.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users