Welcome to WebmasterWorld Guest from 54.196.231.129

Forum Moderators: open

Message Too Old, No Replies

One Database for site and forum?

     
7:49 am on Oct 18, 2005 (gmt 0)

New User

10+ Year Member

joined:Feb 24, 2005
posts:15
votes: 0


Hello all,
I'm programing a database driven website and there will be a forum too. Should there be two databases, one for the site content and one for the forum? Or only one should do the work?
The traffic won't be enormous.
Any suggestions?

cheers babil

7:57 am on Oct 18, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 17, 2002
posts:1181
votes: 5


I presume you mean with something like MySQL and that you will have databases:

site (tables: articles, authors....)
forum (tables: messages, users, logs)

Best to keep them seperate as caching will be more efficient this way I believe. Also would be better for secuirty as you could set different permissions for each database incase a forum member managed to get hold of single password etc.

OK, in both cases table caching, or table permissions could do the same thing but it's easier to administer at the database level.

Another reason for having two seperate databases is that it would be easier to maintain backup scropts. You may want to backup the forum db every hour, and the site db every 24hrs. Again, this could be done with a single database but it's easier with two.

8:11 am on Oct 18, 2005 (gmt 0)

New User

10+ Year Member

joined:Feb 24, 2005
posts:15
votes: 0


hi,
thanks for the quick reply. It sounds very reasonable.
It is better to be on the safe side , even if it costs 1-2 euros more!
Thanks again
babils
3:19 pm on Oct 25, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 29, 2003
posts:424
votes: 0


i have all of mine in one db but it is a very small db and we couln't see spending the extra $$. The site does not make us any $$ nor do the forums and while I have sujested adding advertisments. the board feels that doing so would afect our unbias image. I think I would perfer to have multiple db but given the situation the single db works just fine