New to the community? Start here

multi-db and dedicated db server

Hi,

Is multi-db necessary only when all are in one box (apache+mysql) or can it enhance the performance of a dedicated db server as well?

What is the deciding factor to go for a multi-db setup? Is it just the number of blogs or number of blogs+visitors+visitor activity? This is because I am planning to do an installation of wpmu with about 3000 blogs for a community. We do not expect much traffic / activity during the normal days. But they are expecting to have blog marathons for 2 days in every 3 months time.

Thanks

Sat, 10 Oct 2009 8:41:03
  • Andrew
    • Champion of Loops

    Is multi-db necessary only when all are in one box (apache+mysql) or can it enhance the performance of a dedicated db server as well?

    Multi-DB helps when you have a very large number of blogs regardless of your hosting situation (shared hosting not included).

    What is the deciding factor to go for a multi-db setup? Is it just the number of blogs or number of blogs+visitors+visitor activity?

    Blogs+hits.

    This is because I am planning to do an installation of wpmu with about 3000 blogs for a community.

    For 3K blogs I’d just go with 16 databases unless you plan on growing a lot.

    Thanks,

    Andrew