[ale] MySQL Cluster

[Geoffrey Myers]

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