4 points
Community rank #9334
jaber
NewbieJust Getting Started
MemberLikes (0)
Hi,
I want to install 4096 DB on my website.
I have more than 3000 blog on my site.
1. Is it support versin 2.7 ?
2. I wait to comming version 2.7 or now install it on version 2.6 ?
3. I want to install buddypress after installing multi data base on my site. Please regarding to these information help me to install multi data base with buddypress. Please tell me step by step instruction.
6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
Some quick math shows that for 50k blogs, a 256 db install would average about 5k files per db. That's well below the normal limits most OSes and hosting platforms place for files with a subdirectory.
Math:
50k blogs * 10 tables for each blog = 500k db tables.
500k db tables * 3 files per db = 1,500k files.
1,500k files / 256 dbs = 5,800 files per db.
For 4096 dbs, it would be less than 400 files for each db.
6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
I have to agree. That's what we're going for our installs.
If you;re concerned about future growth, you could always delete any blogs marked as spam or deleted by user. I'd wait 30 days or something similar. Leave time for an appeal by the end user.
edit: If you do go that route, please make sure you put something in your ToS about url reuse though. Cover your you know what.
Responses (7)
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
Multi-DB currently does not support WPMU 2.7. However, we'll be looking into this very soon.
As for whether or not it will work with BuddyPress, I'm afraid I can't answer that as I haven't tried it yet.
Lastly, if you only have 3000 blogs I wouldn't advise going with 4096 databases unless you plan on eventually having several hundred thousand or more.
Thanks,
Andrew
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
We discussed buddypress here:
http://premium.wpmudev.org/forums/topic.php?id=521
There should be a couple more threads as well if you want to search.
Member (joined January 2009) Likes (0)
Hi Andrew,
I want to develop my site to more than 50000 in future.
Now what's your idea?
Thanks.
Jaber
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Some quick math shows that for 50k blogs, a 256 db install would average about 5k files per db. That's well below the normal limits most OSes and hosting platforms place for files with a subdirectory.
Math:
50k blogs * 10 tables for each blog = 500k db tables.
500k db tables * 3 files per db = 1,500k files.
1,500k files / 256 dbs = 5,800 files per db.
For 4096 dbs, it would be less than 400 files for each db.
1,500k files / 4096 dbs = 366 files per db.
Erstwhile founder (joined May 2007) Likes (0)
I'd go with 256.
Thanks,
Andrew
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
I have to agree. That's what we're going for our installs.
If you;re concerned about future growth, you could always delete any blogs marked as spam or deleted by user. I'd wait 30 days or something similar. Leave time for an appeal by the end user.
edit: If you do go that route, please make sure you put something in your ToS about url reuse though. Cover your you know what.
Member (joined January 2009) Likes (0)
thx
i install 256 database
http://bloghaa.com
WordPress Questions?
We've got answers!
Find out more »