It's the Postgres Age

Re:It's the Postgres Age by sciurus on Wednesday May 23, 2012 @03:14PM (#4014789)

"I seriously want someone to tell me just ONE feature that MySQL has over Postgres. I ask everybody this question, and I haven't heard a single thing. "

Built-in two-way (aka master/master) replication.

[ Parent | on HN ]

Re:It's the Postgres Age by mratzloff on Wednesday May 23, 2012 @03:17PM (#4014797)

Amazon RDS support.

[ Parent | on HN ]

Re:It's the Postgres Age by dickeytk on Wednesday May 23, 2012 @03:52PM (#4014974)

RDS is awful. The interface is shitty and buggy, offers graphs that you can't do anything with, the backups cause our system to fail every night, EBS backing has serious spiking problems, you can't access the replicas and it runs a shitty custom fork of MySQL

[ Parent | on HN ]

Re:It's the Postgres Age by mratzloff on Wednesday May 23, 2012 @06:18PM (#4015619)

Thanks for the warning. I was pricing it out but was wary because of weird problems I've experienced with EC2 and inflexibility of ELB.

For what it's worth, I've used Postgres in production systems with great success.

[ Parent | on HN ]

Re:It's the Postgres Age by dickeytk on Wednesday May 23, 2012 @03:25PM (#4014844)

Postgres has had solid replication since 8.4

[ Parent | on HN ]

Re:It's the Postgres Age by sciurus on Wednesday May 23, 2012 @03:57PM (#4015007)

It was only in Postgres 9.0, released in Septermber 2010, that support for a "hot standby" (e.g. master/slave replication where you can run read-only queries on the slave) was added.

MySQL has supported this since at least version 3.2.3, released in January 2001.

MySQL supports

• Single master to one slave • Single master to multiple slaves • Single master to one slave to one or more slaves • Circular replication (A to B to C and back to A) • Master to master

Postgres supports

• Single master to one slave • Single master to multiple slaves

(lists from http://www.theserverside.com/feature/Comparing-MySQL-and-Pos...)

[ Parent | on HN ]

Re:It's the Postgres Age by mhurron on Wednesday May 23, 2012 @03:37PM (#4014901)

It doesn't do two way, you have to go to 3rd party addons for that.

[ Parent | on HN ]