4 ms·
PostgreSQL may not be better on all possible points of comparison. PostgreSQL replcation alone isn't comparable to MySQL with Galera. I don't know enough about
by sciurus 14y ago
PostgreSQL may not be better on all possible points of comparison.
PostgreSQL replcation alone isn't comparable to MySQL with Galera. I don't know enough about the various extensions to PostgreSQL to know which ones could give you
* Synchronous replication
* Active-active multi-master topology
* Read and write to any cluster node
* Automatic membership control, failed nodes drop from the cluster
* Automatic node joining
* True parallel replication, on row level
* Direct client connections
in a reliable and perfomant manner. Keep in mind I'm just atarting to play with Galera, I haven't used it in production yet, but it's making my planned architecure much simpler to manage than the traditional MySQL or PostgreSQL replication approaches.
- baghali 14y agorepmgr[1] is a very good replication option for PostgreSQL [1]https://github.com/2ndQuadrant/repmgr https://github.com/2ndQuadrant/repmgr
- jvdongen 14y agoGood mention. A small correction though: repmgr is not so much an replication option for postgres as well as a handy toolkit for using Postgres's own replication features in a more convenient way.
- jeltz 14y agoFor write scalability there is the Postgres-XC project. I do not know if it is ready just yet to run in production but it is getting there soon otherwise.
- einhverfr 14y agoIt looks to me as if Postgres-XC is largely waiting for 9.2 to be released. It's basically PostgreSQL plus some patches that allow for write-scalable clusters. From the timing of their betas, it looks like they are largely following the 9.2 release schedule.