Separate DB
Should I use a separate db for each blog domain I set-up?
|
Advantages to seperate DBs: (As I see them)
More flexibility (you could do a huge change to one, but not the others) If one goes down, you have other ones (assuming that one doesnt bring your service down) Disadvantages: (as I see them) Updating means updating each database in turn You can't easily link information together (share links tables etc) |
Quote:
Now I have seperate databases for everything and keep backups forever. |
Quote:
Using one database may be easier to back up and update but one corruption and all blogs are affected while using multiple databases may be a hassle to back up and update but it's worth it especially if corruption happens. In that case, only one blog is affected, not all of them. I also have to point out that nowadays, backing up and updating your blogs are made easier with plug-ins that do them automatically for you. |
My take is that it really depends on Your server resources ... too many DB's can slow Your server down (happened to me) once it hits a loot of traffic (though cashing pages might help and keep overload down).
|
All times are GMT -4. The time now is 02:45 AM. |
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc