MySQL InnoDB Failover and Red Hat Cluster Suite

stefano65 · 10-28-2006, 10:34 AM

Hello everybody,
I am going to setup a failover solution, that is 2 db
server (InnoDB as storage engine)with the second
starting when the first crashes, using Red Hat Cluster
Suite and a SAN to store the data files.
I would like to know if I must enable external-locking
option on my.cnf file. I am doubtful about it, maybe
it is not necessary, Red Hat Cluster Suite should
handle everything and InnoDB locks anyway the data
files, right?
Thanks for any help.
Stefano

stefano65 · 11-18-2006, 01:35 PM

OK, it works properly, at least it seems so!
For this forum's friends, a brief summary.
Do not use external-locking, only a server writes.
Binlog file is in the shared storage, too.
In case of crash of the active node, there is a switch to the stand-by node. The autorecovery starts, rollbacks the uncommitted transactions and InnoDB is started too.