List:Cluster« Previous MessageNext Message »
From:mike Date:January 14 2006 2:23pm
Subject:Hoping to use cluster in 5.1, but have some questions
View as plain text  
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!
Thread
Hoping to use cluster in 5.1, but have some questionsmike14 Jan
  • Re: Hoping to use cluster in 5.1, but have some questionsAlex Davies14 Jan
    • Re: Hoping to use cluster in 5.1, but have some questionsmike14 Jan
      • Re: Hoping to use cluster in 5.1, but have some questionsAdam Dixon14 Jan