2 ms·
The thing that I can't find a simple answer to and it bugs me: master-master replication is pretty common in MySQL, is the MySQL implementation inherently flawe
by gtrubetskoy 11y ago
The thing that I can't find a simple answer to and it bugs me: master-master replication is pretty common in MySQL, is the MySQL implementation inherently flawed somehow but people are still using it (which would be against the spirit of PG, and rightly so), or is it something about Postgres that makes it specifically difficult to implement?
- creshal 11y agoMaster-Master in plain MySQL is incredibly hackish, but it's not that hard to design your database schema around these limitations and avoid conflicting writes in most real-life scenarios. Then there is Oracle's MySQL Cluster (never seen that in production, no idea how well it works) and Percona's MariaDB Galera Cluster, which… well: https://aphyr.com/posts/328-jepsen-percona-xtradb-cluster https://aphyr.com/posts/328-jepsen-percona-xtradb-cluster
- dboreham 11y ago>is the MySQL implementation inherently flawed somehow but people are still using it Yes. What MySQL calls "master master" is actually "master slave".