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/
--
"the lyf so short, the craft so long to lerne."
-- Chaucer.