The master tag has no wiki summary.
4
votes
0answers
692 views
What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
This morning I noticed my SQL Log was filling with the following message.
The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the ...
2
votes
1answer
46 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
289 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. ...
2
votes
1answer
119 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
128 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 ...
0
votes
1answer
24 views
Should we always prefer clustering over a master-slave configuration if the goal is high-availability?
Given: I have two virtual machines on a SAN that I can use to host RavenDB.
Question: If my goal is high-availability, then should I always prefer clustering over a master-slave configuration?
From ...
0
votes
1answer
586 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
##################################
...
