[ale] MySQL Cluster

Jim Kinney jim.kinney at gmail.com
Mon Feb 20 13:40:40 EST 2012


PostgreSQL 9 supports master/master.

On Mon, Feb 20, 2012 at 11:32 AM, Geoffrey Myers <
lists at serioustechnology.com> wrote:

> 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
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>



-- 
-- 
James P. Kinney III

As long as the general population is passive, apathetic, diverted to
consumerism or hatred of the vulnerable, then the powerful can do as they
please, and those who survive will be left to contemplate the outcome.
- *2011 Noam Chomsky

http://heretothereideas.blogspot.com/
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20120220/265f132c/attachment.html 


More information about the Ale mailing list