Advanced MySQL Replication Techniques
Subject:   Replicating updates
Date:   2006-08-31 12:08:58
From:   giuseb
Hi Giuseppe, thanks for the great article from a beginner MySQL enthusiast.

Here's my question. While the proposed technique to avoid primary key conflicts for inserts seems very convincing, one topic I was sort of expecting to see covered is how to reconcile updates of the same record occurring at multiple nodes between replications.

Please excuse me if the question is off the mark for lack of knowledge...

Giuseppe :)

Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Giuseppe Maxia photo Replicating updates
    2006-08-31 12:24:21  Giuseppe Maxia | O'Reilly Blogger [View]

    In a circular replication system there is currently no mechanism to solve conflicts. So, if two nodes update the same record, the last one overwrites the previous record.
    In case of a INSERT of the same record with a UNIQUE key in two nodes, there is going to be a conflict. The replication paradigm can't handle it.
    If you were looking for a distributed database where multiple branches update a central repository, replication, with today's technology, is not your solution.
    There are plans to introduce conflict resolution mechanisms and multi-master systems in replication, but we are talking about version 5.2 or 5.3.