Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We played a bit with postgresql and slony for a master-slave-slave replication setup on windows. But we hit a wall with failover/switchover which is very unreliable. How about MySQL? How reliable is the replication itself and failover/switchover?

share|improve this question
afair mysql [ at least in 5.0, 5.1 ] does not provide switchover. you need to have failover mechanism on your client or script around some 'virtual ip' handover. – pQd Aug 14 '09 at 12:45
up vote 1 down vote accepted

We use MySQL replication in part of our system and it seems to fail about 2-3 times a month. I'm not sure if it's a network issue or MySQL issue. I can say that it is quite annoying...

Most of our systems are in MS SQL and this replication is rock solid. We have not had any issues related to MS SQL failing replication. When there are issues, the alert/notification system lets you know immediately.

share|improve this answer

In what way was your PostgreSQL unreliable? There are a lot of people who use it reliably on Windows.

share|improve this answer
The replication itself is reliable. Its the switchover and failover that fails (tested with 8.2, 8.3, 8.4). Usually the final sync hangs, but sometimes its the subscribes... – EricSchaefer Aug 14 '09 at 14:10

You might consider using a multi-master arrangement rather than your current one, as it can solve most failover issues.

As for running on Windows, in my last role I ran a three way multi-master configuration with one on Linux and the other two on Windows, each in different parts of the country. In a bit over two years I never had a replication issue. Any one of those server could be off-line, relative to each other, at times for various reasons but would re-synchronise when they re-established contact with their peers.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.