scrubbicus Posted June 6, 2009 Share Posted June 6, 2009 So I'm going to be making a network of websites and each of these individual websites I will want to use some of the same tables. I'm wondering if I should make one database for all the sites or make seperate databases for each website and then a database for all the information that each website will share. I've never tried to connect to two databases before I'm just curious which method will be best to approach something like this. Each website won't have that many tables so if I used one database it won't be super large. Quote Link to comment Share on other sites More sharing options...
RussellReal Posted June 6, 2009 Share Posted June 6, 2009 if you're on shared hosting, alot of the time they disallow remote connections.. if you make 12 sites, host them all on the same hosting package.. then it should work with no problem. If you are on a shared network and you absolutely MUST put each website on another hosting, than you might experience some problems. anything other than shared I think allows remote connections Quote Link to comment Share on other sites More sharing options...
scrubbicus Posted June 7, 2009 Author Share Posted June 7, 2009 Well no it wouldn't be on seperating hosting it would all be on the same host in the same MySQL just different databases. So I could connect to any of the databases through a simple mysql_select_db() but do I want to be selecting databases throughout my script or should I just use the same database for all the websites? Quote Link to comment Share on other sites More sharing options...
RussellReal Posted June 7, 2009 Share Posted June 7, 2009 uhm, any SHARED data, should go into a shared database, and any website-specific data should go in its own database. 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.