New to the community? Start here

Multi-DB and Buddypress

Hey guys,

I would imagine it will become important for several of your clients to try and scale Buddypress at some point as well. Right now, there are some global BP tables that are easy to keep global. The tough one is the user tables that are created. They all follow the similar pattern as the blogs, but instead are based off the user id. Is this something you might entertain?

Thanks,

Trent

Tue, 11 Nov 2008 17:30:18
  • trent
    • Site Builder, Child of Zeus

    Just looking at this again and has anyone even have buddypress working at all with this plugin suite? It would look on the surface it couldn’t work as the logic for the multi-db code is all tables are not global unless specified and the buddypress tables currently would show up as global. Maybe if the plugin logic was all tables are global unless specified, but I might be missing something.

  • Luke
    • The Crimson Coder

    “Maybe if the plugin logic was all tables are global unless specified, but I might be missing something.”

    Yep. Think about it… what do you add more frequently to an MU install. Global tables, or blog tables (plugins, etc).

    Obvious answer here: blog tables. Much easier to drop a plugin in, and not worry about having to find any tables it creates to add them to the list. Where with global tables, it’s a more rare occurrence, and easier to manage.

  • trent
    • Site Builder, Child of Zeus

    I wasn’t saying the logic was wrong Luke, just that it won’t work under the current setup is all. I will leave it at that and see what you all think about the possibility of user hashing for databases :wink:

  • trent
    • Site Builder, Child of Zeus

    I stand corrected. Ron pointed out that is will work if you define all the main buddypress tables as global. What happens now is that all users including new ones go to the same DB as the main blog would. It works now, just all the user tables end up in that same database and are not split up.

  • drmike
    • DEV MAN’s Mascot

    This is on our todo list as well considering that buddypress has matured from what it was and how it’s now separated from the blogs.

    Have to admit that I’m torn as we already have a profile solution but are missing Groups.

    Maybe one of these days I’ll get caught up.

  • Andrew
    • Champion of Loops

    Hiya,

    When the first official version of BuddyPress is released I’ll look at ensuring the multi-db plugin will work with it. BuddyPress has had an interesting development period code-wise so I’m not keen on doing much with it until the first official release.

    Thanks,

    Andrew