Dear Mike,
> 1) To convert existing MyISAM tables, would it be as simple as issuing
> "ALTER TABLE foo ENGINE=NDB" ?
Yes.
> 2) I'm hoping the disk-based storage and other enhancements will get
> it closer to being transparent to using MyISAM, but having the data
> and workload be clustered and HA. However, are there some glaring
> things that cluster will still lack in 5.1? I believe full text
> support is still not going to be supported (however I am fine with
> that myself...)
Full text support is not supported. Full list at
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations.html
Remember if you are dealing with large databases that Indexes are
still in-memory.
> 3) Would anyone sanity check me here: would spending extra money to
> get a U320 15K RPM SCSI drive system vs. a SATA2 10K RPM drive system
> be even worth it anymore? I tried finding some benchmarks or other
> things that would be relatable to using MySQL on Linux - but couldn't.
> I'm still not sure if even with the latest SATA enhancements if SCSI
> still has advantages that will be obvious once a load is put on the
> system.
Probably you would be fine with the STATA2 drives - the IO load of a
MySQL cluster is not that huge.... although remember that almost all
of it is writes rather than reads (very different to a standard MyISAM
db!)
> 4) How many nodes (realistically) could MySQL cluster scale to?
Technically 64 (inc. 1 mgm node).
Once you get above 8 they recommend something other than ethernet to
connect nodes (SCI interconnects etc.)
Best wishes,
Alex
> Thanks in advance for your time!
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
--
Alex Davies // http://www.davz.net
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender immediately by e-mail and delete this e-mail permanently.
Contact me - MSN: a_davs@stripped SKYPE: alex.davies
