0

Is there any product that make mysql master/slave failover process easier? something that can happen automatically, rather than manually fix it.

Jean-Rémy Revy
  • 5,607
  • 3
  • 39
  • 65
myhusky
  • 90
  • 2
  • 9

2 Answers2

1

[... a bit later ... ;)

What are you calling "easier" ? There is pretty much solutions with MySQL :

  • MySQL Cluster, with NDB Engine (High availability solution but some limitations : no foreign keys)
  • MySQL Master / Slave with their own replication system
  • MySQL replicated via DRBD and heartbeat.

There is a lot of material on this subject : Failover support for a DB and even more here : Scaling solutions for MySQL (Replication, Clustering)

MySQL cluster in an out of the box solution, but replication is not very difficult to set up.

Regards.

Community
  • 1
  • 1
Jean-Rémy Revy
  • 5,607
  • 3
  • 39
  • 65
0

The actual failover bit can be managed with heartbeat (part of the Linux HA project; http://linux-ha.org/), and I'm told that there's some tools in the MySQL Enterprise grab bag that helps with managing replication, although I've never used it myself.

womble
  • 12,033
  • 5
  • 52
  • 66