[ale] MySQL Cluster

Geoffrey Myers lists at serioustechnology.com
Mon Feb 20 11:32:43 EST 2012


Chris Fowler wrote:
> 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.

I don't think Postgresql supports master-master, but I've not looked 
into it for a while.

-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson


More information about the Ale mailing list