[ale] MySQL Cluster

[Chris Fowler]

On Sat, 2012-02-18 at 15:05 -0500, Michael Trausch wrote:
> You need some way to take out an atomic lock... or, use a message
> queue.
> 
> E.g., one system processes the new things and inserts their data into
> a message queue, and you can then have N workers (where "N" is "as
> many as needed on average) to pop things off the queue and send mails
> based on the content of the message.
> 
> --

Yea I know, but have one system (server) put things in a queue for the
other servers to process would defeat the cluster.  I'd like to have 3
servers anywhere in the US and then still run if 2 die.  These apps
would need to know the health of the others.  Bunch of work.

Normally this is one process on one server.  I want to make it redundant
and am ready to do Master-Master-N cluster.  I now do Master-Slave and
then promote the slave manually.