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

I'm researching a topic of high availability database for a Rails application. I'm looking for Open Source based solutions.

At the moment our system is running on one application host + one db host, which means any of this two goes down I'm in trouble. I'd much prefer to have this configuration doubled and if possible running each on different site (but this is not a requirement).

The first thought was active-active replication, but it seems Postgresql is weak at this and MySQL is not rock solid neither (http://www.mysqlperformanceblog.com/2007/03/15/mysql-myisam-active-active-clustering-looking-for-trouble/). I'm thinking about a VoltDB, which seems like a sexy topic and can be used with Rails it seems.

Log sharing seems like a nice idea, but I'm quite new with this concept and I'm wondering about cost of such solution and how ie. MySQL is going to work with it. And it excludes any way of running the application at two different sites I guess.

I could really use some tips here, so feel free to ask questions and propose solutions. I'll edit this post to add any necessary information.

share|improve this question

2 Answers 2

You can use HaProxy.

You can configure Haproxy to be failover, replication , or loadbalancer

http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/

share|improve this answer
    
Hi, Thank you for mentioning HaProxy. I'm aware of it, but I'm little worried about master-master replication of MySQL (have you seen a link I've pasted in my post). In my situation I'd not use any slaves nodes (as they are unnecessary -- performance is not a problem for me). –  dpc.ucore.info Dec 2 '10 at 9:09
    
@dpc.core.info Your link is about Mysql clustering with myisam tables on shared disk storage across multiple servers. That's a very specific environment they are talking about. General master master replication with shared nothing servers is not that brittle. –  kashani Feb 11 '11 at 18:56

VoltDB supports HA natively, we actually want people to run it on a cluster of commodity servers.

share|improve this answer
    
Just found this VoltDB and it looks very scalable. –  Matt Jul 9 at 3:39

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.