Wednesday, February 08, 2006

Evaluating MySQL cluster (NDB)

Well, I've introduced a new Architecture to, called Federation. Federation is the idea that data is better to manage if it where spread across many servers instead of duplicated from a single master to many slaves. More on this later.

Now for NDB, mySQL's cluster Database, I'm evaluating it to see if it can provide a HA solution for a component of Federation. Federation in itself is HA, yet how do you know how to get to a particular shard?

Well there is a global lookup table to tell the requester where to go. This global lookup table needs to be HA, and here is where NDB comes in. NDB is very slow for range type queries so it doesn't make sense to use it for the entire federated arch, but it's reportedly good for primary key lookups, and this fits perfect for our lookup table.

More to come.


Post a Comment

<< Home