mySQL NDB API

Crusty

Lifer
Sep 30, 2001
12,684
2
81
We're looking into some possible HA(high-availability) data storage for a near real time application. We'll be receiving real-time data starting around 5-10mbps and increasing over time. Mysql states that you can achieve 5-10ms sync latency between data nodes which should fit the bill for us considering we currently deal with external network latencies at least one order of magnitude higher. (FWIW we're going to be collocating with our data providers).

I've spent the majority of my morning reading up mysql cluster and I really like it's features so far. One of things I've noticed pointed out in several places is that to get the best performance we should access the data through the NDB API instead of a traditional mysql-server accessing the cluster.

I was wondering if anybody had any experience programming against the NDB API, and if so any thoughts about it?

If not, do you have any other recommendations based on experience? Cost IS a factor, so a $50,000,000,000 oracle license is out of the question :p