Topic: buddypress +multi-db issues

buddypress +multi-db issues

Anointed
Participant

@anointed

15 years, 2 months ago

I was planning on using the multi-db plugin for my wordpressmu + buddypress website.

However, on their forums I am told the following

You can use multi-DB with BP, BUT you may have to create the global BP tables manually.

Once they are created , BP should run fine. The other thing that you should do once the

tables are created is go through the main BP files and comment out all of the dbDelta

lines of code (one for each BP global table)

Are there plans to fix buddypress so that it will work properly with a multi-db setup?

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

Trent Adams
Participant

@trent

15 years, 2 months ago

Actually, it would be the other way around. dbDelta is actually a wordpress function that plugins can call to get upgraded. Andrew mentioned that this would all be sorted out with a plan to address buddypress by the multi-db 2.8 release. The reason you have to comment out all the dbDelta lines of code is due to a compatibility error that will fill your errors logs

As well, the search breaks with multi-db since it needs to call more than 1 database since one is global and one is for specific users information, it fails. It tries to find a member specific query in the global DB (since that is the one that is called first) and can’t find the info which causes an error.

The multi-db code also puts all user activity tables in the same DB right now (since it can’t spread them around without code to do so), so the only benefit you get is if you need this solution for multiple blogs. It actually created them all in the global DB when I used the move-blogs tool, but wanted to find them in the same DB as main blog. I had to copy all the user activity tables to that DB for it to work. If you start with a fresh install, it will create them in the right DB straight away.

Summing up, by WPMU and multi-db 2.8 and a 1.0 BP final release, it will draw more attention so that the solutions will have a clear goal to shoot for. This is a topic better suited in the Premium wpmudev forums as well I think. Glad to discuss it further there!

Trent

Anointed
Participant

@anointed

15 years, 2 months ago

Thank you for the explanation.

I will continue the conversation on the dev site.

bloggus
Participant

@bloggus

15 years, 1 month ago

Great explanation Trent. For me it seems like BuddyPress without a multi-db is like shooting yourself in the leg; nothing good will come out of it, if the site will grow big in a short time. Multi-db is of my opinion a must, but is seems like we will be waiting for it quite long time