Domanda di colloquio di Rackspace Technology

What issues might you experience in master to master replication using InnoDB as the primary database engine?

Risposta di colloquio

Anonimo

5 apr 2013

InnoDB is an ACID compliant storage engine which isn't truly supported via MySQL replication. Transactions that affect multiple rows could potentially result in a deadlock issue which would bring the database down.