3 ms·

Mysql has better replication (at this point). Postgres does seem to be catching up in that area.

by swsieber 9y ago

jimktrains2 9y ago
Better by what metric, and is it worth the hardship in every other area?
- Something1234 9y ago
  I think mysql supports multimaster, and other replication formats. Postgres just supports master and slave.
  - jimktrains2 9y ago
    Not true. https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling https://wiki.postgresql.org/wiki/Replication,_Clustering,_an... postgres has a variety of ways to do replication, including multimaster (mainly asynchronous). Core is also getting improvements that will make this easier to do without extensions, mainly through the infrastructure pglogicql brings. Until 5.7 I believe mysql required extensions to do multi master as well.
    - chronid 9y ago
      BDR is available in the open (aka for free :D) only up to PostgreSQL 9.4 though, and that's really the only somewhat-equivalent solution to MySQL multimaster IIRC.
      - jimktrains2 9y ago
        Also not true. 9.6 is supported and the next release (scheduled soon) will support 10. Those changes will eventually end up in 12. https://www.2ndquadrant.com/en/resources/bdr/ https://www.2ndquadrant.com/en/resources/bdr/ https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-master-postgresql/ https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-... I'm not sure what you mean by somewhat equivalent. Both are primarily asynchronous multimaster approaches.
        chronid 9y ago
        > (NEW! Postgres-BDR 2.0 on Server Version 9.6 Now Available!) 2ndQuadrant is proud to announce the availability of BDR 2.0 running as an extension to community PostgreSQL 9.6 for its support customers. You can now make full use of the additional features offered with PostgreSQL 9.6 while using Multi-Master Replication from BDR, fully backed by 2ndQuadrant’s world renowned 24/7 Production Support. Fill out the contact form below to get in touch with us. This suggests to me it's not really open to the public. And there is no release 2.0 on github (https://github.com/2ndQuadrant/bdr/releases https://github.com/2ndQuadrant/bdr/releases). Feel free to correct me if I'm wrong and the 2.0 release is accessible without a 2ndquadrant support contract (or reverse engineering the changes from the github repo branch, which pretty much ensures you're never going to production with it), I'm genuinely interested.

Mysql has better replication (at this point). Postgres does seem to be catching up in that area.

jimktrains2 9y ago

Better by what metric, and is it worth the hardship in every other area?

Something1234 9y ago
I think mysql supports multimaster, and other replication formats. Postgres just supports master and slave.
- jimktrains2 9y ago
  Not true. https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling https://wiki.postgresql.org/wiki/Replication,_Clustering,_an... postgres has a variety of ways to do replication, including multimaster (mainly asynchronous). Core is also getting improvements that will make this easier to do without extensions, mainly through the infrastructure pglogicql brings. Until 5.7 I believe mysql required extensions to do multi master as well.
  - chronid 9y ago
    BDR is available in the open (aka for free :D) only up to PostgreSQL 9.4 though, and that's really the only somewhat-equivalent solution to MySQL multimaster IIRC.
    - jimktrains2 9y ago
      Also not true. 9.6 is supported and the next release (scheduled soon) will support 10. Those changes will eventually end up in 12. https://www.2ndquadrant.com/en/resources/bdr/ https://www.2ndquadrant.com/en/resources/bdr/ https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-master-postgresql/ https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-... I'm not sure what you mean by somewhat equivalent. Both are primarily asynchronous multimaster approaches.
      - chronid 9y ago
        > (NEW! Postgres-BDR 2.0 on Server Version 9.6 Now Available!) 2ndQuadrant is proud to announce the availability of BDR 2.0 running as an extension to community PostgreSQL 9.6 for its support customers. You can now make full use of the additional features offered with PostgreSQL 9.6 while using Multi-Master Replication from BDR, fully backed by 2ndQuadrant’s world renowned 24/7 Production Support. Fill out the contact form below to get in touch with us. This suggests to me it's not really open to the public. And there is no release 2.0 on github (https://github.com/2ndQuadrant/bdr/releases https://github.com/2ndQuadrant/bdr/releases). Feel free to correct me if I'm wrong and the 2.0 release is accessible without a 2ndquadrant support contract (or reverse engineering the changes from the github repo branch, which pretty much ensures you're never going to production with it), I'm genuinely interested.