Multiple databases for one websites

webnubie · #1 (**permalink**) 11-30-09, 01:23

I know if we host several websites on a web hosting account, we are recommended to create a database for each website. I just wonder if we need to create multiple databases for one website, say a database for each directory. Do we need to do that?

Crazzy · #2 (**permalink**) 12-01-09, 07:37

I am no expert on this matter but I guess it will depend on your personal preference. You can have as many different databases per website, depending on how you would want to organize your data and backups.

webnubie · #3 (**permalink**) 12-01-09, 08:17

Well, for me, the lesser databases to manage is the better

I have a small website and some blogs and I am fine with a database for each website/blog. But what about gigantic websites like Google, Yahoo and Amazon? I am sure their data is too complicated to store in a database.

Crazzy · #4 (**permalink**) 12-01-09, 09:52

Quote:

Originally Posted by webnubie

Well, for me, the lesser databases to manage is the better

I have a small website and some blogs and I am fine with a database for each website/blog. But what about gigantic websites like Google, Yahoo and Amazon. I am sure their data is too complicated to store in a database.

Me too, on DB per site/blog, it's way too easier. Since you're mentioning big companies, I can't imagine how organized their data centers must be in order to keep track of everything. It really sounds daunting.

Zohann · #5 (**permalink**) 12-09-09, 09:26

Quote:

Originally Posted by webnubie

Well, for me, the lesser databases to manage is the better

I have a small website and some blogs and I am fine with a database for each website/blog. But what about gigantic websites like Google, Yahoo and Amazon? I am sure their data is too complicated to store in a database.

I believe that less clutter the better it is. But depends on how you would want to organize stored data. Maybe you need some info that should be backed up regularly and some don't. Then you need separate DBs.

webnubie · #6 (**permalink**) 12-09-09, 19:48

Good point Zohann, thanks. I will keep in mind and apply it when my website grows more complicated. Currently it is still simple to manage, and no crucial data needs to be treated differently.

Zohann · #7 (**permalink**) 12-12-09, 10:47

You are welcome. I really believe that the less things are complicated the more efficient the site will work. That is why I suggested it.

srujana29 · #8 (**permalink**) 07-29-10, 08:12

Multiple databases enable you to organize your site's data more effectively

regards ,
phe9oxis.

RicherdsFi · #9 (**permalink**) 08-11-10, 15:09

I want to be really focused on being able to find a problem when the database slows down. I was advised to look for bottlenecks. What is the best way to go about doing that?