Jump to content

Archived

This topic is now archived and is closed to further replies.

shesma

Why Multi Databases ?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

[!--quoteo(post=336038:date=Jan 13 2006, 06:21 AM:name=Dood)--][div class=\'quotetop\']QUOTE(Dood @ Jan 13 2006, 06:21 AM) 336038[/snapback][/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.

 

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

 

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.