Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Red Hat This forum is for the discussion of Red Hat Linux.


  Search this Thread
Old 10-28-2006, 10:34 AM   #1
LQ Newbie
Registered: Jun 2006
Posts: 3

Rep: Reputation: 0
Question MySQL InnoDB Failover and Red Hat Cluster Suite

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.
Old 11-18-2006, 01:35 PM   #2
LQ Newbie
Registered: Jun 2006
Posts: 3

Original Poster
Rep: Reputation: 0
Thumbs up Ok

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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
red hat cluster suite and mysql stefano65 Linux - Enterprise 6 09-12-2010 10:45 AM
LXer: Nucleus Software Certifies FinnOne Suite Applications On Red Hat ... LXer Syndicated Linux News 0 09-01-2006 08:33 AM
Red Hat Cluster Manager and NAS mikemillion Linux - Hardware 0 03-08-2005 10:05 PM
Installation Oracle 9i Developer Suite on Red Hat Linux 7.3 akamol Linux - Software 3 03-01-2004 04:53 PM
Help required building Red Hat 9.0 cluster StressedLemming Linux - Networking 4 10-27-2003 05:07 AM

All times are GMT -5. The time now is 02:15 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration