From: Martin Skold Date: July 1 2004 9:43am Subject: Re: setting up mysql cluster on smallish machines List-Archive: http://lists.mysql.com/cluster/67 Message-Id: <40E3DCAD.8080707@mysql.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Hi Javier! MySQL Cluster is planned to be a beta release in MySQL 4.1 and production ready as part of 5.0. BR -- Martin Javier Ramos wrote: >Thank you all for your input... >Another question: > > Is MySQL Cluster currently production ready, or should we consider it is >still early access code? > >Reggards, > > Javier > > >----- Original Message ----- >From: "Martin Skold" >To: "Devananda" >Cc: "Javier Ramos" ; "Jimmy Brake" ; > >Sent: Thursday, July 01, 2004 10:09 AM >Subject: Re: setting up mysql cluster on smallish machines > > > > >>Hi all! >> >>MySQL Cluster should be possible to run on both of these >>setups. Each ndbd process is partly multi-threaded and can >>utilize both processors efficiently. For larger SMP machines >>we currently recommend running several ndbd processes on >>the machine to better utilize the hardware. Fully multi-threaded >>(like the MySQL server, mysqld) database nodes are planned for >>future releases, but not in the near future. >> >>BR >>-- Martin >> >>Devananda wrote: >> >> >> >>>I also asked a similar question, but at the extreme opposite end of >>>the spectrum. >>>I would guess that no answer means that no one knows for certain yet, >>>as this product is >>>very young. Give it a go, hope for the best, run lots of benchmarks, >>>and let us know the results! :) >>>Once I can compile the cluster, I'm going to start doing just that >>>myself. >>> >>>-Devananda >>> >>>Javier Ramos wrote: >>> >>> >>> >>>>Mmmmm >>>> >>>>I asked a similar question some days ago and nobody answered... >>>>Should we >>>>interpret the quietness as a NO? >>>>This was my message... >>>> >>>> >>>>Hi, >>>> >>>> I have four identical machines available to test mysql cluster, and >>>> >>>> >I > > >>>>would like to know if someone out there can tell me if I can run with >>>>this >>>>hardware. I saw the recommended configuration and I realise that I >>>>have much >>>>less memory. Also, my databases are not very big. All four nodes I have >>>>available feature: >>>> >>>>* Dual Intel(R) Pentium(R) 4 (Xeon) CPU 2.40GHz >>>>* 2 GB RAM ( Much less than the suggested 16 GB, but my databases run >>>>smoothly with 800 MB dedication to mysql ) >>>>* SATA Raid 1 with two 120 MB IDE drives >>>>* I would have to install gigabit ethernet cards... >>>> >>>> can I run with this hardware? for testing purposes? for production? >>>> >>>> Thanks & best regards, >>>> >>>>Javier >>>> >>>>----- Original Message ----- From: "Jimmy Brake" >>>>To: >>>>Sent: Wednesday, June 30, 2004 7:20 PM >>>>Subject: setting up mysql cluster on smallish machines >>>> >>>> >>>> >>>> >>>> >>>> >>>>>Hi! >>>>> >>>>>We would like to setup mysql cluster on our cluster of Athlon 850 ~ >>>>>2200 >>>>>mghz servers that have between 512 to 1024 megabytes of memory per >>>>>machine and run Suse 9.0 as the OS. We have about 10 servers we can >>>>>dedicate to a mysql cluster. Will the mysql cluster software work on >>>>>machines this small as compared to the monster machine recommended on >>>>>mysql.com? If mysql cluster will work on these machines will the >>>>>performance be as good or better than the present production release >>>>> >>>>> >of > > >>>>>mysql? >>>>> >>>>>At present we have 2 mysql servers that answer about 60 requests per >>>>>second and are setup with in a master / slave setup. The load >>>>>average on >>>>>these machines is about .03 on average. Our small (family owned and >>>>>operated) business is growing at a modest pace and we would like to >>>>> >>>>> >not > > >>>>>invest in large machines and would prefer to continue to invest in >>>>> >>>>> >many > > >>>>>small machines(which we have had better luck with). >>>>> >>>>>Jimmy >>>>> >>>>> >>>>>-- >>>>>MySQL Cluster Mailing List >>>>>For list archives: http://lists.mysql.com/cluster >>>>>To unsubscribe: >>>>> >>>>> >http://lists.mysql.com/cluster?unsub=ramos@stripped > > >>>>> >>>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >>-- >>Martin Sköld, Software Engineer >>MySQL AB, www.mysql.com >>Office: +46 (0)730 31 26 21 >> >> >> >> >> > > > > > -- Martin Sköld, Software Engineer MySQL AB, www.mysql.com Office: +46 (0)730 31 26 21