LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-20-2006, 01:18 PM   #1
Reptile
LQ Newbie
 
Registered: Oct 2006
Location: Bay Area, CA
Distribution: Red Hat ES, Fedora, FreeBSD, Solaris
Posts: 10

Rep: Reputation: 0
Common Pitfalls of Running MySQL 5.0 Cluster on Red Hat ES 4?


I'm setting up a test environment for my work, involving four Red Hat ES 4 machines and MySQL 5.0 Cluster. We want to test out the reliability and failover feature of Cluster to see if it will fit our needs and our particular environment. In any case, I wanted to know if there are any common pitfalls that I should know about, anything people have found to be a gotcha about setting up the clustered database environment.

I'm fairly experienced with Linux, I've got about a year's worth of practical experience under my belt. The real issue here, though, is that I have absolutely zero experience with MySQL. Up until this point, I've worked mainly with Microsoft SQL Server, (hence the reason I got put on this project: I know SQL and I have experience with database servers, in general). I've never really worked in a clustered environment before, let alone one using MySQL.

So far, I've read through the online documentation, I've done a couple of barebone-installs of the stand-alone MySQL server, and I've reviewed the procedures for installing the clustered environment. I've got the -max packages downloaded to each machine's /var/tmp/ directory, and I'm just now at the stage where I can begin installing the storage nodes, the MySQL node, and the management nodes. So, before I get too deep into it, are there any MySQL veterans out there that know of any pitfalls to watch out for, anything that may not be well-defined in the documentation?
 
Old 11-27-2006, 07:27 PM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
I don't know how much you know about MySQL website, but just in case, here are some useful links:

The cluster docs:
http://dev.mysql.com/doc/refman/5.0/...l-cluster.html

Migration Issues forum; MS-SQL
http://forums.mysql.com/list.php?60

Cluster forum:
http://forums.mysql.com/list.php?25

The latter sounds like it would be worth scanning for you.

The major thing I discovered when we built ours is that 5.0 (the only prod ver so far), is entirely run in RAM, ie it's not disk based like all the others I'ved used eg Oracle, Sybase (& MS ?).
I believe 5.1 will be.
BTW, 5.1 is avail for download as a beta.
You might want to check-out the release dates in case they match your schedule.

Good luck
 
Old 11-28-2006, 01:22 PM   #3
Reptile
LQ Newbie
 
Registered: Oct 2006
Location: Bay Area, CA
Distribution: Red Hat ES, Fedora, FreeBSD, Solaris
Posts: 10

Original Poster
Rep: Reputation: 0
Yup, I've got most of the documentation about the cluster from the MySQL website printed out by now. It's all been extremely helpful and very informative as to setting things up and getting me off the ground. I remmeber reading that the cluster is memory-based, and that they'd be moving to disk-based at some point in the future. The forum is very helpful, as well, a lot of my questions have been answered there. The trouble is that I couldn't get much insight from the users there, aside from being pointed off to the documentation. I think I was just looking more for someone with experience with setting up the cluster, and anything they learned by trial and error, that they felt would be worth knowing.

Thank you for the links, though, they were very helpful.
 
  


Reply

Tags
cluster, mysql


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 11:45 AM
MySQL InnoDB Failover and Red Hat Cluster Suite stefano65 Red Hat 1 11-18-2006 02:35 PM
cluster and common external storage device- bottleneck? kpachopoulos General 0 06-26-2005 08:35 AM
Red Hat Cluster Manager and NAS mikemillion Linux - Hardware 0 03-08-2005 11:05 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 07:50 PM.

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