Go Back   Data Center, Colocation, Cloud Computing, Storage, Dedicated Servers Forums > Server Rack / SAN/NAS Storage Forum > Cluster and Cloud Computing Discussion Forum

Reply

 

Thread Tools
  #1  
Old 10-06-2008, 06:53 PM
tom tom is offline
Member
 
Join Date: Sep 2008
Posts: 58
Default mysql clustering

Hi,

Did anyone configure mysql clustering in your environment? We are running linux. If you have any experience, please provide the starting point.
Reply With Quote
  #2  
Old 10-19-2008, 12:33 PM
Alexandre Alexandre is offline
Member
 
Join Date: Oct 2008
Posts: 72
Default

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
__________________
HostingZoom webhosting
-------------------------
Power, speed, reliability
Reply With Quote
  #3  
Old 10-24-2008, 06:48 PM
tom tom is offline
Member
 
Join Date: Sep 2008
Posts: 58
Default

Thank you. Have you done the clustering on CentOS? I'm running centOS 5 and would like to setup.
Reply With Quote
  #4  
Old 10-30-2008, 03:17 AM
taki taki is offline
Member
 
Join Date: Sep 2008
Posts: 38
Default

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.
Reply With Quote
  #5  
Old 11-12-2008, 12:56 PM
tom tom is offline
Member
 
Join Date: Sep 2008
Posts: 58
Default

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?
Reply With Quote
  #6  
Old 11-28-2008, 11:17 AM
john1544 john1544 is offline
Member
 
Join Date: Nov 2008
Posts: 30
Default

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.
Reply With Quote
  #7  
Old 01-30-2009, 05:20 AM
princee18 princee18 is offline
Member
 
Join Date: Jun 2008
Posts: 88
Default

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
Reply With Quote
  #8  
Old 02-24-2009, 03:43 PM
Alexandre Alexandre is offline
Member
 
Join Date: Oct 2008
Posts: 72
Default

Yes, it is a good manual!
__________________
HostingZoom webhosting
-------------------------
Power, speed, reliability
Reply With Quote
  #9  
Old 02-26-2009, 09:29 AM
Schumie Schumie is offline
Senior Member
 
Join Date: Dec 2008
Location: Thatcham, UK
Posts: 160
Send a message via MSN to Schumie
Default

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!)
Reply With Quote
  #10  
Old 02-26-2009, 08:18 PM
Alexandre Alexandre is offline
Member
 
Join Date: Oct 2008
Posts: 72
Default

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))
__________________
HostingZoom webhosting
-------------------------
Power, speed, reliability
Reply With Quote
Reply

Thread Tools

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 On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:13 PM.

Member Area



Data Center Industry Daily News


Cloud and Dedicated Hosting


Sponsors Managed Servers Sponsored by DedicatedNOW.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.