Hi!
How is the overall experience like re. deploying openser with mysql clusters? Are there gotchas etc that need to be taken care of? (For example, a 2006 article [1] says that "The MySQL NDB engine currently runs its database completely in memory. This means that you have to be able to fit your database in memory." But this is not documented as a limitation in mysql faq.) Non clustered experiments were occasionally catastrophic, so can't risk taking that route again.
Somebody suggested using drbd [2], but I did not quite like it -- it needs kernel modules, has more administrative overhead, is tied to linux, it is not clear how consistency (ie, state of in-memory data and on-disk data) is taken care of, and in any case ndbcluster appears to be the clustering solution with official stamp of approval.
(Related - is postgres any better? Apparently postgres' clustering capabilities are "better", but then cdrtool etc seems to be written with mysql as the primary target.)
Thanks, Sajith.
[1] http://www.oreillynet.com/pub/a/databases/2006/02/16/ha_mysql_cluster.html [2] http://www.drbd.org/