Postgres 9.1 Replication vs MySQL Replication [closed]
Want to improve this question? Update the question so it's on-topic for Stack Overflow.
Closed 11 years ago.
开发者_如何学C Improve this questionSince Postgres now has built-in replication/clustering/HA support, how does it compare to the built-in features and functionality of MySQL replication/clustering/HA?
What are the PRO/CONs of Postgres vs MySQL related strictly to replication/clustering/HA capabilities?
Please don't make this a blastfest on one product over another. I'm simply looking for an objective matrix of features & support of the two products related strictly to replication/clustering/HA abilities.
UPDATE:
I found this very old comparison matrix. If someone updated it and included MySQL - that would answer my question.
--------------------------------------------------------------------------------------------------------------------------------------------
Product | License | Replication Method | (A)Synch? | Connection Pooling (Y/N) | Load Balancing (Y/N) | Query Partioning (Y/N) |
--------------------------------------------------------------------------------------------------------------------------------------------
MYSQL | | | | | | |
--------------------------------------------------------------------------------------------------------------------------------------------
POSTGRES | | | | | | |
--------------------------------------------------------------------------------------------------------------------------------------------
精彩评论