web operations

Master-Master Replikation

Written by  on Oktober 2, 2011

Warum es keinen Sinn macht in einer Multi-Master-Replikation auf mehrere Master schreibend zuzugreifen. Und ich behaupte mal, dass das nicht nur für Mysql sonder auch für andere Datenbanken oder Dateiserver gilt:

One of the most seductive traps to fall into is to believe that you gain anything by making more than one server in a replication topology writeable. The usual thought traps are, "I'll get more write performance" or, "All nodes will be equal and failover will be easier." Both are false.
You do not gain performance by writing to both masters in a master-master setup. All writes are sent through replication and must be repeated on every node, so it doesn't matter where they originate.

Web Operations: Keeping the Data On Time S. 211