Samantha Atkins wrote:
> Amazon cloud has great scalable MySQL support but apparently not postgreql. Why?
The perception is that MySQL has good built-in replication usable for
scaling up purposes, and therefore is suitable for cloud deployments.
Whereas the perception is that PostgreSQL has no such thing. There's
enough truth in both positions to keep both perceptions alive, even
though neither is completely correct. MySQL replication has some
serious limitations, and there are PostgreSQL replication solutions,
just not that ship with the software yet.
The pending 9.0 with obvious built-in replication is already shifting
how people are treating PostgreSQL for cloud deployments, a trend which
should just accelerate once the release comes out.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us