The next presentation by Piotr Biel from Percona was on Multi-Master Manager for MySQL.
The introduction included a discussion of the popular MySQL HA solutions including:
- MySQL Master-slave replication with failover
- MMM managed bi-directional replication
- NDB Cluster
A key problem that was clarified in the talk is the discussion of Multi-Master and this IS NOT master-master. You only write to a single node. With MySQL is this critical because MySQL replication does not manage collision detection.
The MMM Cluster Elements are:
- monitoring node
- database nodes
And the Application Components are:
MMM works with 3 layers.
- Network Layer – uses a virtual IP address, related to servers, not …