1) To convert existing MyISAM tables, would it be as simple as issuing
"ALTER TABLE foo ENGINE=NDB" ?
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...)
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.
4) How many nodes (realistically) could MySQL cluster scale to?
Thanks in advance for your time!