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:study:

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

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.

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

Hi Stefano,

You can have the hint from this link.

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...

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.