How Safe is Asynchronous Master-Master Setup?
- Track: MySQL, MariaDB and Friends devroom
- Room: H.2214
- Day: Saturday
- Start: 11:40
- End: 12:00
It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.
While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active setups.
In this talk, I will show how they did it, demonstrate situations when asynchronous master-master replication is the best possible high availability option and beats such solutions as Galera or InnoDB Clusters. I will also cover common mistakes, leading to disasters.
Speakers
Sveta Smirnova |