<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I can speak first hand to this having gone through it just a few months ago . . <div><br></div><div>After being spoiled with all the features and standard compliance in Postgres, I was put in a position with a new project to setup a redundant (Master->Slave) database cluster.</div><div><br></div><div>I immediately jumped to Postgres to do the job (using 8.3).</div><div><br></div><div>My biggest gripe at the time was that there was really nothing built IN postgres to do the replication as I soon found out. Everything was third party and there were several replication modules suggested to me that seemed stagnant or un-maintained or required an older version of Postgres (bypassing the massive performance increase of the 8.3 release). Of those that I did try that were opensource, all of them seemed fairly complex to get up and running - to say the least.</div><div><br></div><div>Also having used MySQL extensively, I decided to give it a test run on a separate set of boxes.</div><div><br></div><div>I'm not exaggerating when I say the replication was up and running in about 10 minutes. </div><div><br></div><div>While I do appreciate (a lot) how standards compliant Postgres is, MySQL was an absolute clear winner in my book with regards to the replication.</div><div><br></div><div>Just my two cents . . </div><div><br></div><div> - Darren<br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br class="Apple-interchange-newline"><br></div><div>_____________________________</div><div><br></div><div><a href="mailto:dmsessions@gmail.com">dmsessions@gmail.com</a></div><div><a href="http://www.darrensessions.com">http://www.darrensessions.com</a></div><div><span class="Apple-style-span" style="font-family: Arial; line-height: 14px; white-space: pre-wrap; "><a href="http://www.linkedin.com/in/dsessions">http://www.linkedin.com/in/dsessions</a></span></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 14px; white-space: pre-wrap; ">_____________________________</span></font></div><div><br></div></span></div></span></div></span></div></span></div></span><br class="Apple-interchange-newline"> </div><br><div><div>On Aug 3, 2008, at 12:26 PM, Tzafrir Cohen wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On Sun, Aug 03, 2008 at 08:13:30AM +0100, Grey Man wrote:<br><br><blockquote type="cite">We use Postgresql which does a good job but<br></blockquote><blockquote type="cite">the big problem with it is redundancy. Postgresql does not really have<br></blockquote><blockquote type="cite">an industrial strength replication solution <br></blockquote><br>Hmmm... is that really the case?<br><br>-- <br> Tzafrir Cohen<br>icq#16849755 jabber:<a href="mailto:tzafrir.cohen@xorcom.com">tzafrir.cohen@xorcom.com</a><br>+972-50-7952406 <a href="mailto:tzafrir.cohen@xorcom.com">mailto:tzafrir.cohen@xorcom.com</a><br><a href="http://www.xorcom.com">http://www.xorcom.com</a> iax:<a href="mailto:guest@local.xorcom.com">guest@local.xorcom.com</a>/tzafrir<br><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com">http://www.api-digital.com</a> --<br><br>AstriCon 2008 - September 22 - 25 Phoenix, Arizona<br>Register Now: <a href="http://www.astricon.net">http://www.astricon.net</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></div></blockquote></div><br></div></body></html>