1
vote
0answers
151 views

MySQL master-master replication: “Lock wait timeout exceeded”

I am setting up master-master replication with MySQL. Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of ...
0
votes
1answer
510 views

MySQL Master-Master replication using MMM on Linode

Linode allows you have multiple IP's assigned to your node but I'm trying to setup MySQL Master-Master Replication with MMM following the guide on http://mysql-mmm.org/mmm2:guide. One part I don't ...
0
votes
2answers
668 views

How do I correct replicaiton on the primary master after reconfiguring replication in a MySQL-MMM cluster?

I have a MySQL-MMM cluster with three database servers (two masters and one slave). Recently replication was broken by someone directly inserting to the slave database servers. After I discovered this ...
0
votes
2answers
217 views

Remote Monitoring for Status of MySQL-MMM Monitoring Host

I have a simple MySQL-MMM setup with a dedicated monitoring host as described in their installation guide. I also have a separate monitoring system that is able to check status URLs so I'd like to set ...
0
votes
1answer
147 views

Downtime While Performing Maintenance on the MySQL-MMM Monitoring Host?

We have a MySQL-MMM environment with two masters, two slaves, and a monitoring host. We need to perform maintenance on the monitoring host (quick hardware replacement). I know that while the ...