In practice, again in my opinion, multi-master replication is very
rarely necessary. You can achieve a more than sufficient degree
of failover capability in this direction using some combination
of high-availability server clustering and scripted state changes
between master and replica. For an outdated but workable example,
read: