[ale] MySQL Cluster

Jim Kinney jim.kinney at gmail.com
Mon Feb 20 15:04:38 EST 2012


I have not set it up yet but 9 supports multi-master mode (i.e. >2
masters). I'm not sure how they do the locking (row vs. table) so that may
be an issue for performance, but then, high write systems are _not_ high
performance :-)

On Mon, Feb 20, 2012 at 2:08 PM, Geoffrey Myers <lists at serioustechnology.com
> wrote:

> Jim Kinney wrote:
> > PostgreSQL 9 supports master/master.
>
> Sweet.  We are still on 8.  Looking at migrating to 9 this year.
>
> >
> > On Mon, Feb 20, 2012 at 11:32 AM, Geoffrey Myers
> > <lists at serioustechnology.com <mailto: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 <mailto: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/
> > ////
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > 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
>
>
> --
> 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/01d16f4c/attachment.html 


More information about the Ale mailing list