Skip to:
Content
Pages
Categories
Search
Top
Bottom

DB effeciency with BP in conjunction with other blogs and BBPress installations

  • Avatar of Lriggle
    Lriggle
    Participant

    @lriggle

    Edit: I believe I put this in the wrong forum. I thought I was in the Miscellaneous forum, so I apologize in advance.

    Hi guys!

    The project I’m working on is considering using BuddyPress for some social networking for an event that’s being run sometime later this year. I know BuddyPress can include a BBPress installation for an integrated forum system, and people can create blogs within BP as well. If there are other blogs/sites created within the WPMU installation (but not BuddyPress) and other BBPress installations as well, is it recommended that everything reside in the same database, or should things like the additional BBPress installations use a separate database?

    I don’t want to completely kill whatever server this could potentially end up running on, but quick response times and user integration between all platforms is key. The higher-ups estimate that there would be about 1,000 or so users for the duration of the event, if that gives any insight as to the scale of what’s being considered.

    Would a dedicated WPMU installation be a better idea, in conjunction with a second WPMU installation for integration with everything else?

    Thanks for any input you can offer!

    –Lisa

Viewing 3 replies - 1 through 3 (of 3 total)
  • Avatar of John James Jacoby
    John James Jacoby
    Keymaster

    @johnjamesjacoby

    There are a few multi-database WPMU plugins out there that help scale a website exactly like you’re talking about. I think the one that most people use is called HyperDB but I have no first hand experience with it. From what I understand, it’s also what wordpress.com uses to spread things around.

    A few users here have some solid knowledge of this, and hopefully they’ll chime in to give you some more specific suggestions.

    Avatar of Jeff Sayre
    Jeff Sayre
    Participant

    @jeffsayre

    Here is a great introduction by Trent Adams to the HyperDB plugin.

    As far as this issue is concerned:

    If there are other blogs/sites created within the WPMU installation (but not BuddyPress) and other BBPress installations as well, is it recommended that everything reside in the same database, or should things like the additional BBPress installations use a separate database?

    I don’t want to completely kill whatever server this could potentially end up running on, but quick response times and user integration between all platforms is key. The higher-ups estimate that there would be about 1,000 or so users for the duration of the event,

    In this scenario, splitting WPMU data between multiple databases on the same database server will not give you much of an advantage. In fact, it could even slow read/write down slightly. But, if this is a temporary site, which it sounds like it might be, then splitting the load between multiple DB servers is probably not realistic.

    The biggest issue will be how many web server and DB server cycles are dedicated to your domain and how many to other people’s domains. If you have a small hosting account, then you’ll absolutely need to upgrade to a decent VPS.

    Avatar of Lriggle
    Lriggle
    Participant

    @lriggle

    Yes, I do believe the sites are temporary. Even if they’re not, after the duration of the event, they will only be visible for posterity, and not as an actively maintained site.

    The final decisions regarding hosting haven’t been made though, and I will include this information in my reports and documentation.

    Thank you so much for the information!

    –Lisa

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.