HyperDB Support for Buddypress, or other means of distributing DB load
We have a Buddypress site with over 18,000 registered users (in less than a month) and is still growing. During peak times, the SELECT queries go out of control and render the site unusable for minutes on end, unless we stop Apache and let the DB and PHP “catch up”. When I’ve tried to enable HyperDB, I get an immediate 404 on the home page.
What are the plans for allowing Buddypress to scale up to a usable social network? I have bug opened up on the Buddypress Trac: http://buddypress.trac.wordpress.org/ticket/4251
Are there other ways of distributing the DB load that is compatible with Buddypress? We already have the web/app and DB on separate servers, but either the queries/table structure for Buddypress need to be optimized or there needs to allow for multiple dedicated RO/RW servers.
- The topic ‘HyperDB Support for Buddypress, or other means of distributing DB load’ is closed to new replies.