[wp-hackers] Max number of WP sites per MySQL DB

[Andy Skelton]

On Tue, May 11, 2010 at 12:58 PM, Otto <otto at ottodestruct.com> wrote:
> You might ask the WordPress.com folks. They're running one big
> installation, they can probably tell you how they've subdivided to
> help performance.

Very low-precision numbers follow.

We have 10^8 blogs spread across 10^2 master servers, each containing
10^3 databases.

So the number of blogs per database is about 10^3.

We developed a custom database class to deal with this and we released
the main parts of that code as HyperDB:
http://wordpress.org/extend/plugins/hyperdb/

Andy