[HyperDB] WP 2.7 testing?

[Callum Macdonald]

On Wed, 2009-02-25 at 00:02 -0800, Matt Mullenweg wrote: 
> Callum Macdonald wrote:
> > I'm a MultiDB developer so I'm also biased, I think it's more
> > appropriate for a mid-size site. I think HyperDB is better for wp.com
> > type scale, but for the "average" WPMU site, I think MultiDB has an
> > edge.
> 
> What exactly does it do that HyperDB doesn't?

I'm adding a feature to MultiDB that checks for existing connections at
the same priority and uses them if available. Both classes spread
queries at random between servers at the same priority level. Good
practice, but for an individual request, I think it makes sense to reuse
an existing connection if it already exists.

The method that maps a blog to a dataset is simpler in MultiDB. It can
be easily overwritten if a user wants to use their own custom method.
This is probably true of HyperDB also, but I think HyperDB's addition of
hashes makes it a little more complicated. Both an advantage and a
disadvantage I think. 

MultiDB comes with tools to create multiple databases (16/256/4096) and
create the config files automatically. I think that's a big help for new
users.

I was able to install MultiDB in about an hour whereas I'm not clear on
the process with HyperDB. I understand the steps to install, but how
blogs are split between servers, etc is not clear to me from the
documentation. I haven't read the code in sufficient detail to fully
understand it.

Cheers - Callum.