Using one database for blog, forum, cms website a good idea?

[froggyboy604]

Is it a better idea to use one database to install your forum, blog, and CMS database driven website instead of multiple databases?

I think it is not really a good idea since if your one database goes down, deleted, or gets currupt you lose everything including your blog, forum, and CMS database driven website.

It also might cause slow down problems with your database if you have a lot of traffic for your blog, forum, and database driven website at once rather then using seperate databases. I also read that web host dislike it when your database uses too many SQL queries and calls since it can use a lot of server resources.

I guest it is a good idea for people who just want to backup one database at once to backup their blog, forum, website, and other site at once, or people with limited web hosting which limits how many databases they can make per web hosting plan.

 

[IcEWoLF]

Re: Using one database for blog, forum, cms website a good i

Well I'd suggest using one database and backup another database.
Honestly you will have lots of problems having multiple databases..

 

[froggyboy604]

Re: Using one database for blog, forum, cms website a good i

You are right, I once forgot to backup a database since I have so many, and lost one of my CMS websites. I think one database will probably be easier to manage, and backup, but I worry about if my one database got hacked or infected I lose everything if I did not back up recently.

But, would a web host get upset if your one database is very busy because your blog, forum, CMS, members site, and other sites are just using one MySQL database instead of 1 database for each website software like phpBB3, WordPress, Joomla, Drupal, etc?