Tell me more ×
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.

I'm looking for information about both products and your experience would be a big help. I'm aware that Oracle RAC and MySQL Cluster uses different architecture and that Oracle RAC has single point of failure where MySQL doesn't, RAC scales vertically, MySQL Cluster horizontally, but in practice, I never had occasion to play with them. So far, I couldn't find any advantage of RAC over MySQL Cluster. Maybe you know something I dont? :)

UPDATE - WARNING


This question is not about MySQL vs Oracle and please do not write comments suggesting superiority of one of them. This question is about understanding the superiority (if any) of Oracle's RAC over MySQL Cluster, because in my case, this knowledge may help me decide which DB system to go for for my next project. What concerns requirements, there is only ONE sole requirement for RAC/Cluster: To scale, on high load and large db.

share|improve this question
4  
Do you have an actual problem to be solved using one of these, or is the question basically theoretical? :) – dezso Nov 13 '12 at 19:20
1  
Like phil says, this is really about requirements (and to some degree budget). If you throw MySQL + memcached on million dollar hardware with a read load and RAC on a couple of desktops then the discussion doesn't make much sense. – rfusca Nov 14 '12 at 1:11
1  
@Davita: ah, ok. Well sure. Same problem if you run your ndb nodes without redundancy/mirroring/whatever it's called in MySQL cluster. – Mat Nov 14 '12 at 8:43
3  
(Me not either.) Your question being a bit vague it naturally collects all sorts of opinions and unsolicited advice. You cannot prevent them doing that, and every such warning ("Hope I satisfied your curiosity, now if you don't mind, post only about the subject please") makes others a bit less enthusiastic (euphemism warning!) - and supposedly this is not what you want. – dezso Nov 14 '12 at 10:16
2  
"RAC has single point of failure" - What is the basis for this assumption? Any properly designed HA cluster will have no single point of failure. – Roy Nov 14 '12 at 10:52
show 18 more comments

closed as not constructive by Derek Downey, jcolebrand Nov 14 '12 at 15:37

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

Browse other questions tagged or ask your own question.