I don't think anyone has posted this yet. Matt has announced a new enterprise db class - the same one they use http://photomatt.net/2007/05/28/announcing-hyperdb/ the svn is at http://svn.wp-plugins.org/hyperdb/trunk/
Richard
I don't think anyone has posted this yet. Matt has announced a new enterprise db class - the same one they use http://photomatt.net/2007/05/28/announcing-hyperdb/ the svn is at http://svn.wp-plugins.org/hyperdb/trunk/
Richard
Holy Bat Sh*t!
/jaw drops
If it works as advertised...
bah... I'm speechless at the moment.
A rare occurance ;)
I'm an idiot. Someone care to clue me in?
drmike,
It's basically the wp.com db code.
Ah....
I looked at it for a bit. I see where it does multiple database servers with rollover but not where it does multiple databases.
Or am I missing it?
I glanced over the code and am wondering the same thing myself. I found the code where it generates a hash from the blog ID but can't seem to figure out how it manages multiple DBs.
So far the "HyperDB" mailing list has had nothing but introductions.
I'm looking at this:
Different tables on different databases/hosts
I'm wondering if we create like seperate accounts with special names like mysql1.my-mu-install.tld and mysql2.my-mu-install.tld, create databases within those and work with that.
Donncha, care to weigh in? Gotta admit that this is all Spanish to me. (I know some Greek...)
I just read through the code again and i'm still confused as to whether or not there are multiple databases involved.
I've got my own wp-db code that can run a wpmu install off of 16 or 256 databases and I don't see anything that looks like the code that would be needed to select a database.
Donncha?
I believe HyperDB is more focused on MySQL clustering and high availability. Waiting for Matt to give a detailed description now.
I haven't gotten a single post on that list. Signing up again...
You haven't missed anything. So far there's only been 25-30 introductions.
Yeah but I haven't gotten anything, not even those.
Hi Dr.Mike,
You can check out here:
http://comox.textdrive.com/pipermail/hyperdb/
It's all introduction :)
Actually I have been. Not getting the introductions though.
I don't usually bump threads but i'm really interested in getting some feedback on this from Donncha or Matt (or anyone at wp.com).
So, um, *Bump*
Waving helps. :)
I'll email Donncha in a bit pointing him to this thread. I know he's busy but there's a much better chance that he'll read the email than Matt.
If you'd like to get Matt's attention, offer up free sauce. lol
Seriously though, it seems that hyperDB is more of a framework then something "out of the box ready" for MU.
It's pretty nifty, so don't get me wrong, but to use for MU it would need modification.
At least that is what I got from it on quick glance last night.
I haven't even had time to look at the code yet so I won't be of much use to you just yet!
Donncha, you can't give us openings like that. Too many respondences come to mind.
Well we all missed the tutorial that Matt sent over. He mentioned that he had sent a link previously:
Link to the original post about the tutorial.
Hmm, I've been receiving mail from the mailing list and I missed that message.
Is the mailing list software working correctly?
I got the stuff from last night, so I guess it's working.
Just seems to be low volume at the moment.
Although, the link only refers to setting up mysql replication, not using HDB with it.
It is a handy guide for setting it up though, I refer to it fairly frequently when I dig into a new replication set-up, just for a good review since I don't do it everyday.
Well it was something else besides introductions...
Yep, that it was.
Wait, I know what it is...
They're picking on you, and coded the list like
if ($address = "dr mike's email") {
continue;
}
he he he
Alright, so from what I can gather this does not address multiple databases whatsoever. It just handles replication.
At one time I was told that wp.com was running on 4096 DBs with the blogs spread over the databases bases on a hash of the blog ID. Does anyone know if this has changed?
I can't see why it would change, really. That would be a massive data shift that would drive people nuts. The solution they've worked out seems to be working well for them from what Donncha keeps saying about it.
Overall, you're right. This isn't for breaking MU up across multiple DB's, or any of the "fancy schmancy" stuff we would think is directly related to WP.com.
Even the readme basically sums it up:
"HyperDB is an advanced database class that supports replication, failover, and federation."
It was my understanding that each datacenter had it's own set of live servers and backups when it came to the databases.
The readme also says:
Different tables on different databases/hosts
Gotta admit though that since this is leaning towards more wordpress, I doubt it would concern splitting databases. Duping yes. Spliting no.
I'm not sure, really Doc. I haven't combed it line for line, but from the area you reference in the readme it very well could support all that and does say "based" on WP.com as well.
Read/Write servers being labeled as replication though, is a little confusing. Maybe read/write "through" replication would be a better description.
What I didn't see on my "quick" glance was how it determines what to connect to. I really need to sit down with it one night, but my time is very limited at the moment.
I still think this is a cool offering though. ;)
I'm just saying that that's what the readme says. I didn't see anything in the code either to suggest spliting databases.
That and it does look like it's for regular wordpress.