mysql clustering

[tom]

Hi,

Did anyone configure mysql clustering in your environment? We are running linux. If you have any experience, please provide the starting point.

[Alexandre]

Hello,

The following link will help you to setup and configure such mysql cluster.

Howto:: MySQL5.1 Cluster

If you have any uestions just let m know

[tom]

Thank you. Have you done the clustering on CentOS? I'm running centOS 5 and would like to setup.

[taki]

Can you give me a example of what type of SQL database would need a cluster server to do its job? I would imagine it would be under a very heavy work load.

[tom]

We do run few heavy databases on our server, but some times it gets crash so we thought we can come up with mysql clustering solution. Whenever one of the server goes down, we want other server to take over its job.

Did you get my question?

[john1544]

On Linux its little difficult to configure mysql clustering. I know window enviornment.I dont know much about Linux.I think you will have to take search on net.That will help you better.

[princee18]

I could not access the link given by Alexendre but i have searched another link where you can easily know how to setup mysql clustering. Here is the link MySQL Cluster setup and HowTo

[Alexandre]

Yes, it is a good manual!

[Schumie]

MySQL clustering is great if you configure it correctly at the start.

Another option is to separate out your selects from your updates and inserts in your code and have a number of slaves which you query, and updates only go to the master (this is how I used to deal with it before MySQL had clustering ability!)

[Alexandre]

As for me, it is very important to configure everything properly at the start.
That's why so good to read some docs before installation but not after))