1

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?

1
  • 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, 2009 at 12:45

3 Answers 3

1

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.

1

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

1
  • 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... Aug 14, 2009 at 14:10
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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