0

My MYSQL servers are not configured properly with failover. I am thinking of using Redhat cluster or heartbeat. Also, I need to achieve all tasks w/ one floating IP since application does not know about multiple databases. Can someone suggest what route would be the very for best?

Has QUIT--Anony-Mousse
  • 76,138
  • 12
  • 138
  • 194
user1590462
  • 27
  • 1
  • 1
    Please tag more carefully. You tagged this as [tag:cluster-analysis] (aka: clustering), a data mining technique. You probably meant [tag:database-cluster] or [tag:failovercluster] instead. Yes, there is more than one term "clustering", not everybody is doing LAMP. – Has QUIT--Anony-Mousse Aug 19 '12 at 17:32

1 Answers1

0

If you decide on using regular replication I would recommend you using this:

MHA tool for MySQL replication high availability

I didn't have a good experience with the ways you want to use, they are not as good as a cluster and not so much better than normal replication with the tool I posted. I do believe you should take a look at this tool and maybe stick with regular replication or jump to serious HA with MySQL cluster. Configuring the cluster might be hard but using Several Nines Solutions things might be a bit easier.

Jake Armstrong
  • 569
  • 4
  • 21
  • You could think also about a multi-master replication, but I personally prefer MySQL cluster, since with multi-master you would end up also having replication to slaves from both masters to get HA, since multi-master would give you more inserts/sec only. anyway... – Jake Armstrong Aug 19 '12 at 10:20