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.

I am evaluating the options to build MySQL HA and found the below solutions

  1. Percona XtraDB Cluster,
  2. Tungsten Replicator, and
  3. MySQL Cluster.

Could you please help me to choose the best one with their pros and cons?

The Percona XtraDB Cluster, Does it change the InnoDB storage engine to XtraDB? Can I rollback to the MySQL native replication from Percona XtraDB Cluster?

Edited my Question.

share|improve this question
    
You haven't said what would be "pros" or "cons" for you –  jwbensley Aug 13 '12 at 12:48
    
You haven't even said what kind of application this is for. Note that MySQL Cluster is generally unsuitable for web applications. –  HTTP500 Aug 13 '12 at 14:41
    
    
it is web application developed on Magento E-commerce platform and PHP. –  Raj Aug 14 '12 at 8:38
    
Edited my question. –  Raj Sep 13 '12 at 12:01

3 Answers 3

up vote 2 down vote accepted

There is no ultimate solution, a proper solution depends on your needs. MySQL Cluster uses memory-only storage and fully synchronous protocol based on 2-phase commit. So, if you have a ot of data you will need plenty of RAM to use the MySQL cluster. Percona XtraDB Cluster uses synchronous replication too but from my own experience its replicator is not stable enough, I have had some odd problems with it. But if you don't expect high write load (say, you write only several records per sec) on your DB I'd recommend it. Tugsten Replicator seems to be asynchronous only. So, if you need synchronous replication go with MySQL Cluster or Percona XtraDB Cluster, if you can live without it, try Tungsten.

share|improve this answer
    
Thank you Alex... –  Raj Aug 14 '12 at 8:42
    
The Percona XtraDB Cluster, Does it change the InnoDB storage engine to XtraDB? Can I rollback to the MySQL native replication from Percona XtraDB Cluster? –  Raj Sep 13 '12 at 11:59
    
Yes, XtraDB and InnoDB are fully compatible –  Alex Sep 13 '12 at 14:23

I'm sure there is - but the effort involved, and the information you would need to supply goes way beyond what's possible to provide in a question / answer here.

Since your question is so wide of the mark, I would recommend you go seek profesional advice on what the best approach is - and plan on getting on-going support for the products.

share|improve this answer
    
If you have any experience or knowledge please share. –  Raj Sep 11 '12 at 14:50

It's not possible to say what is the best solution for you and your application without knowing more details about your system setup, but as a fourth suggestion I can give to DRBD (Drbd is a block device which is designed to build high availability clusters.) if you are running some kind of Linux OS..?

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.