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 :-)<br>
<br><div class="gmail_quote">On Mon, Feb 20, 2012 at 2:08 PM, Geoffrey Myers <span dir="ltr"><<a href="mailto:lists@serioustechnology.com">lists@serioustechnology.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="im">Jim Kinney wrote:<br>
> PostgreSQL 9 supports master/master.<br>
<br>
</div>Sweet. We are still on 8. Looking at migrating to 9 this year.<br>
<div class="im"><br>
><br>
> On Mon, Feb 20, 2012 at 11:32 AM, Geoffrey Myers<br>
</div><div><div class="h5">> <<a href="mailto:lists@serioustechnology.com">lists@serioustechnology.com</a> <mailto:<a href="mailto:lists@serioustechnology.com">lists@serioustechnology.com</a>>> wrote:<br>
><br>
> Chris Fowler wrote:<br>
> > On Sat, 2012-02-18 at 15:05 -0500, Michael Trausch wrote:<br>
> >> You need some way to take out an atomic lock... or, use a message<br>
> >> queue.<br>
> >><br>
> >> E.g., one system processes the new things and inserts their data<br>
> into<br>
> >> a message queue, and you can then have N workers (where "N" is "as<br>
> >> many as needed on average) to pop things off the queue and send<br>
> mails<br>
> >> based on the content of the message.<br>
> >><br>
> >> --<br>
> ><br>
> > Yea I know, but have one system (server) put things in a queue<br>
> for the<br>
> > other servers to process would defeat the cluster. I'd like to<br>
> have 3<br>
> > servers anywhere in the US and then still run if 2 die. These apps<br>
> > would need to know the health of the others. Bunch of work.<br>
> ><br>
> > Normally this is one process on one server. I want to make it<br>
> redundant<br>
> > and am ready to do Master-Master-N cluster. I now do<br>
> Master-Slave and<br>
> > then promote the slave manually.<br>
><br>
> I don't think Postgresql supports master-master, but I've not looked<br>
> into it for a while.<br>
><br>
> --<br>
> Until later, Geoffrey<br>
><br>
> "I predict future happiness for America if they can prevent<br>
> the government from wasting the labors of the people under<br>
> the pretense of taking care of them."<br>
> - Thomas Jefferson<br>
> _______________________________________________<br>
> Ale mailing list<br>
</div></div>> <a href="mailto:Ale@ale.org">Ale@ale.org</a> <mailto:<a href="mailto:Ale@ale.org">Ale@ale.org</a>><br>
<div class="im">> <a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
> See JOBS, ANNOUNCE and SCHOOLS lists at<br>
> <a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
><br>
><br>
><br>
><br>
> --<br>
> --<br>
> James P. Kinney III<br>
><br>
> As long as the general population is passive, apathetic, diverted to<br>
> consumerism or hatred of the vulnerable, then the powerful can do as<br>
> they please, and those who survive will be left to contemplate the outcome.<br>
</div>> - ////2011 Noam Chomsky<br>
><br>
> <a href="http://heretothereideas.blogspot.com/" target="_blank">http://heretothereideas.blogspot.com/</a><br>
> ////<br>
><br>
><br>
> ------------------------------------------------------------------------<br>
<div class="HOEnZb"><div class="h5">><br>
> _______________________________________________<br>
> Ale mailing list<br>
> <a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
> <a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
> See JOBS, ANNOUNCE and SCHOOLS lists at<br>
> <a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br>
<br>
--<br>
Until later, Geoffrey<br>
<br>
"I predict future happiness for America if they can prevent<br>
the government from wasting the labors of the people under<br>
the pretense of taking care of them."<br>
- Thomas Jefferson<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>-- <br>James P. Kinney III<br><br>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.<br>- <i><i><i><i>2011 Noam Chomsky<br><br><a href="http://heretothereideas.blogspot.com/" target="_blank">http://heretothereideas.blogspot.com/</a><br></i></i></i></i><br>