LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Password
Red Hat This forum is for the discussion of Red Hat Linux.

Notices

Reply
 
Search this Thread
Old 10-28-2006, 10:34 AM   #1
stefano65
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.
Stefano
 
Old 11-18-2006, 01:35 PM   #2
stefano65
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.
 
  


Reply


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 04:40 PM.

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