Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th February 2008, 12:45
cooljai cooljai is offline
Member
 
Join Date: May 2007
Location: /dev/random
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to cooljai
Question from where to get MySql-max? regarding mysql-cluster

Hi,

I did lots of searching to download Mysql-max (binary/rpm) as per described in
http://www.howtoforge.com/loadbalanc...cluster_debian
but unable to find one .

At http://dev.mysql.com/downloads/mysql/5.1.html
the Server, client rpms etc. are listed but not MySQL-max. Can anybody please point me to the right direction?

thanks
__________________
Jagbir
Registered Linux User #468658.
Reply With Quote
Sponsored Links
  #2  
Old 6th February 2008, 13:17
cooljai cooljai is offline
Member
 
Join Date: May 2007
Location: /dev/random
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to cooljai
Default

to be more precise, I'm willing to setup the cluster on CentOS 4.4 in Amazon EC2.

Thanks
__________________
Jagbir
Registered Linux User #468658.
Reply With Quote
  #3  
Old 6th February 2008, 19:53
iyeat iyeat is offline
Member
 
Join Date: Dec 2007
Posts: 43
Thanks: 4
Thanked 1 Time in 1 Post
Default

All of the features of MAX are built in to the regular server distro now...

http://forums.mysql.com/read.php?117...167#msg-144167
Reply With Quote
  #4  
Old 7th February 2008, 07:32
cooljai cooljai is offline
Member
 
Join Date: May 2007
Location: /dev/random
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to cooljai
Default

Hi,

Thanks for reply. I also thought so but after installing 'Servre' I didnt found any 'mysqld-max' on my system. though, I didnt started building cluster yet to know whether I need any other package in this regard apart from 'Server' and 'Cluster tools'.
__________________
Jagbir
Registered Linux User #468658.
Reply With Quote
  #5  
Old 8th February 2008, 16:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Are you sure you need a MySQL cluster? The big disadvantage is that it holds all data in the RAM, so if there's a power failure, all data is gone.

I suggest you try MySQL Master-Master replication: http://www.howtoforge.com/mysql5_mas...on_debian_etch
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 9th February 2008, 05:51
cooljai cooljai is offline
Member
 
Join Date: May 2007
Location: /dev/random
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to cooljai
Default

Thanks Falko. I will give it a try.

Actually our need is to setup multiple mysql servers to share the load, data replication with a single point of access, something like you described in clustering.

As I haven't tried any approach yet, what you suggest to proceed in this situation: Cluster or Master-Master?

Regards,
__________________
Jagbir
Registered Linux User #468658.
Reply With Quote
  #7  
Old 9th February 2008, 19:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

If you have a single point of access, than this one MySQL server will always take the whole load, while the other MySQL servers are doing nothing.

If your web application is running on multiple nodes, I'd configure the nodes to connect to different MySQL nodes (the MySQL nodes all have the same data thanks to master-master replication).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Question about the hardware requirement for mysql cluster with load balancing??? johN5Five^ HOWTO-Related Questions 3 12th April 2007 17:06
MySQL Cluster - Tables not synced tfunky Server Operation 4 6th April 2007 22:22
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55


All times are GMT +2. The time now is 20:36.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.