Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 my vantage point, master-slave seems like more of a maintenance headache. Clustering seems much easier. [But perhaps I'm missing something.]

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Generally, Master-Slave is a disaster recovery setup: when master dies, slave becomes master. Manual intervention is needed or you need some redirection layer, You may also have replication lag built in so that master corruption can be stopped before it hits the slave.

Clustering is high availability: failover is automatic.

You need both HA and DR, not just one. You can have distributed clusters that mix it a bit, but generally the concepts are different.

If the 2 VMs are on the same physical host, this is neither HA nor DR of course.

If you do use clustering, then use Percona. MySQL cluster is broken in RDBMS terms

share|improve this answer

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.