LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices



Reply
 
Search this Thread
Old 06-11-2006, 02:18 AM   #1
stefano65
LQ Newbie
 
Registered: Jun 2006
Posts: 3

Rep: Reputation: 0
Smile red hat cluster suite and mysql


Hello everybody,
I would like to clustering mysql using red hat cluster suite with a shared storage ( I do not want to use mysql native clustering because it is a all-in-RAM database and my database will grow very much) .
Is there a tutorial or a whitepaper that can show me how to do, explaining me, for example, if I can use innodb engine for mysql table or I have to use ndb engine? Does Clustering mysql with red hat cluster suite allow only a failover configuration or also a load balancing configuration is permitted?
Thanks a lot for any help.
Stefano

Last edited by stefano65; 06-11-2006 at 02:21 AM.
 
Old 08-09-2006, 01:53 AM   #2
jeflau
LQ Newbie
 
Registered: May 2006
Posts: 3

Rep: Reputation: 0
Dear Sir,
I here would like to get your help on guide me how may I setup the qmail clustering. My database is in Mysql, I do try and try for few month but still can't make it cluster. I do had installed the fedora core 4 + system-config-cluster in two PC. I do plug-in the two PC with cross cable and configure it using the system-config-cluster but fail. May you let me know Fence device for using a cross RJ45 Cable what should I put
 
Old 04-16-2007, 12:28 PM   #3
captsulu32
LQ Newbie
 
Registered: Oct 2006
Posts: 4

Rep: Reputation: 0
You should look into the HA (High availability) for mysql. It uses mounted partition space for cluster and can be used with mysql, innodb tables.
ndbcluster tables can work against you if your using lots of table joins or yoru database gets very large.

The way clustering works on joins in the API has to re-assemble the table on the fly and then eliminate the unwanted database before it can perform the query. This can severely slow down the query process.

Only consider mysql clustering if your going to be doing simple queries on an average database. MySQL even though it is an in RAM product. Can't keep up with queries when complex joins are being used.


RedHAT enterprise 5 has just been released which is something that is supposed to solve these issues by clustering together machines and using resources wisely. For both HA and failover. Have to tried working with it yet myself but the concept sounds interesting.



Quote:
Originally Posted by stefano65
Hello everybody,
I would like to clustering mysql using red hat cluster suite with a shared storage ( I do not want to use mysql native clustering because it is a all-in-RAM database and my database will grow very much) .
Is there a tutorial or a whitepaper that can show me how to do, explaining me, for example, if I can use innodb engine for mysql table or I have to use ndb engine? Does Clustering mysql with red hat cluster suite allow only a failover configuration or also a load balancing configuration is permitted?
Thanks a lot for any help.
Stefano
 
Old 09-09-2010, 07:19 AM   #4
sunnyfedora99
LQ Newbie
 
Registered: Sep 2010
Posts: 1

Rep: Reputation: 0
Redhat Cluster Suite

Hi,

I have used the Redhat CONGA Cluster Suite and it's one of the most easiest thing to setup. It's the next-gen of clustering systems.
I suggest you should try this out if you have any test labs.

Sunny
 
Old 09-10-2010, 06:12 AM   #5
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Debian, OS X
Posts: 1,274

Rep: Reputation: 99
Hi Stefano,

You can have the hint from this link.
 
Old 09-11-2010, 02:05 PM   #6
narsingthakur
LQ Newbie
 
Registered: Sep 2010
Posts: 1

Rep: Reputation: 0
Hi There Can anyone guide me how to configure 2 node cluster with postgresql database and the common storage is gnbd on 3rd node ... On Vmware --7 Os--centos 4.5

Thanx in advance...
 
Old 09-12-2010, 11:45 AM   #7
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Debian, OS X
Posts: 1,274

Rep: Reputation: 99
For Common Storage thing you can use openfiler on VMware. I have done it and it works pretty good.

See these links

http://www.youtube.com/watch?v=ui9QiEPZfGI
http://helpinlinux.blogspot.com/2010...openfiler.html
http://www.openfiler.com/community/download/

Get back to me if in case you find some difficulty.

Last edited by vikas027; 09-12-2010 at 11:47 AM.
 
  


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
Redhat Cluster suite magobin Linux - Enterprise 0 03-13-2006 07:00 AM
redhat Cluster Suite marpel Red Hat 0 01-19-2006 09:05 AM
Red Hat Cluster Manager and NAS mikemillion Linux - Hardware 0 03-08-2005 11:05 PM
Installation Oracle 9i Developer Suite on Red Hat Linux 7.3 akamol Linux - Software 3 03-01-2004 05:53 PM
Help required building Red Hat 9.0 cluster StressedLemming Linux - Networking 4 10-27-2003 06:07 AM


All times are GMT -5. The time now is 10:16 AM.

Main Menu
Advertisement
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