I can speak first hand to this having gone through it just a few
months ago . .
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.
I immediately jumped to Postgres to do the job (using 8.3).
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.
Also having used MySQL extensively, I decided to give it a test run on
a separate set of boxes.
I'm not exaggerating when I say the replication was up and running in
about 10 minutes.
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.
Just my two cents . .
- Darren
_____________________________
[EMAIL PROTECTED]
http://www.darrensessions.com
http://www.linkedin.com/in/dsessions
_____________________________
On Aug 3, 2008, at 12:26 PM, Tzafrir Cohen wrote:
On Sun, Aug 03, 2008 at 08:13:30AM +0100, Grey Man wrote:
We use Postgresql which does a good job but
the big problem with it is redundancy. Postgresql does not really
have
an industrial strength replication solution
Hmmm... is that really the case?
--
Tzafrir Cohen
icq#16849755 jabber:[EMAIL PROTECTED]
+972-50-7952406 mailto:[EMAIL PROTECTED]
http://www.xorcom.com iax:[EMAIL PROTECTED]/tzafrir
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
AstriCon 2008 - September 22 - 25 Phoenix, Arizona
Register Now: http://www.astricon.net
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
AstriCon 2008 - September 22 - 25 Phoenix, Arizona
Register Now: http://www.astricon.net
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
