Hi folks.

I've spent the last few hours reading on the web, on the archives of this list and in the mysql documentation packaged with version 4.1 on Debian.

Now this information does not appear explicitly on the site, and a bit vague from what I read, please correct the following statements so I know if I got it right...

* one can have as many NDB nodes as one wants, 2 being the minimum * one must have one management node, preferably NOT one of the NDB nodes, and it is a SPOF (if a node stops seeing it, it kills itself, hence if the management dies, the entire cluster dies with it) * one can have any number of API nodes but should take care that writes to a table are only taking place through one API node at a time, as no locking will protect him from shooting his own foot off.

In summary, If I want to have a two-node HA setup, I'm better off with a heartbeat check and a takeover routine that includes storage and IP address, and forget about the MySQL cluster. have I got it right?