Tagged Questions
2
votes
1answer
115 views
Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
We have two mysql servers running in master - master configuration.
Now we have to add a slave to the existing configuration.
But upon adding the third DB server and starting slave on it, it throws
...
0
votes
2answers
126 views
Need advises for a new MySQL architecture
I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up:
Scale of deployment
5 servers with a ...
2
votes
1answer
45 views
Created databases and inserted data on MySQL slaves in Master-Slave replication - how to fix?
I got MySQL Master-Slave replication running on 1 master with 2 slaves. SHOW MASTER STATUS / SHOW SLAVE STATUS says they are in sync, but databases have been created on the slaves and filled with data ...
2
votes
1answer
285 views
Safely promoting master to slave
Previously I've asked the similar question MySql Switching Masters During Failover with log-slave-updates.
Let's say this is our current replication
In addition, I have few application servers. ...
0
votes
1answer
582 views
MySQL 5.5 not starting after master-master configuration
The following master-master configuration worked on MySQL Server 5.1.x(Ubuntu 10.04).
Master1(192.168.2.80)
##################################
#MySQL Replication
##################################
...
