I've just started looking at the MySQL clustering system. Reading through the documentation I'm getting the impression that I could have a number of API servers running, to which my normal mysql clients could connect, but this would mean that if one of the API servers failed, I'd have to arrange failover between the mysql clients and the API servers.

Alternatively, assuming all my tables can be converted to NDB I could make every single system that uses mysql into an API server, handling requests only from the that server, which should mean that there is no failover required for API nodes (and failover amongst the DB nodes is handled automagically anyhow).

Does that make sense, or have I misunderstood the documentation?

James