shesma Posted January 13, 2006 Share Posted January 13, 2006 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 Quote Link to comment Share on other sites More sharing options...
neylitalo Posted January 13, 2006 Share Posted January 13, 2006 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. Quote Link to comment Share on other sites More sharing options...
erisande Posted January 13, 2006 Share Posted January 13, 2006 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 Link to comment Share on other sites More sharing options...
shesma Posted January 13, 2006 Author Share Posted January 13, 2006 [!--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 ? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 13, 2006 Share Posted January 13, 2006 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. Quote Link to comment Share on other sites More sharing options...
shesma Posted January 13, 2006 Author Share Posted January 13, 2006 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted January 13, 2006 Share Posted January 13, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.