Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

up vote 0 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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.